delphi中如何删除access中的空记录?
用sql语句
delete * from table1 where len(trim(name))=0
delete * from table1 where name=''
都不行,什么都没有删除
用sql语句
delete * from table1 where len(trim(name))=0
delete * from table1 where name=''
都不行,什么都没有删除
我试了一下,可以删除!
1.
Str := 'delete * from table1 where len(trim(name))=0 ';
2.
Str := ' delete * from table1 where name='''' ';
select * from table where name is null
看看能不能找到你的記錄?或者你看看你要刪除的記錄的name字段到底是個什麼樣的情況?或許是類似Alt + 255之類的字符呢:)
用'delete * from table1 where len(trim(name))<3可以删除小于2位的记录.