Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Question #433
Message
De
30/11/1999 17:55:46
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00297123
Message ID:
00297153
Vues:
27
>Sorry to ask so many questions on Views...
>
>I am trying to determine how to check and see if a record has already been added to a view.
>
>For example, I have a grid where you key in inventory skus. When the save button is clicked I can use v_MyView in 0 again alias v_MyView2 and then scan through the 2nd view to see if this particular sku already exists. If so pop up error message and don't save. This works fine for skus that were keyed in and committed. But my problem is if they key in the same sku twice in this session. v_MyView2 only has the records that were committed.
>
>I am using table buffering.
>
>Thanks,
>Paul

You could use v_MyView directly:
- record the record pointer RECNO()
- SCAN the view records
- Reset the record pointer when you're done.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform