first of all I would try to rule out the possibility that the DB
specific driver is misinterpreting your SQL code. What DBMS are you
using? If you put together your complex SQL statement and try to call
directly the Tcl connector for the DB what happens?
-- Massimo
On 01-09-2013 0:19, Brice Hamon wrote:
Hi All,
I ran across a strange problem using the DIO interface over a Mysql
database.
When I run this sql command:
set sql "select * from records where userID=6"
set res [DIO exec $sql]
I get the expected result.
When I execute:
set sql "(select * from records where userID=6)"
I get nothing back.
Parenthesis are needed in some complex sql query I use so I need to
have them in my sql string.
I tried with: set sql "(select * from records where userID=6)"
with no luck.
Any ideas?
Thank you
B.
---------------------------------------------------------------------
To unsubscribe, e-mail: rivet-dev-unsubscr...@tcl.apache.org
For additional commands, e-mail: rivet-dev-h...@tcl.apache.org
