Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using datetime index and using with a seek command?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Using datetime index and using with a seek command?
Miscellaneous
Thread ID:
00612987
Message ID:
00612987
Views:
49
I used TTOC(mytable.mydatetime) as part of my index

My whole index looks like ALLT(mytable.myname+TTOC(mytable.mydatetime)

myname is CHAR 30
mydatetime is DATETIME 8

When I SEEK on the Index it never finds the record I am seeking because
SEEKID looks like STEVE KRAMER01/25/2002 15:50:51
If I look at the record I am seeking it looks like 01/25/2002 03:50:51 PM

How can I resolve this time mismatch? I believe I SET HOURS to 24-hour clock in my forms. I have never tried using a DATETIME in an index before, just a DATE or a TIME. Thanks for the help!
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform