Import records closes database

[spud3712]

We are using FM 5.5. I have a database of customers set up. I have a script that select one record, opens the purchase order database, then runs a script in the po database to import the required information into a new record. This works perfectly, my problem is that when the import finishes it closes my customer database. It's not the end of the world just inconvenient because several time one customer will have multiple po's and I don't want to open the db each time and search for that customer. I have tried everything I can think of. The ironic part is on my test databases, (on my desktop), this doesn't happen. It only happened when I placed the databases on the server.

 

[JeanW]

Check your script sequence to see in which file it ends.

Chances are the script is doing the last step in your customer file, if the close step is just close(), the customer file will close.

HTH

 

[spud3712]

It ends in the PO database. The last step in the customer database is to run a script in the PO database. The last step in the PO database script is to import the record. Neither script has a close step.

 

[JeanW]

Revert your process, instead of pull the data, push the data in your database.
Ifthat is too difficult, add a step in your calling script, to make sure the last step (can be just a Go to Filed() step) ends up in the script in the customer file.

 

[spud3712]

Thanks for your help Jean. I had been working on pushing it instead of pulling it. I now export to a tab delimited file and import the tab file. Both databases stay open. My only problem was keeping the export order but I figured that one out on my own.