When I meet the character "%"...
-
In my vc++ codes, I must use the filter of the Object recordset to filter some records, I get the query term from a EditBox, but when the term include the character "%", the filter seems to meet some problem in deal with the "%", What should I do, some body tell me how please. What's more, when the operater is ">" or ">=", the filter meet the same error. Could some one tell me why ? Thanks advance.
-
In my vc++ codes, I must use the filter of the Object recordset to filter some records, I get the query term from a EditBox, but when the term include the character "%", the filter seems to meet some problem in deal with the "%", What should I do, some body tell me how please. What's more, when the operater is ">" or ">=", the filter meet the same error. Could some one tell me why ? Thanks advance.
Most databases require special characters to be escaped if they are part of sql. For some databases you can choose you escape sequence others have predefined '\'.... Characters '[,=+-&%#!@">