I hop you got help enough! Last help seemed to be enough
With a foreign db update, insert and delete before you apply it to a foreign db Write yor R:BASE syntax and add SSQL befot your rbasesyntax In my case I se only inert and update, if yoy need a sampet plea k for it Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För J BLAUSTEIN Skickat: den 30 juni 2011 19:43 Till: RBASE-L Mailing List Ämne: [RBASE-L] - SV: odbc mysql Gunnar I am using Rbase commands - I can insert into a internal rbase database table using normal rbase command without any problem - why does my delete command only delete some of the rows - I try to used the set passthrough on and had no luck - the program just hang - what do you suggest the command be? should I use SSQL delete from a0account ( the name of the odbc table)? thanks once again j On 6/30/2011 1:25 PM, Gunnar Ekblad wrote: Hi Doing deletes to an ODBC dbs of any kind my understanding is that the delete command should be : SSQL delete rows from your table where .. So are yuy uaind DELTeE or SSQL deLete ? in yoy syntax? Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För J BLAUSTEIN Skickat: den 30 juni 2011 18:56 Till: RBASE-L Mailing List Ämne: [RBASE-L] - odbc mysql There was a discussion regrading rbase interface with odbc databases - I am having some problems - I am connecting to a odbc mysql database on the web - all the tables appear with no problem - if I try to delete rows within a table and there are 12 rows - the program will delete the first 7 then when I repeat the command it would delete the next 2 and then if I repeat the command it would complete the process. I try to create a command file with a while statement and the program error out. Its seen that there is a timeout or buffer problem. If I use Access and connect by odbc - the delete works on the first command. any ideas?? thank you for your help j -- J. Blaustein J Blaustein Associates, Inc. 12 Herrick Drive Lawrence, NY 11559 516-371-3445 FAX 516-345-8009 -- J. Blaustein J Blaustein Associates, Inc. 12 Herrick Drive Lawrence, NY 11559 516-371-3445 FAX 516-345-8009
