Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Corruption Using Cursors from SQL in Fox
Message
 
À
12/04/2001 11:16:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00494869
Message ID:
00495309
Vues:
14
We have the same problem with a particular table too. In our reproducable error situation, the problem occurs with a transactional delete in a row-buffered remote view with 10 records.

begin transaction
delete
sqlcommit ...
end transaction

The chr(0)-error occurs with the command "end transaction".

Microsoft tested the code too, they said with VFP7 Beta2 the error doesn't occurs.

We found out, that the error doesn't occur, when the remote view contains only one record. So we made a SPT-cursor for navigation with 1:1 relation to a master for data entry.

Bye,
Andreas
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform