Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comando UPDATE não altera ultimo registro
Message
 
 
À
01/10/2004 10:12:53
Xenócrates Amon Mello
Universidade Federal do Paraná
Curitiba, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00947926
Message ID:
00948256
Vues:
25
This message has been marked as the solution to the initial question of the thread.
If table is in the record buffering mode, FoxPro will issue implicit TABLEUPDATE() for a record when you move of it. The last record wouldn't be updated because record pointer still on it. You cann issue explicit TABLEUPDATE() to commit changes to it.

>
>I'm developement a routine of upgrade to values, in a moment of process I have with multiplicate a constant numeric value of cursor's field begining in a determinated date. But, if I don't manipulate the cursor before the command UPDATE, the last register is not altered. Is it correct or is it a bug of FoxPro? I did tests with the same code in FoxPro 7,8 and 9, all they have the same problem.
>
>Thanks.
>______________
>
>
>*!* This command do not upgrade the last register of cursor with name in
>*!* variable _tabela, with can a relation of month values, case I don't
>*!* use a command SKIP or FLOCK()/UNLOCK.
>*!* t_indfator = constant value
>*!* &_percmodi..ind_data can to be a variable type date constant
>*!*
>UPDATE &_tabela SET &_tabela..valor = &_tabela..valor * t_indfator 
WHERE &_tabela..data >= &_percmodi..ind_data
>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform