Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What was the developer thinking?
Message
 
 
To
15/07/2009 16:39:07
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01412303
Message ID:
01412568
Views:
44
>>I somehow duplicated it 2 days ago. And in my case with even worse result - same ID for two different customers / sales.
>
>Are you absolutely sure that they are accidental duplicates or fantom records? I ask because sometimes in quoting systems a record is kept to show each quote that was presented to a prospective customer and those records are kept for historical purposes. The changedate makes me wonder...
>
>There are some times when non-normalized data is required.

The records are absolute duplicates - each field is the same. I see your point, though - may be it's intentional?

Also for the particular ConfigID I was seeing the duplicates in addition to two same records there was another record with the same ConfigID and Type, but different date and customer's info. The top cursor result in my screen shot demonstrated that.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform