dbTalk Databases Forums  

Returning a path from a vbscript

comp.databases.filemaker comp.databases.filemaker


Discuss Returning a path from a vbscript in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ursus
 
Posts: n/a

Default Returning a path from a vbscript - 11-10-2006 , 05:33 AM






Fm 8.5 Adv, XP
I want to return a value from a vbscript to a field within filemaker. I am a
total nitwit as to vbscripting. I have made a start. Created a filemaker
script

let it execute the following

Const WINDOW_HANDLE = 0
Const NO_OPTIONS = 0
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.BrowseForFolder _
(WINDOW_HANDLE, "Select a folder:", NO_OPTIONS, "C:\Scripts")
Set objFolderItem = objFolder.Self
objPath = objFolderItem.Path

objPath does now hold the correct path (which I have checked with
Wscript.Echo objPath) but how do I now get the value ino a field?

I know this is perhaps a more vbscript related question, but those guys have
no idea how filemaker works. So I thought I tried here first.

Ursus



Reply With Quote
  #2  
Old   
Keith Hutchison
 
Posts: n/a

Default Re: Returning a path from a vbscript - 11-10-2006 , 09:54 PM






Hi Ursus

Ursus wrote:

Quote:
Fm 8.5 Adv, XP
I want to return a value from a vbscript to a field within filemaker. I am a
total nitwit as to vbscripting. I have made a start. Created a filemaker
script

let it execute the following

Const WINDOW_HANDLE = 0
Const NO_OPTIONS = 0
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.BrowseForFolder _
(WINDOW_HANDLE, "Select a folder:", NO_OPTIONS, "C:\Scripts")
Set objFolderItem = objFolder.Self
objPath = objFolderItem.Path

objPath does now hold the correct path (which I have checked with
Wscript.Echo objPath) but how do I now get the value ino a field?

I know this is perhaps a more vbscript related question, but those guys have
no idea how filemaker works. So I thought I tried here first.

There are a number of ways of doing this.

Probably the simplest way is to create a VB binary that passes
information back to the shell, ther pass a shell command out through
the shell using the free shell plugin from abstrak.
http://www.abstrakt.com/shell.html

Another way

Return Result through the Web Viewer (requires FileMaker 8.5)
http://www.connectingdata.com/Return...hWebViewer.zip

* The new Web Viewer feature in FileMaker 8.5 offers a new and
interesting way of returning a VBscript result to FM. Up to no we were
limited to pasting (not recommended) or triggering an import script in
FM. With the Web Viewer we can now have the VBscript write out a small
HTML page with the result and then trigger a FileMaker script that
scrapes the content of that HTML page into a FileMaker field. Try it
out...

Then you could pass info back via ODBC
or you could pass info back using XML.

Hope that helps.

Keith



Reply With Quote
  #3  
Old   
Ursus
 
Posts: n/a

Default Re: Returning a path from a vbscript - 11-11-2006 , 06:58 AM



Keith,

The second option you gave, just gives me exactly what I want. Thanks.

Ursus


"Keith Hutchison" <keith.kjtl.hutchison (AT) gmail (DOT) com> schreef in bericht
news:1163217280.580236.194130 (AT) h48g2000cwc (DOT) googlegroups.com...
Quote:
Hi Ursus




There are a number of ways of doing this.

Probably the simplest way is to create a VB binary that passes
information back to the shell, ther pass a shell command out through
the shell using the free shell plugin from abstrak.
http://www.abstrakt.com/shell.html

Another way

Return Result through the Web Viewer (requires FileMaker 8.5)
http://www.connectingdata.com/Return...hWebViewer.zip

* The new Web Viewer feature in FileMaker 8.5 offers a new and
interesting way of returning a VBscript result to FM. Up to no we were
limited to pasting (not recommended) or triggering an import script in
FM. With the Web Viewer we can now have the VBscript write out a small
HTML page with the result and then trigger a FileMaker script that
scrapes the content of that HTML page into a FileMaker field. Try it
out...




Reply With Quote
  #4  
Old   
Keith Hutchison
 
Posts: n/a

Default Re: Returning a path from a vbscript - 11-11-2006 , 03:36 PM



HI Ursus

Ursus wrote:
Quote:
Keith,

The second option you gave, just gives me exactly what I want. Thanks.

Your welcome :-)

Keith



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.