procedure TForm1.Button2Click(Sender: TObject); var ls_sql:string; begin ls_sql:='SELECT * FROM dqbzw WHERE (LEFT(RIGHT(CZ, 2), 1) IN (1,3,5,7,9))';// ls_sql:='Select * from dqbzw Where Convert(int,SubString(reverse(CZ),2,1))%2=1'; ADOQUERY1.Close; adoquery1.SQL.Clear; adoquery1.SQL.Add(ls_sql); adoquery1.Open; end;------------------ 出现非法列名错误
procedure TForm1.Button2Click(Sender: TObject); var ls_sql:string; begin ls_sql:='SELECT * FROM dqbzw WHERE (LEFT(RIGHT(cz, 2), 1) IN ('+ ''''+'1'+''''+','+ ''''+'3'+''''+','+ ''''+'5'+''''+','+ ''''+'7'+''''+','+ ''''+'9'+''''+'))'; ADOQUERY1.Close; adoquery1.SQL.Clear; adoquery1.SQL.Add(ls_sql); adoquery1.Open; end; 还是出现非法列名错误
Where Convert(int,SubString(N1,5,1))%2=0
Where Convert(int,SubString(reverse(N1),2,1))%2=1用这个
FROM TABLE1
WHERE (LEFT(RIGHT(N1, 2), 1) IN ('1', '3', '5', '7', '9'))
我知道你们的方法都正确,知道怎么处理这种错误吗?
var
ls_sql:string;
begin
ls_sql:='SELECT * FROM dqbzw WHERE (LEFT(RIGHT(CZ, 2), 1) IN (1,3,5,7,9))';// ls_sql:='Select * from dqbzw Where Convert(int,SubString(reverse(CZ),2,1))%2=1';
ADOQUERY1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add(ls_sql);
adoquery1.Open;
end;------------------
出现非法列名错误
var
ls_sql:string;
begin
ls_sql:='SELECT * FROM dqbzw WHERE (LEFT(RIGHT(cz, 2), 1) IN ('+
''''+'1'+''''+','+
''''+'3'+''''+','+
''''+'5'+''''+','+
''''+'7'+''''+','+
''''+'9'+''''+'))'; ADOQUERY1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add(ls_sql);
adoquery1.Open;
end;
还是出现非法列名错误