My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 11: Microsoft Office Access 不能在追加查询中追加所有记录
1 person starred this issue and may be notified of changes. Back to list
Status:  Accepted
Owner:  deepcast


 
Project Member Reported by deepcast, Nov 27, 2007
在执行ACCESS内部的追加查询时出现以下错误提示:

Microsoft Office Access 不能在追加查询中追加所有记录

Microsoft Office Access 设置 6318 字段为 Null 是因以类型转换失败, 它未将 0 记录
添加到表是因为键值冲突, 没有添加 0 记录是因为锁定冲突, 没有添加 0 记录是因为有效性规
则冲突。
是否执行操作查询?


原因分析:数字字段不能为空,而追加查询试图插入NULL的数字字段值,所以出错
解决方法:修改查询,把NULL换成0,错误消失

 
error_gen准贷即卡明细.jpg
92.1 KB   View   Download
Mar 30, 2009
Project Member #1 dragon...@gmail.com
使用以下两个条件判断空的字段:
Len(TextField) = 0
IsNull(textfield)

Powered by Google Project Hosting