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.