V4MD corrupt database?

[Scott Runkel]

Ruslan,

Thanks.

> * Did you DELETE any records or only ADD them?
>    do you do Flush after Add/Delete ?

I did both. I deleted records using Vstudio, the browser, by clicking the "-" 
button.

> * you have work with this db only from your V4MD app?
>    not from Vstudio?

Both. Although I was using Vstudio mostly to get an overview of whether my 
changes via Director were working. And to delete those records.

> * To try fix this db please try clone it.

Will try, and will let you know if that worked.

This database was converted from v1 -- please let me know if I should consider 
building a fresh database from scratch.

-SR

Scott Runkel
Director of Technology
Hypix Media, Inc.
503-722-2123
----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Thursday, February 22, 2007 10:21 AM
Subject: Re: V4MD corrupt database?


> On 22/2/07 7:57 PM, "Scott Runkel" <srunkel at hypix.com> wrote:
>
> Hi Scott,
>
>> I recently upgraded to v2 and am using it with Director MX 2004 and V Studio.
>
>> Everything was going fine, I put about 30 records into my simple db, 
>> including
>> text, integers, varchars, and blobs (holding Director #text members). It was
>> working fine until for no apparent reason I started getting errors whenever I
>> attempt to open the table.
>>
>> In Director:
>>
>> Database error number: 628011
>> Segment "88" is wrong. The last segment is "30".
>
> * Some BLOB have become broken.
> It somehow point to segment 88 while only 30 segments present
>
> * Did you DELETE any records or only ADD them?
>    do you do Flush after Add/Delete ?
>
> * you have work with this db only from your V4MD app?
>    not from Vstudio?
>
> * To try fix this db please try clone it.
>
>
>> the SQL was:
>> SELECT *, recid FROM main WHERE item_num = 1
>
>> using:
>> cursor = pDB.SqlSelect(sql, #kServerSide, #kReadWrite, #kRandom )
>> ----
>> in vstudio
>> data browser for table "main":
>>
>> An unhandled exception occurred. Press "Abort" to terminate the program,
>> "Retry"
>> to exit the program normally and "Ignore" to try to continue.
>>
>> error report:
>> AppName: vstudio.exe  AppVer: 2.3.0.0  ModName: wxmsw26u.dll
>> ModVer: 0.0.0.0  Offset: 000a6fa1
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>