Foxtable(狐表)用户栏目专家坐堂 → 设定全局变量为Date型,初始值空时报错!


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

主题:设定全局变量为Date型,初始值空时报错!

帅哥哟,离线,有人找我吗?
菜鸟foxtable
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 菜鸟中的老鸟
等级:七尾狐 帖子:1486 积分:10064 威望:0 精华:9 注册:2008/11/14 8:54:00
设定全局变量为Date型,初始值空时报错!  发帖心情 Post By:2009/12/26 19:36:00 [只看该作者]


此主题相关图片如下:qq截图未命名.png
按此在新窗口浏览图片

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

************** Exception Text **************
System.ArgumentException: String was not recognized as a valid DateTime.Couldn't store <> in 执行时间 Column.  Expected type is DateTime. ---> System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at System.DateTime.Parse(String s, IFormatProvider provider)
   at System.Convert.ToDateTime(String value, IFormatProvider provider)
   at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
   at System.Data.Common.DateTimeStorage.Set(Int32 record, Object value)
   at System.Data.DataColumn.set_Item(Int32 record, Object value)
   --- End of inner exception stack trace ---
   at System.Data.DataColumn.set_Item(Int32 record, Object value)
   at System.Data.DataRow.set_Item(DataColumn column, Object value)
   at System.Data.DataRow.set_Item(String columnName, Object value)
   at Foxtable.VarsCollection.AddVar(String Ol1l0O1, Type Oll0, Object O000l)
   at Foxtable.VarsCollection.Add(String OO01011, Type Ol0l, Object O11O1)
   at Foxtable.OtherFunction.AddPublicVariables()
   at Foxtable.frmVariables.OlO100l0O1l(Object O010OO, EventArgs O)
   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.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Foxtable
    Assembly Version: 2009.12.12.1
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/foxtable.exe
----------------------------------------
Foxtable.Lib
    Assembly Version: 2009.12.12.1
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/Foxtable.Lib.DLL
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    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.42 (RTM.050727-4200)
    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.42 (RTM.050727-4200)
    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.42 (RTM.050727-4200)
    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.42 (RTM.050727-4200)
    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.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Management
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
C1.Win.C1Ribbon.2
    Assembly Version: 2.0.20092.178
    Win32 Version: 2.0.20092.178
    CodeBase: file:///F:/release开发版/C1.Win.C1Ribbon.2.DLL
----------------------------------------
C1.Win.C1Command.2
    Assembly Version: 2.0.20092.19433
    Win32 Version: 2.0.20092.19433
    CodeBase: file:///F:/release开发版/C1.Win.C1Command.2.DLL
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
C1.Win.C1FlexGrid.2
    Assembly Version: 2.6.20092.416
    Win32 Version: 2.6.20092.416
    CodeBase: file:///F:/release开发版/C1.Win.C1FlexGrid.2.DLL
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    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.42 (RTM.050727-4200)
    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.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Foxtable.Blank
    Assembly Version: 0.0.0.0
    Win32 Version: 0.0.0.0
    CodeBase: file:///F:/release开发版/Catch/Foxtable.Blank.dll
----------------------------------------
Interop.ADOX
    Assembly Version: 2.8.0.0
    Win32 Version: 2.8.0.0
    CodeBase: file:///F:/release开发版/Interop.ADOX.DLL
----------------------------------------
Interop.ADODB
    Assembly Version: 2.8.0.0
    Win32 Version: 2.8.0.0
    CodeBase: file:///F:/release开发版/Interop.ADODB.DLL
----------------------------------------
CustomMarshalers
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
----------------------------------------
Interop.MSScriptControl
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///F:/release开发版/Interop.MSScriptControl.DLL
----------------------------------------
a32e2c9c.Form
    Assembly Version: 0.0.0.0
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/foxtable.exe
----------------------------------------
C1.Win.C1Input.2
    Assembly Version: 2.0.20092.33234
    Win32 Version: 2.0.20092.33234
    CodeBase: file:///F:/release开发版/C1.Win.C1Input.2.DLL
