OK Experts...here is a good one for you!
I have a VB.net program that I'm getting the date and time from a log file and want to place this information into a FoxPro database.
I've created the FoxPro database and I'm able to manually enter in a date and time by typing in the date then moving with the arrows on the key board over two times then entering in the date...however when I try to do this in my VB.net program I get the date just fine but the time does NOT Show up correctly I get the default time of 12:00:00.
Here is my insert statement:
te & " " & sTime, "0510", "smithmrk", "123", "456")
I've tried to just put sDate & sTime but that doesn't work either...I've tried ctype(sdate & sTime, datetime) but that doesn't work either.
See the attached screen shot of my results.