错误3071：表达式太复杂 [英] Error 3071: Expression too complex

问题描述

我有一个漂亮的代码，但它现在是3071，我不知道发生了什么变化。我在第214行得到了3071，但我怀疑问题不在哪里？


我正在寻找和寻找，似乎找不到可能的东西创建此错误...

Hi,

I had a beautifully working code, but it''s now 3071, and I don''t know what have changed. I get 3071 on line 214, but I suspect that''s not where the problem lies?

I''m looking and looking, and can''t seem to find what could create this error...

展开 | 选择 | Wrap | 行号

推荐答案

发布完整代码以防万一， （错误现在在第353行）

Posting full code just in case, (error now being in line 353)

展开 | 选择 | Wrap | 行号

似乎是由于表/记录本身的信息。当我在所有表格中完全清空所有测试数据并添加新的测试数据时，情况正常。


仅供参考。谢谢。

Seems it''s due to info in the Tables/Records themselves. When I completely emptied all test data in all tables and added fresh ones, things are working fine.

FYI. Thank you.

我没有发现代码中的任何错误。我注意到的只是你使用dbopensnapshot，而我标准地使用dbopendynaset。

但是我会诚实地说我在那个领域没有足够的经验说我为什么这么做。猜猜它是我第一次使用它，我有点坚持它，因为：P


这就是说，我注意到你的开场陈述中有错误：

I dont spot anything wrong in the code. Only thing I notice is that you use dbopensnapshot, whereas I standardly use dbopendynaset.
However I will be honest and say I dont have enough experience in that area to say WHY I do so. Guess it worked the first time I used it, and I''ve kinda stuck to it since :P

That said, I do notice an error in your opening statement:

展开 | 选择 | Wrap | 行号

这篇关于错误3071：表达式太复杂的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！