Re: [GENERAL] double quotes inside VBA string ?

2005-05-22 Thread Sim Zacks 



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

  "Zlatko Matić" <[EMAIL PROTECTED]> 
  wrote in message news:[EMAIL PROTECTED]...
  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: [GENERAL] double quotes inside VBA string ?

2005-05-18 Thread Jeff Eckermann 

""Zlatko Matiæ"" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
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.




---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [GENERAL] double quotes inside VBA string ?

2005-05-18 Thread Pascual De Ruvo 
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ć <[EMAIL PROTECTED]> 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 
?

[GENERAL] double quotes inside VBA string ?

2005-05-18 Thread Zlatko Matić 



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 
?