Before your Append command enter
SCONNECT (your ODBC name)
This is assuming you have a System ODBC data source setup on your computer.
The other option is to use the "DNS- less" connection method such as
SCONNECT ';Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\Documents and
Settings\Administrator\My Documents\db1.mdb;'
which is found in the help files.
-Bob
----- Original Message -----
From: Michael J. Sinclair
To: RBASE-L Mailing List
Sent: Sunday, March 07, 2010 6:56 PM
Subject: [RBASE-L] - How do I avoid the Rbase Connect Screen in Rbase 7.6
Hi all,
I am trying to save a few key strokes. I want to add new rows from a table in
a foreign database to my currently open database. My syntax is...
APPEND patinfo_dup TO patinfo WHERE patnumbr NOT IN (SEL patnumbr FROM
patinfo)
The code works fine, but each time I do it, I get a pop screen called R:BASE
Connect. I think it wants me to enter the USER ID for Data Source: and Password
for Data Source:
Instead, I just click the OK button (I don't enter any thing in the 2 empty
boxes) and the program advances normally. What can I do to prevent this pop up
screen from showing up?
Mike
