Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Empty fields on buffered tables
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01400179
Message ID:
01400180
Vues:
37
>I am not sure how to ask this question.
>I am using a grid for data entry. the table is buffered. The user can edit many records. Save updates all changes.
>I am looking for the best way to tell if any field values were left empty on any record during ADD. Checking the current record is no issue. Doing a SELECT for empty field values always finds new record with empty values because the new values for the added record are in memory, hence the error message displays.
>Also does GETFLDSTATE 2 mean there is a value or does it mean the value has changed to a "value" or an empty value?
>How do I not get the record being added when verifying for empty values?

The recno() for newly added records in buffered mode would be negative. So, you can loop though records of getnextmodified and see if recno() is negative.
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