Ok, here is the line that I use from within an EEP... or from the R>
update patinfo_dup set scandate = .#date where patnumbr = 8000 The error message I get is... [RBTI][R:BASE ODBC Driver][patdb]-ERROR-More than 5000 characters or 400 items on input line ( 14) I get there error message even after I successfully bring up the line and then try to change the value of the column.... EDIT patnumbr scandate FROM patinfo_dup WHERE patnumbr = 8000 After I type the above line, I see the row with no error messages, but I get the error message when I try to manually update the column. Mike ________________________________ From: Bill Downall <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Friday, October 14, 2011 11:01 AM Subject: [RBASE-L] - Re: Help with Syntax for updating a foreign database 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 > > > >
