Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comando UPDATE não altera ultimo registro
Message
 
 
To
01/10/2004 10:12:53
Xenócrates Amon Mello
Universidade Federal do Paraná
Curitiba, Brazil
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00947926
Message ID:
00948256
Views:
24
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform