Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replacing value in Grid
Message
 
À
26/07/2023 12:29:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01686818
Message ID:
01686842
Vues:
33
>>2. REPLACE YourColumn WITH SomeValue IN YourTable -&& Put this code there where you want to update cursor
>
>needs the "for empty(YourColumn)" at least (which takes care of the implicit "!IsNull/YourColumn)" of if)
>
>IMO code not caring for record pointer move (same as in orig code) is bad style.
>Therefore I'd opt for SQL - update and second line moving record pointer explicit if really intended,
>(Or at least comments, why implicit record pointer move of replace kine is intended)
>
>Not going into record/table lock as _tally/Reccount of grid cursor probably small to make it irrelavant
>
>my .22€
>thomas

There is NO need of FOR after REPLACE, WHY you need this?
If I want to replace data in the current record of the cursor the I just replace it.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform