Exporting from a Runtime

[gmannatl]

Exporting from Runtime

I am really hoping that this seemingly simple situation can be resolved in FM8 Advanced. Keep in mind that this has to be a runtime! I am working on an pplication where in one database I am required to have a looping script to parse constantly incoming data into a table. Thereby causing no user from being able to interact with the data being imported and parsed. So, what I need to happen is for this dbase to export the data to an external table. However, the "export records" script step in Scriptmaker will only overwrite previously exported data, with no way to append the data to an existing dbase.

What I have working from WITHIN Filemaker, is that I execute a SQL statement and insert the data into an "intermediate" access database via ODBC. This way my second runtime could get those records at leisure and purge them from the "intermediate" dbase. However, when the runtime is compiled, guess what? The Execute SQL statements in Scriptmaker are not supported via a runtime, and are simply skipped.

Next, I tried to build a relationship between file A and File B, and bind them together in the runtime. This did not work either, as there can only be one "primary" file in the runtime, and the looping script in File A seizes the application as if they were not seperate files.

Surely, this can be accomplised without a plugin!

Basically, what I need know is can one FM8 RUNTIME append data to an "intermediate" dbase, and then a second RUNTIME be able to also interact with this table to retrieve and then purge the records?

Thanks in advance for any help in a solution to this problem

 

[JeanW]

It's not very clear to me what you want and what the final outcome has to be.

It seems to me you're stuck in a SQL file or an Access file, so FileMaker will do nothing, hence skip the scriptsteps...

You export data, but nowhere mention you Import data.

As far as I can see now, but I can be totally wrong, your db design in Filemaker is wrong.

But again, I can't understand what you want...

 

[gmannatl]

All I am trying to do is get data OUT of one runtime, and IN to a second runtime.

 

[JeanW]

How are the links between the to files ?

 

[Schlogg]

gmannatl,
In your Runtime1,
Export records to TempFile.fp7
Perform Script[External] in Runtime2 (NewImport)
Exit script

In your Runtime2, script NewImport consists of -
Import records from TempFile.fp7
using whatever you need to get the data in the right place.

End of story.



Cheers,
Paul J.

 

[gmannatl]

As I mentioned in the original post, this will not work, because the export records script step will not APPEND data. This first runtime is constantly parsing information, and if I have this script looping and exporting records I am simply overwriting the previous records!! Now, I could have this export to a different file everytime, and then import ALL of the files into the second runtime, but that is more than just a little cluttered.

I have pretty much decided that an ODBC plugin is the way to go, but thanks anyway.

 

[Schlogg]

Sorry, gmannatl. Should have read your original post properly.
I have written out 200 times "I must READ posts before responding."

Cheers,
Paul J.