错在哪里？(50分)

F

fee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #1

query1.close;
query1.sql.clear;
query1.sql.add('select * from q');
update q.db set Addr='32843' WHERE NAME=‘LIU’;
query1.open;
----------------
where is wrong?

 

H

Hexi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #2

一塌糊涂。

 

C

ChDw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #3

怎么又有 select 又有 update
怎能同时进行呢？

 

F

fee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #4

》HEXI
请说明

 

R

rixin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #5

想幹什麼?

 

F

fee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #6

》CHDW
去掉SELECT 仍不行

 

T

taoqg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #7

query1.close;
query1.sql.clear;
// query1.sql.add('select * from q');
// update q.db set Addr='32843' WHERE NAME=‘LIU’;
query1.sql.add('update q.db set Addr="32843" WHERE NAME="LIU"');
query1.open;

<ok>

 

H

Hexi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #8

query1.close;
query1.sql.clear;
query1.sql.add('select * from q');
query1.open;
query1.UpdateObject := CacheData.UpdateSQL;
updateSQL1.ModifySQL.Clear;
UpdateSql1.ModifySql.Add('update q.db set Addr=''32843'' WHERE NAME=''LIU'');

 

C

ChDw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #9

query1.close;

query1.sql.clear;

query1.sql.add('select * from q');
query1.open;

query1.close;

query1.sql.clear;

query1.sql.add('update q.db set Addr=''32843'' WHERE NAME=''LIU'');
quert1.execsql;

 

I

income

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #10

agree with chDw,
另建议fee兄看看这方面的例子.

 

Y

yck

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #11

query1.close;

query1.sql.clear;

query1.sql.add('update q set Addr=''32843'' WHERE NAME=''LIU''’);
query1.ExecSql;

 

C

cAkk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #12

最莫名其妙的错误是 : update语句居然是作为一个delphi的函数在使用的????

 

C

cAkk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-07-20

• #13

时间太久，强制结束。 wjiachun