Quotes for SQL statements

Since this is an MFC application using MS-ODBC to get to the back-end, you'd be OK to use the single quote for all the strings to be passed in the Insert/ Update statements. I hope I got your question right. Ex:
INSERT INTO Items ( ItemCode, ItemName, Price) VALUES (112, 'Soap', 2.54)
should work regardless of the database. That's what the ODBC is for. But incase you have to send the single quote itself to the backend, ( like "David's Book" to be updated in one of the fields ) then it's a bit different. You should probably write a wrapper class around ODBC APIs and handle the single quote separately.
But for all normal insert/ updates the single quote will work.

sri_darr,

I could be wrong here, but are single quotes ok for Access databases?  Don't these require double quotes(")?

Carl,

Absolutely. Single quotes work fine for Access DB too. U shd hv no problem.

Carel,

This is the sort of thing I'm looking for.
However, I've looked all over the place for an example but can't find one for SQLGetTypeInfo that uses LITERAL_PREFIX and LITERAL_SUFFIX parameters.  Do you have a working example that I could use as reference please?

I will have an example in Win32 style that does what you want. I will have to look it up though tomorrow. Basically the API gets called and produces a result set. The literal prefix and suffix columns are two columns of that result set. Then what remains is a fetch. You might encounter a problem though since not all db support them. What we do and what works best is we define our own table of literal pre- and suffix as well as other characteristics for the different databases that we support. We do so in an end-user accessible way but provide preconfigured stuff. We can easily extend it if we come acros a new database.

Comment accepted as answer

Carel,

Ok I've found a working example of SQLGetTypeInfo and it seems to do the job.

Because you have come up with the answer, please have the points.

Thank you.