??accessing 2nd db when script runs in 1st 
Author Message
 ??accessing 2nd db when script runs in 1st

I am again having probs finding the way in FM5

I have written a script to run in db1 and would like to access db2 to import
records from db1 into db2. but all of my efforts so far have any effects on
db1 only and not on db2 as intended

I have tried to use hide for db1 then open db2 but no good
I have tried to close db1 but that cans the script totally

What to do..  What to do.. ??

I really like this program but the front end info is lacking in depth..

  ________________________________
          Jim Wallace
  http://www.***.com/ ~jwallace
   ________________________________



Fri, 27 Sep 2002 03:00:00 GMT
 ??accessing 2nd db when script runs in 1st

Show us the scripts you have so far and we'll see if we can help.



Quote:
> I am again having probs finding the way in FM5

> I have written a script to run in db1 and would like to access db2 to
import
> records from db1 into db2. but all of my efforts so far have any effects
on
> db1 only and not on db2 as intended

> I have tried to use hide for db1 then open db2 but no good
> I have tried to close db1 but that cans the script totally

> What to do..  What to do.. ??

> I really like this program but the front end info is lacking in depth..

>   ________________________________
>           Jim Wallace
>   http://www.crocker.com/~jwallace
>    ________________________________



Sat, 28 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ODBC corrupts year fields in access DB on 1st run only

2. Script fails when run 2nd time within same session

3. 2nd Index upsets changes order of 1st clustered index

4. Replace value of 1st record by 2nd record

5. help with query totaling 1st and 2nd result columns

6. result of 1st sql statement as criteria for 2nd

7. 2nd CFP - RULES IN DATABASE SYSTEMS - 1st Int'l Workshop

8. best way to relate a DB w/o a chg in 2nd DB then also changing 1st DB...

9. Script runs at prompt, does not run from script

10. Query runs only once, 2nd run makes PdoxDOS crash

11. Installing MSDE Db - Attach vs Running Script


 
Powered by phpBB® Forum Software