Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
END TRANSACTION generates an error
Message
From
10/05/2005 09:53:52
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01012418
Message ID:
01012425
Views:
20
Hi Sergey

Now I deleted one (the last) record and pack the table, at this moment I can insert data. But Why ??

It seems that there are one "bad record" in my table ...
But no error message was sended.


>Can you insert data if you pack the table?
>>
>>I´m using BEGIN TRANSACTION / END TRANSACTION and with just one table I can´t insert data, but if I "zap" this table I can insert data.
>>
>>I´m looking for informations in the help and there are this text:
>>
>>"If END TRANSACTION generates an error (for example, there is insufficient disk space to write changes to disk), changes made during the transaction are cancelled and the transaction ends."
>>
>>Well, How can I know what´s the error ?
>>
>>Thanks in advance.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform