Jump to content
Server Maintenance This Week. ×

Can a script open another DB, and perform a script located in that DB?


This topic is 8385 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Every day I need to import records from a primary dbase1 into 8 other db's, depending on the record type. I know I can perform a FIND in dbase1, and then open the targeted dbase and perform the IMPORT, but its tedious to do this eight times, and I'm a bit lazy laugh.gif" border="0. I know I can write a script to perform the eight FINDS in dbase1, but is it possible to include in that script, a comand that:

1) Opens up the target dbase

2) Commands that target dbase to import the records

3) closes that dbase, and moves on to the next FIND and target dbase

Then I could perform all 8 imports with one button click. Or am I going about this all wrong? Any ideas are welcome!

Link to comment
Share on other sites

Yes, you can run a script in another database. When you select the "Perform Script" step, you can select the script in another database. Also, you can open other databases with the "Open" script step.

As for whether you are going about this the right way, maybe you could just set up appropriate relationships between the other databases and your dbase1, and then have the other databases display the data from it without having to do any importing at all.

Link to comment
Share on other sites

This topic is 8385 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.