Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Delete On Problem
Message
From
21/04/1998 23:39:00
 
 
To
21/04/1998 23:13:09
Yogi Kim
Yogi Kim Consulting
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00091997
Message ID:
00093879
Views:
26
>If you want to avoid the duplicate key error, add !DELETED() to the filter of your index. Your primary or candidate index will then drop all the deleted records from the index.

but will it got problem on Table LInkage?!
on Index tag I put:
Name         Type           Expression
ItemKey      PrimaryKey     ItemKey And !Deleted()
...
I mean will it got problem on Inner Join?!
Or Simply I add like below:
Name         Type           Expression
ItemKey      NormalIndex     ItemKey
ItemKeyPK    PrimaryKey      ItemKey And !Deleted()
...
Since I am using Chinese Version VFP, the english word may wrong.
But I use first one to Join!?
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform