SQl清空记录问题(50分)

W

wohoot

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-14

• #1

源码如下:
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('delete from dukou,duchuan,dugong,jiancha');
query1.ExecSQL;
我要同时清空dukou,duchuan,dugong,jiancha四个表,调试失败,提示:
project 13.exe raised exception class EDBEngineError with message 'non-blob column in table required perform operation.'
请问改怎么样解决?

 

X

xiammy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-14

• #2

楼主，你的这个语法正确吗？

我在Access中就不支持！

 

Z

zywcd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-14

• #3

你分别删除不就可以吗 ？
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('delete from dukou ');
query1.SQL.Add('delete from duchuan);
query1.SQL.Add('delete from dugong');
query1.SQL.Add('delete from jiancha');
query1.ExecSQL;

 

W

wohoot

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-14

• #4

请大虾们写出详细代码,还有就是我代码错在哪里?

 

T

TYZhang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-14

• #5

如果是Sqlserver还可以用：
truncate table dukou
truncate table duchuan
truncate table dugong
truncate table jiancha
这样更有效率。

 

W

wohoot

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-14

• #6

555555555555,我用的是ACCESS

 

S

seasky212

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-15

• #7

用的是ACCESS的话,就一个一个的删除 .
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('delete from dukou ');
query1.SQL.Add('delete from duchuan);
query1.SQL.Add('delete from dugong');
query1.SQL.Add('delete from jiancha');
query1.ExecSQL;