double qutes inside string ?

[Zlatko Matiæ]

Hello.
I have a problem when writing strings for pass-through queries or command
text for ADO command object while working with PostgreSQL as back-end.
Namely, SQL dialect syntax uses double quotes for table name and field name,
something like this:
select * from public."Customers"
Therefore, when I put it as string in VBA it looks like:
"select * from public."Customers""
and VBA thinks that " after public. is the end of statement.

How to solve it?

Thanks.

[Salad]

Zlatko Matiæ wrote:

Hello.
I have a problem when writing strings for pass-through queries or command
text for ADO command object while working with PostgreSQL as back-end.
Namely, SQL dialect syntax uses double quotes for table name and field name,
something like this:
select * from public."Customers"
Therefore, when I put it as string in VBA it looks like:
"select * from public."Customers""
and VBA thinks that " after public. is the end of statement.

How to solve it?

Thanks.

See if
"select * from public.""Customers"""
works.

[Phil Stanton]

I think
"select * from public." & Chr$(34) & "Customers" & Chr$(34)"
is easier to understand (Chr$(34) is ASCII for ")

Try it
Phil

"Salad" <oi*@vinegar.com> wrote in message
news:Xj****************@newsread1.news.pas.earthli nk.net...

Zlatko Matiæ wrote:

Hello.
I have a problem when writing strings for pass-through queries or command
text for ADO command object while working with PostgreSQL as back-end.
Namely, SQL dialect syntax uses double quotes for table name and field
name, something like this:
select * from public."Customers"
Therefore, when I put it as string in VBA it looks like:
"select * from public."Customers""
and VBA thinks that " after public. is the end of statement.

How to solve it?

Thanks.

See if
"select * from public.""Customers"""
works.