SELECT 语句的问题(50分)

F

fanjh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #1

A为STRING型变量，BZ为表FUN.dbf中的字符型字段。
要用SELECT语句选出表FUN中字段BZ值等于A的记录？？

 

笑

笑天宇

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #2

select * from fun where bz='a'

 

F

fanjh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #3

好象不行

 

W

weekboy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #4

select * from fun where bz="'+a+'"

 

F

fanjh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #5

用"'A'"编译出错

 

W

weekboy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #6

select * from fun where bz="'+a+'"

 

笑

笑天宇

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #7

这样，query1.text:='select * from fun where bz=：a';
query1.parambyname('a').asstring='某个值';

 

F

fanjh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #8

thank you!

 

P

Pipi.

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #9

query.SQL.Text:='select * from fun where bz='+AnsiQuotedStr(a,'"');