以文本方式查看主题 - Foxtable(狐表) (http://foxtable.net/bbs/index.asp) -- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2) ---- 无法完成延迟准备 (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=73417) |
-- 作者:liu1992 -- 发布时间: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. |
-- 作者:大红袍 -- 发布时间:2015/8/19 9:43:00 -- 1、连接数据库的字符串有问题,导致加载出问题;
2、此表的加载条件设置有问题。如果是sqlserver数据库,日期不要用#关键字 |
-- 作者:liu1992 -- 发布时间:2015/8/19 9:46:00 -- ... [此贴子已经被作者于2017/4/18 16:00:13编辑过]
|
-- 作者:大红袍 -- 发布时间:2015/8/19 9:49:00 -- 重新设置数据源
http://www.foxtable.com/help/topics/1810.htm
如果写有代码,去看 BeforeConnectOuterDataSource 事件代码 |
-- 作者:liu1992 -- 发布时间:2015/8/19 10:20:00 -- 我检查了一下,外部数据源连接没有问题,增加和修改外部数据表都可以。 我在“加工大板”表中筛选“销售出库日期”之后你就报了上面截图这个错。好像是日期的问题,但是其他表的日期筛选都是正常的,能不能请老师讲解一下如何修改!
|
-- 作者:狐狸爸爸 -- 发布时间:2015/8/19 10:26:00 -- 如果是sql server,日期用单引号括起来,而不是#. http://www.foxtable.com/help/topics/2668.htm
|