Question: I am a FMP 5.0 user......I need to write a scripe to retrieve info from our existing database......can someone point me to a resource that gives exampes of the scripting syntax.Thanks,
Do you intend to write the script in v5 or need to make the old file readable by a newer version of FM?
look on the computer that has the database or on the server. Unless someone deleted it, the FileMaker installer will put electronic documentation on the computer. I am pretty sure FMP5 did that too.
I did find the 5.0 user guide but it only had one partial example. I’m looking for a collection of examples that would show me examples of scripts. Any thoughts?
I’m trying to export a collection of records and specify which fields are exported. I routinely do this from the GUI, but I’d like to use a script. Have you written such a script? I suspect even in a newer version the scripting syntax is are similar. I’ll try looking at users guide for newer versions.
Here's a good resource from back in the day:
Scriptology: Filemaker Pro Demystified: Matthew Petrowsky, John M. Osborne, Matt Petrowsky, John Mark Osborne: 978096608…
Thank You….I will check it out…..
I don’t know if you are going to find a resource that has the script written out for you. I would like to suggest that you make a copy of your database and rename it and work on the copy.
I am trying to recall from memory but the basic steps may help you.
Your steps are going to be to find the records you want to include in your export. Then specify the fields you want, and then export to a file format which you didn’t specify.
Do this on the copy of your database.
The picture of the script steps below are v13 but you should get the general idea. Script Step names may be different.
I used Error Code >0 which is any error in the below example. There are other error codes that you could use that are more specific, but for this example I used error code 0.
Thanks for your comments.......and your cautionary note to make a copy of the DB before attempting to develop a script....good advice.
Retrieving data ...