Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple records update validation question
Message
De
16/05/2007 13:30:20
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01226060
Message ID:
01226100
Vues:
24
This message has been marked as a message which has helped to the initial question of the thread.
>>>
>>>A bit tedious, but I do not see a way to do it using direct control validations.
>>
>>It's not one 'record' at a time. It is one record set of values at a time. Later, before Tableupdate, you may use GetNextModified (i use it sometimes, it is not tedious at all), but it would be relevant only if something was modified directly in grid.
>
>In my case grid is only for navigation (read-only), but as I said, I have controls above the grid for the current grid record. I can modify values in these controls.
>
>And yes, they bound directly to CA's cursor. I don't use my late colleague approach of records array. I may review it one day, though. But right now I want to change my currently working form with minimal changes.
>
>I already started with adding EditBox validation for now.

So you edit one record at a time (at those external controls only). I would not put validation to container.lostfocus, it may get triggered inadvertently when user just clicked outside the container.
Basically, I would either have Add,Edit,Accept (with validation),Cancel buttons or have all validation in grid (i.e. GetNextModified) before TableUpdate.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform