在使用SQLConnection和TSQLQuery访问MySQL数据库时
SQL为
sqlCardID = 'Select AutoID,CardID From PersonalBasicInfo Where CardID=:CardID Limit 1'CardId参数正常赋值,但访问AutoID字段时显示:SQLQuery1:Parameter 'AutoID' not found
而CardID就可以正常访问
SQL为
sqlCardID = 'Select AutoID,CardID From PersonalBasicInfo Where CardID=:CardID Limit 1'CardId参数正常赋值,但访问AutoID字段时显示:SQLQuery1:Parameter 'AutoID' not found
而CardID就可以正常访问
哪clientdataset先要从服务器fetch参数,才能赋值.