Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Missing Data in a SELECT
Message
From
16/07/1997 14:54:23
 
 
To
11/07/1997 18:24:05
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00039472
Message ID:
00040281
Views:
32
> Is the key "pure" date or a string date? > > *IF* a string date, maybe some records were created with a different SET > DATE format than the others??? The field was filled in with code similar to: m.CreaDate = date() gather memvar memo ie. it was a 'pure' date, and there was no question about the format or it belonging to the right century. The solution was to copy the data to a temporay table. Delete the table in question. Copy the data back to an empty structure. And re-generate the indexes. Thanks for all of the suggestions. /Paul
Paul Russell
EMail: prussell@fox.nstn.ca
Phone: (902) 499-5043
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform