hi

i have a clipper table that i can't change the structure or index on (due to it still being used by clipper). it has an index that includes a DESCEND(DTOS(indate)) function. vfp doesn't like this! it reads DESCEND() as DESCENDING() and errors with 'Function argument value, type, or count is invalid".

any way to avoid this w/o changing the index?

i was thinking along the lines of by-passing the DESCENDING() function somehow by writing a DESCEND() function that just returns a -ve of whatever was passed - but in this case DESCENDING() keeps jumping in before my function!

i've also tried an ODBC driver but this crashes vfp and i'm waiting on a fix but this may take a while.

TIA for any suggestions!
barry