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
