对象和字段名称中的空格 [英] Spaces In Object And Field Names
问题描述
我被赋予了重写数据库的任务，这个数据库似乎是
，虽然它是由一个非常基本的理解的人写的
的Access。表格中的许多对象名称和字段名称过长，并且包含空格，例如近亲属电话号码相反
之类的东西，比如KinPhNo。
我正在寻找关于我是否应该花费大量额外费用的意见
开发时间和修复所有的问题名称。我知道这是正确的事情，但是很有可能继续使用
节省时间。我有一种不好的感觉，虽然这可以回来，
咬我！
任何建议都表示赞赏。
I have been given the task of rewriting a database that seems as
though it has been written by someone with a very basic understanding
of Access. Many of the object names and field names in tables are
overly long and contain spaces e.g. "Next of kin phone number" instead
of something like "KinPhNo".
I am looking for opinions on whether I should spend considerable extra
development time and "fix" all the problem names. I know that this is
the right thing to do, but it is tempting to go with what is there to
save time. I have a bad feeling though that this could come back and
bite me!
Any advice is appreciated.
推荐答案
2007年6月13日星期三16:53:40 -0700，Wayne< cq ******* @ volcanomail.com>
写道：
你正在重写（我认为这意味着：从头开始），所以你可以
选择你想要的任何字段名称。不要重写申请
就地;这通常是一个灾难的秘诀。
有基本知识的人可能比字段名称中的空格更严重的错误
。我希望你能从这里获得几个等级，所以你可以根据可靠的文档分析创建一个更好的数据库设计。这就是很多
新秀犯错误的地方。
-Tom。
On Wed, 13 Jun 2007 16:53:40 -0700, Wayne <cq*******@volcanomail.com>
wrote:
You are rewriting (I assume that means: from scratch), so you can
choose any field names you want. Do not "rewrite" the application
"in-place"; that typically is a recipe for disaster.
Someone with basic knowledge probably made much more severe blunders
than spaces in the field names. I''m hoping you''re several notches up
from that, so you may for example create a much better database
design, based on solid and documented analysis. That''s where a lot of
rookies make big mistakes.
-Tom.
>我已经被赋予了重写数据库的任务，虽然它是由具有非常基本的Access理解的人编写的。表中的许多对象名称和字段名称过长，并且包含空格，例如近亲属电话号码而是像KinPhNo之类的东西。
我正在寻找关于我是否应该花费大量额外的开发时间和修复的意见。所有的问题名称。我知道这是正确的做法，但是很有可能选择那里的东西来节省时间。我有一种不好的感觉，虽然这可能会回来并且咬我！
任何建议都表示赞赏。
>I have been given the task of rewriting a database that seems as
though it has been written by someone with a very basic understanding
of Access. Many of the object names and field names in tables are
overly long and contain spaces e.g. "Next of kin phone number" instead
of something like "KinPhNo".
I am looking for opinions on whether I should spend considerable extra
development time and "fix" all the problem names. I know that this is
the right thing to do, but it is tempting to go with what is there to
save time. I have a bad feeling though that this could come back and
bite me!
Any advice is appreciated.
如果你正在编写一个新的数据库，从头开始，以更好的方式完成整个工作，所有人是指使用方便的字段名称。
如果您只是修改现有数据库来解决问题，请重命名
字段，因为它们包含空间会浪费你的时间。
长名称和空格的实际问题是它需要更长的时间才能输入它们（每次都必须添加长名称和方括号），
但是如果有人已经完成了所有这些，那么你再次浪费你的b / b $ b时间就没有意义了，只是为了让他们不必浪费所以
首先要花很多时间。
-
Allen Browne - 微软MVP。西澳大利亚珀斯
访问用户提示 - http：// allenbrowne .com / tips.html
回复群组，而不是mvps dot org的allenbrowne。
" Wayne" < cq ******* @ volcanomail.com写信息
新闻：11 ********************** @ o11g2000prd.googlegr oups.com ...
If you are writing a new database, from scratch, to do the whole job in a
better way, by all means use the field names that are convenienent to you.
If you are just modifying the existing database to fix problems, renaming
fields just because they contain a space would be a waste of your time. The
practical problem with the long names and spaces is that it takes longer to
type them (the long names and the square brackets you must add each time),
but if someone has already done all that, there is no point you wasting your
time again changing them back just so that they did not have to waste so
much time in the first place.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Wayne" <cq*******@volcanomail.comwrote in message
news:11**********************@o11g2000prd.googlegr oups.com...
>我被赋予了重写数据库的任务，尽管它似乎是
已由具有非常基本理解的人写的
的Access。表格中的许多对象名称和字段名称过长，并且包含空格，例如近亲属电话号码相反
之类的东西，比如KinPhNo。
我正在寻找关于我是否应该花费大量额外费用的意见
开发时间和修复所有的问题名称。我知道这是正确的事情，但是很有可能继续使用
节省时间。我有一种不好的感觉，虽然这可以回来，
咬我！
任何建议表示赞赏。
>I have been given the task of rewriting a database that seems as
though it has been written by someone with a very basic understanding
of Access. Many of the object names and field names in tables are
overly long and contain spaces e.g. "Next of kin phone number" instead
of something like "KinPhNo".
I am looking for opinions on whether I should spend considerable extra
development time and "fix" all the problem names. I know that this is
the right thing to do, but it is tempting to go with what is there to
save time. I have a bad feeling though that this could come back and
bite me!
Any advice is appreciated.
Wayne写道：
Wayne wrote:
我被赋予了重写数据库的任务作为
虽然它是由一个非常基本的理解的人写的
的Access。表格中的许多对象名称和字段名称过长，并且包含空格，例如近亲属电话号码相反
之类的东西，比如KinPhNo。
我正在寻找关于我是否应该花费大量额外费用的意见
开发时间和修复所有的问题名称。我知道这是正确的事情，但是很有可能继续使用
节省时间。我有一种不好的感觉，虽然这可以回来，
咬我！
任何建议表示赞赏。
I have been given the task of rewriting a database that seems as
though it has been written by someone with a very basic understanding
of Access. Many of the object names and field names in tables are
overly long and contain spaces e.g. "Next of kin phone number" instead
of something like "KinPhNo".
I am looking for opinions on whether I should spend considerable extra
development time and "fix" all the problem names. I know that this is
the right thing to do, but it is tempting to go with what is there to
save time. I have a bad feeling though that this could come back and
bite me!
Any advice is appreciated.
我的建议是不要将你的字段名称缩写为
它们被混淆的点。在我看来，KinPhNo糟糕于接下来的亲属电话号码
。至少你可以在
方括号中附上下一个亲属电话号码并理解它代表什么。
My advice is do not abbreviate your field names to the point that
they are obfuscated. KinPhNo sucks worse than Next of kin phone number
in my opinion. At least you can enclose Next of kin phone number in
square brackets and understand what the hell it represents.
这篇关于对象和字段名称中的空格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
