double quotes inside VBA string ?

From: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: double quotes inside VBA string ?
Date: 2005-05-18 13:14:28
Message-ID: 001d01c55bab$87607cf0$99301dc3@zlatkovyfkpgz6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.
I have a problem when working with MS Access/PostgreSQL.
Namely, as PostgreSQL syntax uses doble quotes for table names and field names, 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""
and VBA considers that the first quote after public. is the end of statement.

How to solve it ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-05-18 13:23:19 Re: Executing Dynamic DDL
Previous Message Sim Zacks 2005-05-18 11:45:32 plpython multi row return workaround