VB Insert SQL with Time Format Field

G

Guest

HELP :(

tblTime
TimeID (Key)
TimeSlot (Time)
Click to expand...

I have a VB Module to insert TimeSlots. As a test I did the following:
tmpTimeID = 2
tmpTimeSlot = 1010 (defind as Integer)

SQL Statement is:
SQL1="INSERT INTO tblTime (TimeID, TimeSlot) VALUES (' " & tmpTimeID & " ' ,
' " & tmpTimeSlot & " ' ) "

It creates the record with the key of 2, but for TimeSlot field is EMPTY!
I tried chaning the tmpTimeSlot to String (instead of Integer) and still
nothing....

Anyone? Help... Please....
 
A

Alex Dybenko

Hi,
if you TimeSlot has date/time type - then you can insert correct value in
following format: #mm/dd/yyyy hh:hh#
 
G

Guest

Sorry for the tripple post... seemed like it did not post it so I tried
again...

Anyway, I found the solution in the meantime :)

(have to be string HH:SS) - so it is working....

Blessings to all...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Insert SQL Time format field Value 1
VB Insert SQL using Time Field 1
Need Help with SQL statement - "Insert Into" 7
Inserting a concatenated string into a text field 2
Using select statements in a SQL insert statement... 2
Insert a field in sql using VB 2
Insert Into -- expected end of statement error 7
Syntax error on SQL INSERT 5

Top