Thread: double quotes inside VBA string ?

double quotes inside VBA string ?

From
Zlatko Matić
Date:
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 ?


Re: double quotes inside VBA string ?

From
Pascual De Ruvo
Date:
If you need to use a double quote inside a VB string, you have to write two double quotes (double double quotes!),
so your command will  be something like:

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

 

On 5/18/05, Zlatko Matić <zlatko.matic1@sb.t-com.hr> wrote:
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 ?



Re: double quotes inside VBA string ?

From
"Jeff Eckermann"
Date:
""Zlatko Mati�"" <zlatko.matic1@sb.t-com.hr> wrote in message
news:001d01c55bab$87607cf0$99301dc3@zlatkovyfkpgz6...
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 ?

This question is OT really, but...
Make your command string something like:
"select * from public." & chr(34) & "Customers" & chr(34).

Better yet, change the table names to be all lower case.  Access won't care
at all, and your life with PostgreSQL will be easier.




Re: double quotes inside VBA string ?

From
"Sim Zacks"
Date:
double up the double quotes.  "select * from public.""Customers"""
In any case, I agree with jeff, make your table names lowercase and leave out the quotes.
 
Sim
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 ?