what is the escape letter in Access?

[ruuram]

Anyone knows how to enter a string like

' Juan's birthday ' via JDBC query like

insert into table(name) values ('Juan's birthday')

What is the escape letter in Access? Any advice would be helpful!

Jing

 

[David R]

Enclose it in double quotes instead of single quotes?

 

[ruuram]

I don't think that will work, but thanks anyway.

My code is like the following:
******************************
statement stmt;
...

String insert="insert into table (name) values ('juan's birthday')";
....
stmt.executeUpdate(insert);
*******************************

 

[David R]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=27690

 

[ramesh]

hai ruuram


if you still need that question please send me a mail to ramesh_srinivasan123@rediffmail.com

i have the answer ready for u
raemsh