I have the following code which works in MySQL workbench and Navicat but not in my app
var sqltext as string
sqltext="SHOW COLUMNS from "+mytable
var rs as rowset =Helicondb.SelectSQL(sqltext)
I get an exception
Exception Message: near “SHOW”: syntax error
Exception Error Number: 1
Any ideas why?