Bug? on insert into previously deleted recid

[Tim James]

On 23/04/2004, at 5:13 PM, Ruslan Zasukhin wrote:

> On 4/23/04 10:08 AM, "Tim James" <tjames1 at bigpond.net.au> wrote:
>
>>> Hi Tim,
>>>
>>>> Whoops the message should read 'but instead the string value from 
>>>> the
>>>> PREVIOUS recid'
>>>
>>>
>>> You mean from previous delete, or
>>>     from previous 6th ?
>>
>>> from recid = 6
>>
>>> What type of Title field?  Text?
>>
>>> string(40) word indexed
>
> String. Hmm, here cannot be problems.
>
>
>>> Can you send me db into which I can insert in viSQL?
>>
>>> 250 mb and 200,000 recs - but I can send the empty structure or small
>>> part ???
>
> Wait. You can reproduce problem using only this database?
>
> Try reproduce it on table with 40 records only.
>
built small db with same schema - no errors
>
>>> Have you made diagnose() for db? All right?
>>
>>> yes - clean no errors
>
> Strange.
>

If diagnose ok  -how can I test/fix bad db.
I have tried reindexing etc
Error is 100% repeatable on DB production size - big problem
Can I export all tables then import and will objectptrs be ok (I 
presume so)

(very strange (When I insert enough rows to fill deleted recid's then 
insert works fine)



> Or you have bad db,
>     or you must be able reproduce on small table,
>         or there is no any problem, you just confuse something.
>
>


TIA

Tim




> -- 
> 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
>