double quotes inside a string

[Zlatko Matiæ]

I have a problem when working with PostrgeSQL as back-end. Namely,
PostgreSQL syntax uses doble quotes for table names and field names. For
example:
select = from public."Customers"
Therefore, when I write it as a string of a pass-through query or Command
Text of ADO Command object it looks like:
"select * from public."Customers""
anbd VBA thinks that the first quote after public. is the end of statement.

How to solve it ?

Thanks.

[Matthias Klaey]

"Zlatko Matiæ" <zl***********@sb.t-com.hr> wrote:

I have a problem when working with PostrgeSQL as back-end. Namely,
PostgreSQL syntax uses doble quotes for table names and field names. For
example:
select = from public."Customers"
Therefore, when I write it as a string of a pass-through query or Command
Text of ADO Command object it looks like:
"select * from public."Customers""
anbd VBA thinks that the first quote after public. is the end of statement.

How to solve it ?

Thanks.

Use two double quotes inside the string:

"select * from public.""Customers"""

HTH
Matthias Kläy
--
www.kcc.ch

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----