我的代码如下:
qyUsersBase.SQL.Text := 'select LineNo, phone,email,address ' +
' FROM a' +
' WHERE Name1 like %:username% ' +
' ORDER BY LineNo';
qyUsersBase.Parameters.ParamByName('username').Value := Edit2.Text ; //报错Parameters ‘username’is not found. 匹配应该怎么写呢?
qyUsersBase.SQL.Text := 'select LineNo, phone,email,address ' +
' FROM a' +
' WHERE Name1 like %:username% ' +
' ORDER BY LineNo';
qyUsersBase.Parameters.ParamByName('username').Value := Edit2.Text ; //报错Parameters ‘username’is not found. 匹配应该怎么写呢?
' FROM a' +
' WHERE Name1 like :username ' +
' ORDER BY LineNo';
qyUsersBase.Parameters.ParamByName('username').Value := '&'+Edit2.Text+'&' ;
' FROM a' +
' WHERE Name1 like ''%username%''' +
' ORDER BY LineNo';