Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple records update validation question
Message
 
 
À
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:
01226397
Vues:
11
>>>>
>>>>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.

I'm thinking now, that I should put validation in the table itself with field/record level validation rules.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform