I have an OracleDataSet Query in Delphi:
select * from t where
field1='asd--sdf';
it is error : ORA-01756 the query is not
right end.
but when I change:
select * from t where
field1=:field1;
DeclareVariable(Field1,otString);
SetVariable(field1,'asd--sdf');
it is right;
whether the char '--' is special character,but how to do?
Could give me any message? Thanks.
select * from t where
field1='asd--sdf';
it is error : ORA-01756 the query is not
right end.
but when I change:
select * from t where
field1=:field1;
DeclareVariable(Field1,otString);
SetVariable(field1,'asd--sdf');
it is right;
whether the char '--' is special character,but how to do?
Could give me any message? Thanks.
