📄 18322.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 nothing on September 02, 1999 at 16:24:07:<p>In Reply to: <a href="18318.html">请问怎样储存空的日期去Database,而Database不会转变成1899/12/30</a> posted by Fai on September 02, 1999 at 16:05:22:<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><br><br><hr size=7 width=75%><p><a name="followups">Follow Ups:</a><br><ul><!--insert: 18322--><!--top: 18331--><li><a href="18331.html">Re: 请有心人救救我,怎样储存空的日期去Database,而Database不会转变成1899/12/30</a> <b>Fai</b> <i>17:47:39 9/02/99</i>(<!--responses: 18331-->2)<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--></ul><!--end: 18322--><br><hr size=7 width=75%><p></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -