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.

"Zlatko Matiæ" <zlatko.matic1@sb.t-com.hr> wrote:
[color=blue]
>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.
>
>[/color]

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 =----