[RBASE-L] - Re: How do I avoid the Rbase Connect Screen in Rbase 7.6

[Michael J. Sinclair]

Thanks Bob! That worked!

 

Mike

-------------- Original message from "Bob Thompson" <ttc....@comcast.net>: --------------

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