Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Import records closes database

Import records closes database

Import records closes database

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.

RE: Import records closes database

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.


RE: Import records closes database

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.

RE: Import records closes database

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.

RE: Import records closes database

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close