Subject | locate O'Connor |
---|---|
Author | delphigurusam |
Post date | 2005-09-27T23:51:52Z |
FB 1.5.2 B:4731
sql.strings[2]:='where
upper(Last_Name)='+#39+uppercase(dbeditLastName.Text)+#39+' ';
errors when dbeditLastName.Text contains an apostrophe (single quote)
in the name, as in O'Connor. The query reports that "Connor" is an
unknown token.
I know I should be able to figure this out, but I'm feeling brain dead
and I need this tonight (if possible). Anyone out there want to help
a "delphidummy"?
Thx
Sam Hunt
sql.strings[2]:='where
upper(Last_Name)='+#39+uppercase(dbeditLastName.Text)+#39+' ';
errors when dbeditLastName.Text contains an apostrophe (single quote)
in the name, as in O'Connor. The query reports that "Connor" is an
unknown token.
I know I should be able to figure this out, but I'm feeling brain dead
and I need this tonight (if possible). Anyone out there want to help
a "delphidummy"?
Thx
Sam Hunt