----------------------------------------
C1.Win.C1Chart.2
    Assembly Version: 2.0.20092.19168
    Win32 Version: 2.0.20092.19168
    CodeBase: file:///F:/release开发版/C1.Win.C1Chart.2.DLL
----------------------------------------
C1.Win.C1BarCode.2
    Assembly Version: 2.0.20093.36
    Win32 Version: 2.0.20093.36
    CodeBase: file:///F:/release开发版/C1.Win.C1BarCode.2.DLL
----------------------------------------
a32e2c9c.Form.bd422373
    Assembly Version: 0.0.0.0
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/foxtable.exe
----------------------------------------
a32e2c9c.Form.bd422373
    Assembly Version: 0.0.0.0
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/foxtable.exe
----------------------------------------
a32e2c9c.Form.9dfd30b1
    Assembly Version: 0.0.0.0
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/foxtable.exe
----------------------------------------
a32e2c9c.Form.9dfd30b1
    Assembly Version: 0.0.0.0
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/foxtable.exe
----------------------------------------
Foxtable.Ribbon
    Assembly Version: 0.0.0.0
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/foxtable.exe
----------------------------------------
System.Web
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
a32e2c9c.Form.181f26a7
    Assembly Version: 0.0.0.0
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/foxtable.exe
----------------------------------------
a32e2c9c.Form.181f26a7
    Assembly Version: 0.0.0.0
    Win32 Version: 2009.12.12.1
    CodeBase: file:///F:/release开发版/foxtable.exe
----------------------------------------

************** 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.


 


 回到顶部
帅哥哟,离线,有人找我吗?
mr725
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 一级勋章
等级:MVP荣誉狐 帖子:5154 积分:31434 威望:0 精华:8 注册:2008/9/8 12:27:00
  发帖心情 Post By:2009/12/26 19:58:00 [只看该作者]

能看看代码 吗?   学点经验啊~ 

 回到顶部
帅哥哟,离线,有人找我吗?
菜鸟foxtable
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 菜鸟中的老鸟
等级:七尾狐 帖子:1486 积分:10064 威望:0 精华:9 注册:2008/11/14 8:54:00
  发帖心情 Post By:2009/12/26 20:06:00 [只看该作者]

以下是引用mr725在2009-12-26 19:58:00的发言:
能看看代码 吗?   学点经验啊~ 

图片点击可在新窗口打开查看这是狐表自带的全局变量窗口。


 回到顶部
帅哥哟,离线,有人找我吗?
mr725
  4楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 一级勋章
等级:MVP荣誉狐 帖子:5154 积分:31434 威望:0 精华:8 注册:2008/9/8 12:27:00
  发帖心情 Post By:2009/12/26 20:13:00 [只看该作者]

Vars.Add("起始日期",GetType(Date))   这样其初始值就是空值啊~ 


如果是窗口,可以在AfterLoad事件中:

e.Form.Controls("DateTimePicker1").value = ""        '绑定全局变量:Vars.Add("起始日期",GetType(Date))
e.Form.Controls("DateTimePicker2").value = ""        '绑定全局变量:Vars.Add("结束日期",GetType(Date))

[此贴子已经被作者于2009-12-26 20:29:02编辑过]

 回到顶部
帅哥哟,离线,有人找我吗?
czy
  5楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 一级勋章 三级勋章 二级勋章
等级:超级版主 帖子:6318 积分:33951 威望:0 精华:10 注册:2008/8/31 20:56:00
  发帖心情 Post By:2009/12/26 21:48:00 [只看该作者]

应该是bug,最起码也不能有这么不友好的提示。

 回到顶部
帅哥哟,离线,有人找我吗?
mr725
  6楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 一级勋章
等级:MVP荣誉狐 帖子:5154 积分:31434 威望:0 精华:8 注册:2008/9/8 12:27:00
  发帖心情 Post By:2009/12/26 22:15:00 [只看该作者]

哦,是说 管理项目 中的 全局变量 按钮呀~   

 回到顶部