为什么这样不能清空表中的记录？？(5分)

K

ko

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-07

• #1

sbrbb是用access2000设计的表，在delphi中ADOConnection将其连接，但我使用以下语名想将
表中的记录删除时总是出错？
with datamodule1.ADOTable1 do
delete * from sbrbb;
是不是语名错了还是方法不对？

 

K

ko

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-07

• #2

???

 

H

hfbsn

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-08

• #3

>> with datamodule1.ADOTable1 do
>> delete * from sbrbb;

这是什么语言呀，把Delphi和SQL混一块用？？

 

H

houanl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-08

• #4

delete from sbrbb;

 

Y

ymf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-08

• #5

老兄用ADOQuery吧

 

Q

qianwt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-08

• #6

你可以用ADOQuery执行SQL语句delete from sbrbb;
ADOQuery.SQL.Text='delete from sbrbb'
ADOQuery.ExecSQL:

或用ADOTable
ADOTable.First;
while not ADOTable.Eof do
begin
ADOTable.Delete;
end

 

扳

扳手

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-08

• #7

sql语句错啦，是 delete from tablename where 条件
而不是 delete * from tablename where ....

 

K

ko

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-08

• #8

接受答案了.