General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only