At 10:54 AM 10/14/2011, Michael J. Sinclair wrote:
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!
FWIW ...
2011 Annual R:BASE Conference Package includes a sample database
and application that illustrates as well as demonstrates the use
of such techniques with R:BASE eXtreme 9.1. The application comes
with everything, including the source code, etc.
Conference Package: http://www.rbase.com/cp/
Application:
Automated Bridging of MS SQL Server Data into R:BASE eXtreme 9.1 (64)
You may recycle or adapt this technique into your own application(s),
even between R:BASE to R:BASE.
Have fun!
Very Best R:egards,
Razzak.