The date format is tricky maybe, it must be consistent in foregin db and urt db yours db fornat ,
Can you try it on other firld like integer or text within quotes? Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Michael J. Sinclair Skickat: den 15 augusti 2011 21:41 Till: RBASE-L Mailing List Ämne: [RBASE-L] - SV: Is it possible to update a table fom another database? Hi Gunnar, I tried this.... SSQL update patinfo_dup set birthday = 7/16/1960 where patnumbr = 4921 I did not get an error message, but the birthday did not change. What am I doing wrong? Mike _____ From: Gunnar Ekblad <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, August 15, 2011 3:31 PM Subject: [RBASE-L] - SV: Is it possible to update a table fom another database? Miku Sometimes you need to use SSQL update,,,, l always that use that on a foreign DB, sometimes I also use on a RBASE db Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Michael J. Sinclair Skickat: den 15 augusti 2011 21:22 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Is it possible to update a table fom another database? Hi All, Is there a way that I can update a foreign table while I am connected to a different database? If I am connected to Database2, and I have access to Table1 from Database1 via the SATTACH command, can I update Table1? When I tried to do that.... UPDATE patinfo_dup SET birthday = 7/16/1960 WHERE patnumbr = 4921 I got this... [RBTI][R:BASE ODBC DRIVER][patdb]-ERROR- More than 5000 characters or 400 items on input line ( 14) Is there a way to do it without disconnecting from the current database? Mike
