Gunnar - thanks for your assistance - I try the command line: SSQL
delete from a0account (alias for account) and the program responded with
invalid file name - I then attempte to use ssq delete from account and
the program same error - what strange my insert and append command
works just fine - maybe it does not like delete function??
thanks once again
J
On 7/1/2011 1:05 PM, Gunnar Ekblad wrote:
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]>
[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*
