名为“描述”的A97查询字段是个问题 [英] A97 query field named "Description" is a problem
问题描述
我有一个查询字段...
描述：[VColor]& 双音
当我运行它时，该字段中的输出为空。
如果我将名称更改为MyDescription - 它工作正常。
我注意到查询字段有一个描述属性设置。
这就是造成我问题的原因。只是对'
组的'单挑'，让你知道要注意它。
我花了很长时间才认出来错误。我有另一个
查询，其中包含一个同名的字段，从来没有造成问题。我在创建
时使用了该查询作为模板。所以我怀疑选择的
字段名称是不是我的第一直觉。
进一步展望，我看到我有一个有一个字段的表格
名为描述在另一个数据库中即使
虽然HELP（在字段名称下）并不严格
禁止它和HELP（在命名约定下）
不会''严格禁止它 - 任何人都认为可能会导致混乱吗？
相信我，查询的处理很难
弄清楚。报告引用该查询和
字段有时会说[描述]字段未找到
和其他时间，Access 97会锁定说它
创建并保存后，我只是试图在设计视图中打开报告
时必须关闭。
MLH < CR ** @ NorthState.net>在消息中写道
news：nk ******************************** @ 4ax.com ...我有一个查询字段...
描述：[VColor]& 2-tone
当我运行它时，该字段中的输出为空。
如果我将名称更改为MyDescription - 它工作正常。
我注意到了查询字段有一个描述属性设置。
这就是造成我问题的原因。只是对'
组的''单挑'让你知道要注意它。
我花了很长时间才发现错误。我有另一个
查询与一个同名字段，从来没有造成我的问题。我在创建这个查询时使用该查询作为模板。所以我怀疑所选的
字段名称是不是我的第一直觉。
是的。说明是Access中的保留字。它永远不应该用于
对象的名称。在帮助中有一些地方有一个完整的
保留字列表，但它几乎不可能找到。
< blockquote> MLH写道：
进一步看，我看到我的表有一个字段
名为描述在另一个数据库中即使是
虽然HELP（在字段名称下）并没有严格禁止它和HELP（在命名约定下）
并不严格禁止它 - 任何人都认为可以导致混乱下线？
相信我，处理查询很难搞清楚。引用该查询的报告和
字段有时会说[找不到[描述]字段
和其他时间，Access 97会锁定说它
必须关闭时我只是试图打开报告
在设计视图中创建并保存它。
我从未见过名为Description的字段的问题。 Access 97中有一个帮助
主题列出了所有保留字和描述字样。不是其他人中的一个（虽然是描述）。
-
我不检查电子邮件帐户附上
到此消息。发送给...
在Hunter dot com的RBrandt
I have a query field...
Description: [VColor] & "2-tone"
When I run it, the output in that field is empty.
If I change the name to MyDescription - it works fine.
I noticed the query field has a Description property setting.
That''s what''s causing my problem. Just a ''heads-up'' to the
group letting you know to watch out for it.
It took me a long time to recognize the error. I have another
query with a field of the same name that has NEVER caused
me a problem. I used that query as a template when creating
this one. So it wasn''t my first instinct to suspect the chosen
field name was a problem.
Looking further, I see I have a table with one field
named "Description" in another database. Even
though HELP (under Field Names) doesn''t strictly
forbid it and the HELP (under naming conventions)
doesn''t strictly forbid it - anybody think that could
cause confusion down the line?
Believe me, the deal with the query was difficult to
figure out. Reports referencing that query and that
field would sometimes say [Description] field not found
and other times, Access 97 would lock up saying it
had to close when I merely attempted to open the report
in design view after creating and saving it.
"MLH" <CR**@NorthState.net> wrote in message
news:nk********************************@4ax.com...I have a query field...
Description: [VColor] & "2-tone"
When I run it, the output in that field is empty.
If I change the name to MyDescription - it works fine.
I noticed the query field has a Description property setting.
That''s what''s causing my problem. Just a ''heads-up'' to the
group letting you know to watch out for it.
It took me a long time to recognize the error. I have another
query with a field of the same name that has NEVER caused
me a problem. I used that query as a template when creating
this one. So it wasn''t my first instinct to suspect the chosen
field name was a problem.
Yep. Description is a reserved word in Access. It should never be used for
the name of an object. Some place in the help there''s a complete list of
reserved words, but it''s near impossible to find.
MLH wrote:Looking further, I see I have a table with one field
named "Description" in another database. Even
though HELP (under Field Names) doesn''t strictly
forbid it and the HELP (under naming conventions)
doesn''t strictly forbid it - anybody think that could
cause confusion down the line?
Believe me, the deal with the query was difficult to
figure out. Reports referencing that query and that
field would sometimes say [Description] field not found
and other times, Access 97 would lock up saying it
had to close when I merely attempted to open the report
in design view after creating and saving it.
I have never seen a problem with a field named "Description". There is a help
topic in Access 97 that lists all of the reserved words and "Description" is not
one of them (though "Desc" is).
--
I don''t check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
这篇关于名为“描述”的A97查询字段是个问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
