📄 18331.html
字号:
<html> <head> <title>Re: 请有心人救救我,怎样储存空的日期去Database,而Database不会转变成1899/12/30</title> </head> <body bgcolor="#FFFFFF" vlink="#808080"> <center> <h1>Re: 请有心人救救我,怎样储存空的日期去Database,而Database不会转变成1899/12/30</h1> </center><hr size=7 width=75%><hr size=7 width=75%><p>Posted by Fai on September 02, 1999 at 17:47:39:<p>In Reply to: <a href="18322.html">Re: 请问怎样储存空的日期去Database,而Database不会转变成1899/12/30</a> posted by nothing on September 02, 1999 at 16:24:07:<p>: : 我要将空的日期储存到Database内的ExpiryDate,但发觉就算Save其他Field,而不Save ExpiryDate,DataBase Record的ExpiryDate<br>: : 会自动变成1899/12/30,总之我想要令到储存的时候,ExpiryDate是要空的,请问要怎么做?谢谢!<p>: <br>: 日期型态的栏位设定可以存null<br>: 资料写入时判资料如果是空的要写入字串 "null"<br>: 试试看..<p>: SQLTempVariableString = "insert AcVoucherHead values ( '" & Text1.Text & "'," & _<br>: "'" & Left(Combo1(1).Text, 1) & "'," & _<br>: Chr(40) & "Null" & Chr(41) & "," & _<br>: Chr(40) & "Null" & Chr(41) & "," & _<br>: "'" & Left(Combo1(2).Text, 1) & "'," & _<br>: "'01'," & _<br>: "'传票输入'," & _<br>: "''," & _<br>: "'" & Date & "'," & _<br>: "'" & PUserNo & "' )"<p>首先谢谢您,无论我用Null,vbNull 或 不Save 这个ExpiryDate Field,<br>但是仍然Save 1899/12/30,请有心人救救我!!!<br><br><br><hr size=7 width=75%><p><a name="followups">Follow Ups:</a><br><ul><!--insert: 18331--><!--top: 18348--><li><a href="18348.html">Try...</a> <b>wei</b> <i>00:15:54 9/03/99</i>(<!--responses: 18348-->1)<ul><!--insert: 18348--><!--top: 18509--><li><a href="18509.html">Re: Thank you very much!</a> <b>Fai</b> <i>12:10:35 9/06/99</i>(<!--responses: 18509-->0)<ul><!--insert: 18509--></ul><!--end: 18509--></ul><!--end: 18348--></ul><!--end: 18331--><br><hr size=7 width=75%><p></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -