高手帮我看看Sql语句怎么错了??最好帮我写出正确的语句,50分相送,在线等待!(SelectFieldId是变量) ADODataSetQQery.Close ;
ADODataSetQQery.CommandText :='';
ADODataSetQQery.CommandText :='Select lstid,lstname,lstmrk From tablelist Where lstkind=:SelectFieldId';
ADODataSetQQery.Open ;
DataSourceQQery.DataSet :=ADODataSetQQery;
DBGridQQery.Refresh ;
ADODataSetQQery.CommandText :='';
ADODataSetQQery.CommandText :='Select lstid,lstname,lstmrk From tablelist Where lstkind=:SelectFieldId';
ADODataSetQQery.Open ;
DataSourceQQery.DataSet :=ADODataSetQQery;
DBGridQQery.Refresh ;
ADODataSetQQery.CommandText :='Select lstid,lstname,lstmrk From tablelist Where lstkind='+SelectFieldId+'';SelectFieldId字符串变量如果有可能出现数字
ADODataSetQQery.CommandText :='Select lstid,lstname,lstmrk From tablelist Where lstkind='''+SelectFieldId+'''';
ADODataSetQQery.Close ;
ADODataSetQQery.CommandText :='';
ADODataSetQQery.CommandText :='Select lstid,lstname,lstmrk From tablelist Where lstkind=:a';
adodatasetqqery.paramarter('a').asstring=selectfieldid;
ADODataSetQQery.Open ;
DataSourceQQery.DataSet :=ADODataSetQQery;
DBGridQQery.Refresh ;试试吧