如果该字段对您的用户有意义,则不应使用Autonumber。 [英] Thou shalt not use Autonumber if the field is meant to have meaning for thy users.
问题描述
http://www.mvps.org/access/tencommandments.htm
如果该字段对您的
用户有意义,则不应使用Autonumber。
为什么?
Alan
http://www.mvps.org/access/tencommandments.htm
Thou shalt not use Autonumber if the field is meant to have meaning for thy
users.
Why?
Alan
推荐答案
2004年4月19日星期一22:34:51 +0100,Alan Carter
< ac ***** @ ocarpi.freeserve.co.uk>写道:
On Mon, 19 Apr 2004 22:34:51 +0100, "Alan Carter"
<ac*****@ocarpi.freeserve.co.uk> wrote:
http:// www.mvps.org/access/tencommandments.htm
如果该字段对您的
用户有意义,则不应使用Autonumber。
为什么?
http://www.mvps.org/access/tencommandments.htm
Thou shalt not use Autonumber if the field is meant to have meaning for thy
users.
Why?
将此内容放入Google群组搜索并享受(长)阅读:
autonumber代理群:*访问*
mike
Stuff this into google groups search and enjoy the (long) read:
autonumber surrogate group:*access*
mike
Alan Carter写道:
Alan Carter wrote:
http://www.mvps.org/access/tencommandments.htm
如果不使用Autonumber这个领域对你的
用户有意义。
为什么?
http://www.mvps.org/access/tencommandments.htm
Thou shalt not use Autonumber if the field is meant to have meaning for thy
users.
Why?
-----开始PGP签名消息---- -
哈希:SHA1
忽略随机自动编号。 。 。 。
顺序自动编号:
自动编号将在保存记录之前创建。如果记录
创建被取消,则不使用自动编号,下一个数字
将是刚丢弃的数字之后的下一个序列号。
>
可能的错误使用:
AutoNumber作为订单号。订单号必须在
顺序中 - 没有间隙。审计员进来并注意到缺少订单
数字&想知道丢失订单号的位置。
示例:
订单号
流程(自动编号)
------- ----------
创建25
取消25 - >丢弃
创建26
节省26
创建27
节省27
。 ..等等...
订货号码序列号25缺少订单编号序列。
审计员认为有人将第25号订单收入并删除了记录。
所有的地狱都破裂了(直到他们平衡了书籍
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Ignoring Random AutoNumbers . . . .
Sequential AutoNumbers:
AutoNumbers will create before a record is saved. If the record
creation is cancelled the AutoNumber is not used and the next Number
will be the next sequential number after the just discarded number.
Possible erroneous use:
AutoNumber as an Order Number. The Order Numbers have to be in
sequential order - no gaps. Auditors come in and notice missing Order
Numbers & want to know where the missing Order Numbers were.
Example:
Order Number
Process (AutoNumber)
------- ----------
Create 25
Cancel 25 -> discarded
Create 26
Save 26
Create 27
Save 27
... etc. ...
So Order Number 25 is missing from expected Order Number sequence.
Auditors think someone pocketed Order Number 25 and deleted the record.
All hell breaks loose (until they balance the books
和
程序员解释AutoNumbers让人眼花缭乱的老板)。 />
-
MGFoster ::: mgf00< at> earthlink< decimal-point> net
奥克兰,加利福尼亚州(美国)
-----开始PGP SIGNATURE -----
版本: PGP个人隐私5.0
Charset:noconv
iQA / AwUBQIRKgYechKqOuFEgEQKNjACgjMY6sk5BSNpBzRgVSDRH0k W6HJkAoMh6
md5o2TmBF1M6nK7bbH6Evb + 3
= sXfU
-----结束PGP签名-----
and the
programmer explains AutoNumbers to glaring boss).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIRKgYechKqOuFEgEQKNjACgjMY6sk5BSNpBzRgVSDRH0k W6HJkAoMh6
md5o2TmBF1M6nK7bbH6Evb+3
=sXfU
-----END PGP SIGNATURE-----
这篇关于如果该字段对您的用户有意义,则不应使用Autonumber。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!