Just a thought -- since "append" is not a sql comment, and foreign (pun intended) to an odbc data source do you think changing it to an "insert" might avoid that connect screen? Of course you wouldn't be able to use the same-table subselect in an insert. Since the append is going into RBase I'm thinking not, but just a suggestion.
Karen > 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
