General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Todd
>I know this is wierd, but its a wierd problem. Try deleting the tags one by one and see if there is one particular index that is creating the problem. Some strange stunt with a udf or something may have been pulled, or maybe a function that has changed it behaviour between the two versions may be in use.
>
Sorted - figured it out this morning. It is indeed an index problem because the index (carried forward from my dos app) is based on a date expression which the new vfp strictdate analysis finds to be capable of creating "ambiguous dates" and so it throws up an error. Replace the date expression with the new "date(y,m,d)" format and its happy as Larry. The only problem is that I can't do that with the live data as the dos version wont recognise the new date expression, but as there doesn't seem to be any evil consequence, I guess I'll just have to live with it for a few months until I've got all my users converted to the vfp version.
Cheers
Harry
Previous
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