J-- assuming you already have done sconnect and sattach
set var vCommand TEXT = ('delete from authorize where username = "usernomore" ')
SSQL &vCommand
James Kim
----- Original Message -----
From: J BLAUSTEIN
To: RBASE-L Mailing List
Sent: Thursday, June 30, 2011 2:59 PM
Subject: [RBASE-L] - SV: odbc mysql
On 6/30/2011 1:55 PM, Gunnar Ekblad wrote:
My understanding is still if you have an external db that is not r:base you
should always use SSQL FOR DELETE ? AND UPDATE operations
can you give me an example of the command - thanks
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
--
J. Blaustein
J Blaustein Associates, Inc.
12 Herrick Drive
Lawrence, NY 11559
516-371-3445 FAX 516-345-8009
