Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery sob Transaction
Message
From
22/01/2003 07:33:44
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
22/01/2003 07:06:39
Marco Antonio Mazzarino
Dbroll Sistemas e Admin de Dados S/C
São Paulo, Brazil
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00744178
Message ID:
00744180
Views:
27
>Quando usando Requery() em local view sob TRANSACTION,
>obtenho a mensagem 1583 Command Cannot be issued within a transaction.
>
>BEGIN TRANSACTION
>...
>USE lv_anyview
>...
>Requery() - Erro 1583
>
>Há alguma outra solução para esta situação sem deixar de usar o view?
>
>Grato
>
>Mazzarino

Acho que a idea é fazer o Transaction dentro do view, e usar o Requery() antes:
use lv_anyview nodata
...
requery()
begin transaction
* fazer coisas aquí
if ...
  end transaction
else
  rollback
endif
use
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform