MS Access Question - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

MS Access Question

MS Access Question# Database - 数据库

a*e2000-12-21 08:12

1 楼

In several records, there are "'"(single quote). I don't
know how to deal with it. In the query, I have to use single
quotes to embrace the strings. What should I do to let MS
Access think some "'"(single quote) are just like ordinary
strings?
Thank you very much.

s*e2000-12-21 08:12

2 楼

try \' or /'

【在 a***e 的大作中提到】

: In several records, there are "'"(single quote). I don't
: know how to deal with it. In the query, I have to use single
: quotes to embrace the strings. What should I do to let MS
: Access think some "'"(single quote) are just like ordinary
: strings?
: Thank you very much.
:

a*e2000-12-21 08:12

3 楼

Thank you very much. But I tried it already, it didn't
work.
Thank you again. Merry Christmas!

【在 s********e 的大作中提到】

: try \' or /'

p*e2000-12-21 08:12

4 楼

I don't know how SQL statements work on Access. But in MS
SQL or other dbms, you use '' (two single quotes) in SQL for
the single quote character. Just like in C you use \\ for
\.
Example:
Update table1 set description = 'That''s the big boss'

【在 a***e 的大作中提到】

: Thank you very much. But I tried it already, it didn't
: work.
: Thank you again. Merry Christmas!