I'm having trouble using user variables and I hope someone can help,
My test environment is MySQL 4.1.11 on WindowsXP with MyODBC 3.51.11
If I open a command line client, I can do this
mysql> SET @A='Test';
Query OK, 0 rows affected (0.00 sec)
mysql> Select @A;
+------+
| @A |
+------+
| Test |
+------+
1 row in set (0.00 sec)
If I run the following in MySQLFront v3.1
Set @A='Test';
Select @A;
I get back same result
+------+
| @A |
+------+
| Test |
+------+
If I run the same query in MySQL Query Browser v1.1.6 I get this,
ErrNo 1060, You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ';
select @A' at line 1
and If I run the same query in my application I get the same error as the Query Browser.
Anyone know how I can get my application to give me what I'm looking for?
Thanks!
