General information
Title:
Rollover function and CDX's
I am maintaining a legacy system for VFP 5.0. There are tables in the system that store dates as character (8). Why they did this is beyond me, but there is nothing I can do right now.
What I did was put in a ROLLOVER function:
SET CENTURY TO 19 ROLLOVER 60
This works, except there is an index on one of the tables that looks something like:
SET INDEX TO DTOS(DTOC(PURDATE))+VENDNO+INVNO TAG INVOICE
Doing a seek fails because the index can't seem to deal with the ROLLOVER. (It just rolls over and plays dead.) No error is produced, the seek value is simply not found. I have verified that the data is in the file. It just seems that the rushmore technology fails in this situation.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only