Insert SQL syntax when item maybe nothing

Author Message
Kitshing

  • Total Posts : 22
  • Scores: 0
  • Reward points : 0
  • Joined: 8/12/2007
  • Status: offline
Insert SQL syntax when item maybe nothing Wednesday, August 29, 2007 4:26 AM (permalink)
0
I need to write a SQL from VBA of Excel to insert data into Access database.

e.g.
Dim strSQL as String
Dim itemDate as String                 // user will input data that is a valid date format.  such as  29/8/2007
Dim conn as new adodb.Connection

strSQL = "INSERT INTO TEST_TB (ITEM_ID, ITEM_DATE)" & _
                     " VALUES ('item001', '" & FormatDateTime(itemDate) & "' );"

conn.execute(strSQL)

-----
But error will appear when the user no input item date
(becuase the application is allowed no input for item date fields.

* ITEM_ID is TEXT type in database
   ITEM_DATE is DATE type in database


<message edited by Kitshing on Wednesday, August 29, 2007 4:31 AM>
 
#1

    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 1 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2012 ASPPlayground.NET Forum Version 3.9