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*
