VB Insert SQL Time format field Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a module to insert a record to tblTime (TimeID Key, TimeSlot Time)

The SQL statement in the VB Module is:
"INSERT INTO tblTime (TimeID, TimeSlot) values (tmpTimeID,LoopTime)"

tmpTimeID is calculated in the program as 2 (for test reason)
LoopTime is an Integer field and is calculated as 1010 (again for test
reasons)

The record is being inserted with the key of 2, but in the TimeSlot field,
there is no value... it is empty.
I tried changing the LoopTime to a String (instead of Integer) and it still
did not work....

Help Please... I am losing it :(
 
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...
 
Back
Top