VBScript equivalent of AppleScript command

[gbandit]

Hi, I've been googling this for a while and can't seem to find the answer so I'm hoping someone here might be able to help.

Basically I am looking for pointers on how to reference FileMaker fields in VBS, of which I have no experience.

For example I have the following AS code which gives me an array from a portal row:

set Items to cellValue of cell "ItemIDNum::ItemName" of current record

How would I do this with VBS? I've tried variations of the following with no success:

Dim Items

Items = <>

TIA

[aholtzapfel]

You can't.

Through a VBS script you can do the following.

Open a file(local only)

Connect to a file.

Test if a script is running.

Run a Script.(Script folders can screw this up)

and that is it.

If you want vbs to change a field in filemaker you need to create a text file to import into filemaker, connect to the FM file, and run an import script. (there are other solutions using the webviewer but all follow this same idea. There may be a plugin that could do it.)

Link to a sample file.

[gbandit]

Ok thanks, that would probably explain why I haven't been able to find any info on it.

[fseipel]

You might want to look at the open source fmdotnet project -- at least, it allows setting fields in VB .NET -- however, it requires FMS Advanced and Visual Studio. But, .NET sure beats scriptmaker!

http://fmdotnet.sourceforge.net/ -- this sounds like a very promising project, though I haven't tried it, and site didn't mention FM10.

Another option, would be to use ODBC in the VB or VBSCRIPT project.

[Wim Decorte]

I still have to update the project for FMS10 but it should work without any issue as it is.

Remember that since 9 you don't need Server Advanced anymore to use the XML interface (which is what fmDotNet uses). fmDotNet now works against regular FMS9 and 10.

You are right about the advantages:

- it allows you to set fields directly

- it allows you to run a script on the server. *and* you can pass a parameter to the script

(downside: only web compatible script steps are supported)