-
Mark suggested I submit this feature request.
I have what I think is the latest sqlite3.dll.
VERSION returns "rexxsql 2.5 15 Oct 2006 WIN32 SQLite3"
This rexxsql does not support the SQLGetData() function with this sqlite3.
I have tried the SQLFetch() function to get the BLOB, but it returns an empty string value.
I presume because the first characters in the BLOB are 0x00s, which may...
2009-12-24 14:23:18 UTC by bobjewett
-
The attached patch is against the RexxSQL-2.5.tar.gz source tree. (There doesn't seem to be a cvs repository.)
When applied, RexxSQL can be compiled using ooRexx 4.0.0 as the interpreter.
On Windows use INT=OOREXX4
On a unix-like system using configure use --with-rexx=oorexx4
Tested on both Windows and Linux (Fedora Core 10) using MySQL. simple.cmd and tester.cmd run without errors.
2009-12-21 01:31:16 UTC by miesfeld
-
Usage error, not bug.
2009-11-26 01:41:43 UTC by rexx
-
My mistake. I have apparently not been making a proper distinction between connection name and statement name in my programs. You can close this as user error.
2009-11-26 01:32:33 UTC by dhughes
-
Oops. The call to SQLVARIABLE should be:
Call SQLVARIABLE 'AUTOCOMMIT', 0.
2009-11-25 23:44:21 UTC by rexx
-
Hi Don,
I haven't tried to replicate the problem, nor am I certain of what is causing the problem, however the following hopefully will result in the desired behaviour.
All commands are executing within the context of the second connection, so the DELETE statement is affecting the current cursor. You need a call SQLDEFAULTto ensure the commands are execting within the currect connection...
2009-11-25 23:38:55 UTC by rexx
-
I have attached the relevant bits of code.
I also left out some important information:
Linux SuSE 11.2
mysql client 5.1.36
regina 3.3 from SuSE
RexxSQL 2.5-2 locally compiled.
and the two sql commands use two different handles. Also, in the original, the two command were accessing the same table, but for the test above, I actually used two different tables. A dumpvars after the second...
2009-11-24 20:56:30 UTC by dhughes
-
Don, can you post the code that executes the two loops?
Thanks, Mark.
2009-11-14 07:58:50 UTC by rexx
-
Consider the following select:
SELECT *, DATE_FORMAT(Date, '%Y5m%d') as Datef FROM Table1;
If there is another SQL function performed inside the Sqlfetch loop such as
DELETE FROM Table1 WHERE Date='some value';
the values in the outer loop stop changing.
Here is a listing of the records retreived with inner call commeted out:
/www/work /www/work
*** Looking for changes...
2009-11-14 02:16:10 UTC by dhughes
