表达式输入不正确或者太复杂而无法评估 [英] he expression is typed incorrectly or it is too complex to be evaluated

问题描述

我试图在参数化查询中运行以下agregate函数
在Access2000上
：


Min（[t1]。[f1] * sqr （[t2]。[f1] / [t1]。[f1]）/ [param]）


查询保存确定，但尝试运行它会产生以下消息：

表达式输入错误或者太复杂而无法评估


如果sintax正确吗？也许是这样，否则就不会保存。

可以做些什么呢？

解决方案

aa写道：< blockquote class =post_quotes>我试图在Access2000上的参数化
查询中运行以下agregate函数：

Min（[t1]。[f1] * sqr（[t2] 。[f1] / [t1]。[f1]）/ [param]）

查询保存OK，但尝试运行它会产生以下消息：
表达式已输入不正确或太复杂而无法评估

如果sintax正确吗？也许它是，否则它不会保存。
可以做些什么呢？

在Access中运行它时，或者何时运行它运行它来自

ASP？


我想你已经确认这个表达式（似乎是

语法正确）是删除

这个表达式后运行查询的罪魁祸首吗？


我建议您通过

开头：


最小（[t1]。[f1]）


并添加件直至失败。

FWIW，我刚刚在我的示例数据库中对它进行了测试，查询运行没有

问题。


Bob Barrows

-

Microsoft MVP - ASP / ASP.NET

请回复新闻组。我的From

标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。

谢谢，Bob。


1.当我从Access2000中运行此查询时弹出提到的错误


当我从ASP运行它时，它返回

===== ==========================

错误类型：

Microsoft JET数据库引擎（ 0x80040E07）

标准表达式中的数据类型不匹配。

========================= =======


2.在我添加

sqr（）之前，查询在Access和ASP中都运行良好：
/>
Min（[t1]。[f1] * [t2]。[f1] / [t1]。[f1]）/ [param]

所以sqr（）似乎是一个罪魁祸首。


你是说你在机器上使用sqr（）工作的查询吗？


鲍勃巴罗斯 <再****** @ NOyahoo.SPAMcom>在消息中写道

news：u3 ************** @ tk2msftngp13.phx.gbl ...

aa写道：

我试图在Access2000上的参数化
查询中运行以下agregate函数：

Min（[t1]。[f1] * sqr（[t2]。 [f1] / [t1]。[f1]）/ [param]）

查询保存正常，但尝试运行它会产生以下消息：
表达式输入错误或者它太复杂了无法评估

如果sintax正确吗？也许它是，否则它不会保存。
可以做些什么呢？

在Access中运行它时，或者从<运行它时，是否收到此消息？ ASP？

我想你已经确认这个表达式（似乎在语法上是正确的）是删除
这个表达式后运行查询的罪魁祸首？

我建议您通过以下方式发现表达问题的哪一部分：

Min（[t1]。[f1]）
FWIW，我刚刚在我的示例数据库中测试它，并且查询运行没有
问题。

-
微软MVP - ASP / ASP.NET
请回复新闻组。我的From
标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将得到更快的回复。

aa写道：

谢谢，鲍勃。

1.当我从内部运行此查询时弹出提到的错误

当我从ASP运行它时，它返回
===============================
错误类型：
Microsoft JET数据库引擎（0x80040E07） ）
标准表达式中的数据类型不匹配。
================================ />
2.在我添加sqr（）之前，查询在Access和ASP中都运行正常：
Min（[t1]。[f1] * [t2]。[ f1] / [t1]。[f1]）/ [param]
所以sqr（）似乎是罪魁祸首。

你是说在你用sqr（）加工查询工作？

是的，我在运行它时没有问题。在AccessXP中。


快速Google搜索显示有人解决了这个问题是在参数的PARAMETERS部分中声明了他的参数查询，如下：

PARAMETERS param Short;

SELECT ...


Bob Barrows

-

Microsoft MVP - ASP / ASP.NET

请回复新闻组。我的From

标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。

I am trying to run the following agregate function in a parameterized query
on Access2000:

Min([t1].[f1]*sqr([t2].[f1]/[t1].[f1])/[param])

The query saved OK, but an attempt to run it results in the message:
The expression is typed incorrectly or it is too complex to be evaluated

If the sintax correct? Perhaps it is, otherwise it would not save.
What can be done about it?

解决方案

aa wrote:

I am trying to run the following agregate function in a parameterized
query on Access2000:

Min([t1].[f1]*sqr([t2].[f1]/[t1].[f1])/[param])

The query saved OK, but an attempt to run it results in the message:
The expression is typed incorrectly or it is too complex to be
evaluated

If the sintax correct? Perhaps it is, otherwise it would not save.
What can be done about it?

Do you get this message when running it in Access, or when running it from
ASP?

I suppose you''ve confirmed that this expression (which appears to be
syntactically correct) is the culprit by running the query after removing
this expression?

I suggest that you discover what part of the expression is the problem by
starting with:

Min([t1].[f1])

and adding on pieces until it fails.
FWIW, I just tested it in my sample database, and the query runs without
problem.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don''t check it very often. You will get a
quicker response by posting to the newsgroup.

Thanks, Bob.

1. The mentioned error pops up when I run this query from within Access2000

When I run it from ASP, it returns
===============================
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
================================

2. The query was working fine both in Access and in ASP before I added that
sqr():
Min([t1].[f1]*[t2].[f1]/[t1].[f1])/[param]
So sqr() seems to be a culprit.

Are you saying that on you machine the query with sqr() worked?

"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:u3**************@tk2msftngp13.phx.gbl...

aa wrote:

I am trying to run the following agregate function in a parameterized
query on Access2000:

Min([t1].[f1]*sqr([t2].[f1]/[t1].[f1])/[param])

The query saved OK, but an attempt to run it results in the message:
The expression is typed incorrectly or it is too complex to be
evaluated

If the sintax correct? Perhaps it is, otherwise it would not save.
What can be done about it?

Do you get this message when running it in Access, or when running it from
ASP?

I suppose you''ve confirmed that this expression (which appears to be
syntactically correct) is the culprit by running the query after removing
this expression?

I suggest that you discover what part of the expression is the problem by
starting with:

Min([t1].[f1])

and adding on pieces until it fails.
FWIW, I just tested it in my sample database, and the query runs without
problem.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don''t check it very often. You will get a
quicker response by posting to the newsgroup.

aa wrote:

Thanks, Bob.

1. The mentioned error pops up when I run this query from within
Access2000

When I run it from ASP, it returns
===============================
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
================================

2. The query was working fine both in Access and in ASP before I
added that sqr():
Min([t1].[f1]*[t2].[f1]/[t1].[f1])/[param]
So sqr() seems to be a culprit.

Are you saying that on you machine the query with sqr() worked?

Yes, I had no problem running it.in AccessXP.

A quick Google search shows that somebody solved this problem by declaring
his parameters in a PARAMETERS section of the query, like this:
PARAMETERS param Short;
SELECT ...

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don''t check it very often. You will get a
quicker response by posting to the newsgroup.

这篇关于表达式输入不正确或者太复杂而无法评估的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！