Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datetime field
Message
From
22/02/2001 09:43:06
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00478209
Message ID:
00478381
Views:
22
>>Hello fiends.
>>
>>I have a cursor with field that is type "T". When I replace this field with a
>>Datetime data, it accepts the date portion correctly, but the time portion is always "12:00:00 AM".
>>
>>How can I get my cursor to accept the time portion correctly?
>>
>>thanks.

>First what is your SET HOURS setting? Second, what does the code look like when you are populating the field with data? i.e., what does the variable or >value that you are trying to populate the field with look like.

Set hours to 12

select mytable
Replace time1 with tblname.time


>If SET('HOURS') = 24 then, you do not provide the AM or PM. Are you sure the value contains a time portion?

Yes... most definately.


Thanks Mark
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform