mysql 的order by
dm->InfoQuery->SQL->Add("select * from std ");
dm->InfoQuery->SQL->Add("where ID="+IntToStr(ID)+"order by age");
dm->InfoQuery->Open();
General SQL error [MySQL][ODBC 5.1 Driver][mysqld-5.0.67-community]You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the rught syntax to use near 'by age' at line 2'
Process stopped.Use Step or Run to continue
语句在linux下用mysql直接执行没有问题...
是BDE和ODBC的问题么？
[解决办法]
order by 前面要加一个空格
