Michael, When you say foreign database, do you mean a non-R:BASE database? What is its native dialect of SQL?
Is the table PatInfo SATTACHED to your R:BASE database? Does your R:BASE connection have permissions to do updates when connected? Show us at least one specific combination you have tried, and what error message you got. Bill On Fri, Oct 14, 2011 at 10:54 AM, Michael J. Sinclair <[email protected]>wrote: > Hi All, > I am trying to update a foreign database from within Rbase 9.1 > Assume I have a foreign database named patient, with a table called patinfo > with a 2 columns, patnumbr (real) and scanddate (date). > I want to update the value of scandate with the value of vdate(date) for > the row that equals vpnum(real) > SO..... > Starting from scratch, including the sattach command, what is the syntax? > Every combination I try yields some kind of error message! > Mike > > >
