corrupt database
Elizabeth Robar
erobar at earthlink.net
Fri Jan 31 16:32:23 CST 2003
Hello, all,
Take a database (mine has about 6 tables and WAS working beautifully),
and in ViSQL Carbon run the statement
SELECT * FROM sysitem WHERE Value<>0
(I was trying to figure out how to return all the fields in a given
table so I could write some scripts more easily)
ViSQL Carbon crashes mightily, and the sysitem table seems to be wiped
out... making all the data in the database inaccessible!
So, first question: is there any way I can retrieve the data I've lost
access to? And what basic things ought I to know, so I don't do
something so disastrous again? I hope this is more than just a lesson
in the importance of backups!
Thanks in advance,
Liz
More information about the Valentina
mailing list