Hi Massimo, I haven't tried to call directly the TCL mysql module.
I am using mysqltcl-3.052 with a native 5.5.28-3.14.1 mysql installation. I was doing (select ...) union (select ...) when I got that problem. The query runs fine in MySql WorkBench. Strange isn't it. B. On Sat, Aug 31, 2013 at 7:05 PM, Massimo Manghi <massimo.man...@unipr.it>wrote: > 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. >> > >
