Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Double entries and views
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00617442
Message ID:
00617443
Views:
23
This message has been marked as the solution to the initial question of the thread.
>Hello,
>I'm stumbling about a normally simple task:
>
>I have a view that is a subquery of a large table.
>If the user changes a record in this view, I need to check in the large table whether certain values that have been are still unique.
>
>In former times (without using a view) I just opened the table again and compared RECNO() of both tables, so if they were the same it's the same record.
>
>The table does not have a unique key (badly enough, but inherited from long ago), so I cannot really find out whether the edited record in the view is the same record in the table, if I found a "double" entry.
>
>Is there a way to check on the identity of the record without using RECNO() or another unique key?

Use your old technique, include recno() in the view :-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...


Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca
Previous
Reply
Map
View

Click here to load this message in the networking platform