Database lost all data V4RB

[Ang Siow Chen]

I agree with Ruslan..

to delete 300,000 not 30,000 it takes only about 1 1/2 minutes wachr ecrod
has 100 fields...

and this is not the drop table.. this is using delete command.

If you mention that customer give you this database.. rightfully they should
have another copy.. somewhere..
You should ask thick skin or not for that original copy that they gave you
from!

We have been developing using valentina in Director and our data ammesses in
the gigabyte range and no such things happen..

we have over 10,000,000 records.. and each one when deleted also keeps an
archive... we are religious about doing this.. a log of what changes and
what was viewed..
if u need help I would be glad to give you some advice..

Warmest Regards,



Ang Siow Chen
Managing Director
Darke Entertainments
Off: (65)67266101
Fax: (65)62344416
Mobile : (65)91466101
Email : siowchen at darke.biz
Website : www.darke.biz

CONFIDENTIALITY CAUTION: The information in this email is intended solely
for the addressee(s) or entity to which it is addressed. The information
contained within is privileged and confidential. If you are not the named
addressee you should not disseminate, distribute or copy this e-mail. Access
to this email by anyone else is unauthorised. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. Any views, opinions, conclusions and other
information expressed in this message are those of the individual sender and
shall be understood as neither given nor endorsed by WebDials, except where
the sender specifically states them to be the views of WebDials.If
verification is required, please request a hard-copy version.

-----Original Message-----
From: Ruslan Zasukhin [mailto:sunshine at public.kherson.ua]
Sent: Tuesday, June 15, 2004 5:01 PM
To: valentina at lists.macserve.net
Subject: Re: Database lost all data V4RB


On 6/15/04 11:52 AM, "Cindy Brown" <cindy at kowhaiprogramming.com> wrote:

> Ruslan, there really is NO WAY for the client to delete the records
> themselves. There are about 15 base objects in this database and all but 2
> are completely empty. One of these alone had about 30,000 records and this
> base object CANNOT be deleted with a delete all as I have no options of
> deleting all records in any of the base objects.

Try to open db in hexedit.
Do you see just ZEROs in 8MB file or you see records ?

I can assume such case:
    records are in table, but counter in table header is zero.

This also must never happens in Valentina and there is no legal way to get
this.

Cindy all this really looks like mystery.
I really have no idea how it is possible to get FINE db with no records.


> I haven't come across this at all before. Normally there isn't a problem
> because they update to my server and everything is okay. Unfortunately,
due
> to the previous V4RB error in varchar, the server wasn't bringing across
the
> info from their office machine and they hadn't updated to the latest
> program. I guess we'll just have to go back and see when they did their
last
> backup. Thanks for responding.

--
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina