关于sql的弱智问题.......(20分)

C

colacoca

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #1

本人刚学sql,很多都不会,请大家帮忙:
在dbf表中,write是boolean,meet是integer类型
那么怎么把
Query1.SQL.Add('select * from data1.dbf where write=true');
Query1.SQL.Add('select * from data1.dbf where meet>30000');

改正确呢?

 

J

Jamw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #2

没问题呀。显示什么错误信息？

 

C

colacoca

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #3

编译能通过,运行时显示
---------------------------
|Invalid use of keyword |
|Token: write=true |
|select |
|Line Number: 1 |
| |
| 确定 |
|--------------------------

 

Z

zhouxx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #4

改成WRITE=1 看看,再清一下Query1.SQL.clear

 

C

colacoca

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #5

改为1后运行也出错,显示:

Invalid use of keyword.
Token write=1
Line Number: 1.

 

D

delphiwolf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #6

你最好改掉你的字段名 write

 

D

delphiwolf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #7

Query1.SQL.Add('select * from data1.dbf where data1.dbf.''write''=1');

 

S

shangcm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #8

你的语句是正确的
你说说出了什么错误先

 

D

delphiwolf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #9

write是保留字，详细信息查阅Local SQL Help中的Reserved words

 

C

colacoca

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-06-20

• #10

delphiwolf
答对了