Foxtable(狐表) → 用户栏目 → 专家坐堂 → 无法完成延迟准备


  共有3125人关注过本帖树形打印复制链接

主题：无法完成延迟准备
美女呀，离线，留言给我吧！
liu1992
 小大  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级：幼狐 帖子：116 积分：1091 威望：0 精华：0 注册：2015/7/17 10:19:00 		无法完成延迟准备  发帖心情 Post By：2015/8/19 9:34:00 [只看该作者]

我的表原来是可以正常使用的，但是今天突然出现了这个问题，想问问是不是我误操作了什么导致了这样的问题？怎么解决啊?
很急啊，谢谢了！！！

图片点击可在新窗口打开查看此主题相关图片如下：加工大板表问题.png
图片点击可在新窗口打开查看

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OleDb.OleDbException: 无法完成延迟准备。
Statement(s) could not be prepared.
Incorrect syntax near '#'.
   at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)
   at System.Data.OleDb.OleDbDataReader.BuildSchemaTableRowset(Object handle)
   at System.Data.OleDb.OleDbDataReader.GenerateSchemaTable(OleDbDataReader dataReader, Object handle, CommandBehavior behavior)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillSchema(DataTable dataTable, SchemaType schemaType, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillSchema(DataTable dataTable, SchemaType schemaType)
   at Foxtable.DataTable.o0o　　　　　(DataTable A_0)
   at Foxtable.ooo_0__0.OoOo__O_(Object A_0, EventArgs A_1)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3655 (GDR.050727-3600)
    CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Foxtable
    Assembly Version: 2014.10.23.1
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
Foxtable.Lib
    Assembly Version: 2014.10.23.1
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/Foxtable.Lib.DLL
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3645 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3644 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3644 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3654 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
C1.Win.C1Ribbon.2
    Assembly Version: 2.0.20102.279
    Win32 Version: 2.0.20102.279
    CodeBase: file:///D:/foxtable/开发版/C1.Win.C1Ribbon.2.DLL
----------------------------------------
System.Management
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
Interop.JinDI_SmsComLib
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///D:/foxtable/开发版/Interop.JinDI_SmsComLib.DLL
----------------------------------------
C1.Win.C1Command.2
    Assembly Version: 2.0.20102.19458
    Win32 Version: 2.0.20102.19458
    CodeBase: file:///D:/foxtable/开发版/C1.Win.C1Command.2.DLL
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3654 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
C1.Win.C1FlexGrid.2
    Assembly Version: 2.6.20102.554
    Win32 Version: 2.6.20102.554
    CodeBase: file:///D:/foxtable/开发版/C1.Win.C1FlexGrid.2.DLL
----------------------------------------
石材贸易数据中心.Project
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
System.Web
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3658 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
C1.Win.C1Input.2
    Assembly Version: 2.0.20102.33248
    Win32 Version: 2.0.20102.33248
    CodeBase: file:///D:/foxtable/开发版/C1.Win.C1Input.2.DLL
----------------------------------------
石材贸易数据中心.DataTable.AocUoMixHZM2qWDUv
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AFa88jkaAw7SY1tDh
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AW4E02ebr0vLxnwfy
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AszEyHNoAKjYlZ3ji
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AQmLFh4ZejfFd5Pse
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.A9U63u1UzPFl0vvlR
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.APHXXdrEUQxw1Oy1L
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AOh2sFrxfqZe8vFx1
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.Av8olWJf0rVZ7s1nZ
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AuLYaiwJsCVl8Y1VO
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AlSkbCUSe9l6B9ZgV
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.A4d0JbMdzGDt33Bpu
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AjHGB8DaZmm208M8W
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.ApvJbHvXALM9NWbv4
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AaOSBRUJRrYmxkID1
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.ATShV8VoBM4QhPy0Q
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.A6O1wWvu6m5TVj9GQ
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AOAC5qAqRziTf1cC7
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.DataTable.AzR2galR9eRUQ2WHF
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
Interop.MSScriptControl
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///D:/foxtable/开发版/Interop.MSScriptControl.DLL
----------------------------------------
System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3645 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
石材贸易数据中心.Ribbon
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
石材贸易数据中心.Public
    Assembly Version: 0.0.0.0
    Win32 Version: 2014.10.23.1
    CodeBase: file:///D:/foxtable/开发版/foxtable.exe
----------------------------------------
C1.C1Zip.2
    Assembly Version: 2.1.20102.69
    Win32 Version: 2.1.20102.69
    CodeBase: file:///D:/foxtable/开发版/C1.C1Zip.2.DLL
----------------------------------------
Neodynamic.WinControls.BarcodeProfessional
    Assembly Version: 6.0.2000.0
    Win32 Version: 6.0.2000.15
    CodeBase: file:///D:/foxtable/开发版/Neodynamic.WinControls.BarcodeProfessional.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
 回到顶部
帅哥哟，离线，有人找我吗？
大红袍
 小大  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级：贵宾 帖子：39310 积分：196782 威望：0 精华：1 注册：2015/4/25 9:23:00 		  发帖心情 Post By：2015/8/19 9:43:00 [只看该作者]

1、连接数据库的字符串有问题，导致加载出问题；

 

2、此表的加载条件设置有问题。如果是sqlserver数据库，日期不要用#关键字
 回到顶部
美女呀，离线，留言给我吧！
liu1992
 小大  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级：幼狐 帖子：116 积分：1091 威望：0 精华：0 注册：2015/7/17 10:19:00 		  发帖心情 Post By：2015/8/19 9:46:00 [只看该作者]

...
[此贴子已经被作者于2017/4/18 16:00:13编辑过]
 回到顶部
帅哥哟，离线，有人找我吗？
大红袍
 小大  4楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级：贵宾 帖子：39310 积分：196782 威望：0 精华：1 注册：2015/4/25 9:23:00 		  发帖心情 Post By：2015/8/19 9:49:00 [只看该作者]

重新设置数据源

 

http://www.foxtable.com/help/topics/1810.htm

 

如果写有代码，去看 BeforeConnectOuterDataSource 事件代码
 回到顶部
美女呀，离线，留言给我吧！
liu1992
 小大  5楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级：幼狐 帖子：116 积分：1091 威望：0 精华：0 注册：2015/7/17 10:19:00 		  发帖心情 Post By：2015/8/19 10:20:00 [只看该作者]

我检查了一下，外部数据源连接没有问题，增加和修改外部数据表都可以。
我在“加工大板”表中筛选“销售出库日期”之后你就报了上面截图这个错。好像是日期的问题，但是其他表的日期筛选都是正常的，能不能请老师讲解一下如何修改！
 回到顶部
帅哥哟，离线，有人找我吗？
狐狸爸爸
 小大  6楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级：管理员 帖子：47497 积分：251403 威望：0 精华：91 注册：2008/6/17 17:14:00 		  发帖心情 Post By：2015/8/19 10:26:00 [只看该作者]

 如果是sql server,日期用单引号括起来，而不是#.

http://www.foxtable.com/help/topics/2668.htm

 
 回到顶部
RSS2.0 | Xhtml无图版 | Xslt无图版 Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号
   Powered By Dvbbs Version 8.3.0
页面执行时间 0.06445 秒, 4 次数据查询