I know it sounds strange - to have a good database, then issue a SELECT
(Read) statement, and have it croak - but I've even reproduced it! My
(uneducated, wild) guess is that the system table sysitems didn't like
it somehow... whereas a normal, user-defined table might not have taken
it so poorly.
Unfortunately, I was using one-file mode - so the below method won't
help in restoring the data. I did have a backup, so it's not
essential... but I'm interested in possible restoration methods for the
future. Along with development, I'm doing a lot of manual input, and I
only make copies every so often... maybe I'll increase the frequency.
Thanks, though!
Liz
On Friday, January 31, 2003, at 04:49 PM, Ruslan Zasukhin wrote:
> on 1/31/03 11:32 PM, Elizabeth Robar at erobar /at/ earthlink .DOT net wrote:
>
> Hi Elizabeth,
>
> :-)
>
> Just only I have told on RB list that it is hard to corrupt Valentina
> db,
> And Ops...
>
>> 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!
>
> In fact this sounds strange.
>
> So you have had some GOOD DB with data,
> You open it in viSQL,
> and you do query and READ data.
>
> You cannot corrupt db if you DO NOT WRITE data into db file...
>
>> So, first question: is there any way I can retrieve the data I've lost
>> access to?
>
> 1) do you have 4 files mode in db ?
> Try move .vdb file into separate folder and open in VAPP.
> If this works then vdb is okay
>
> 2) try now open vdb + .dat
> If this also fine then problem in .ind
>
>> 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!
>
> Yes backups are important if you have important data.
>
> I don't know how you get corruption in this case.
> If you READ then no way for corruption.
>
>
> --
> Best regards,
> Ruslan Zasukhin [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan@paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://listserv.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina /at/ lists .DOT macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://listserv.macserve.net/mailman/listinfo/valentina
©2003 Elizabeth Robar |
