Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Double entries and views
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00617442
Message ID:
00617443
Vues:
24
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform