以文本方式查看主题

-  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