Does Delphi have any way to escape symbols embedded in strings? I'm trying to write a database project, and have just run into a rather nasty problem; the db I'm working with, PostgreSQL, refuses to recognize equality to date functions unless the value being tested is contained within a pair of single quotes. It treats unquoted date strings as integers, and if I use double quotes, PostgreSQL tries to read it as the name of a column, not a data value.

Is there any way to escape the single quotes from within my sql statements I'm building in delphi, or do I need to look for a solution elsewhere?


Thanks in advance,
-EnderX

Recommended Answers

All 2 Replies

Thanks. That did the trick.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.