Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View does not send updates.
Message
 
À
30/06/2000 14:11:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00387120
Message ID:
00394417
Vues:
9
Hi Erik,
I did what you suggested. I found that the tableupdate was not committed because
the view was read only, how could that happened, the error number is 111,
it says 'Cannot update the cursor'. Any thoughs on that one ?

>Even though you are forcing updates, there are still several situation where TABLEUPDATE will fail: unique key violation, trigger failure, locked table header or record, etc. You should always check the results of TABLEUPDATE() to be sure and catch this...
>
>
>>Thanks much for your answer Erik,
>>I am not doing that because I and forcing a tableupdate with
>>=TABLEUPDATE(1,.T.), but I will check that. The only reason I think that could
>>make =TABLEUPDATE(1,.T.) to fail is somebody having a LOCK in the record, which is weird because this table is only updated through views.
>>
>>Thanks again, Erik.
>>
>>
>
>>>Are you checking the return value of your TABLEUPDATE()?
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform