Bug? on insert into previously deleted recid

[Tim James]

On 23/04/2004, at 3:47 PM, Ruslan Zasukhin wrote:

> On 4/23/04 8:37 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

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

> Have you made diagnose() for db? All right?

> 	yes - clean no errors
>
>> On 23/04/2004, at 10:30 AM, Tim James wrote:
>>
>>> The following statement  works fine when a new row is added to a
>>> table, but when the insert utilizes a previously deleted recid
>>> position (ie the row is inserted at recid = 7 in a 40 row table) the
>>> title field is not inserted but instead the string value from recid
>>> for that field is inserted.
>>>
>>>
>>> INSERT INTO Olines
>>> (Number,LineNo,ISBN,Qty,Price,QReceived,DReceived,Status,OLMastPtr,Ti 
>>> tl
>>> e,CostPrice,OLSpecPtr,OLAcctPtr,Rectype,Supptr,InvoiceHdrPtr,OLReorPt 
>>> r)
>>>  VALUES (2HO999,1,"0745150977",1,"12.95",0,"00/00/2000",0,0,"Afraid :
>>> Feelings","7.77",0,10,2,239,0)
>>>
>>>
>>> Valentina 1.10
>>>
>>> and
>>>
>>> Visql 1.1a23 using 1.10
>>>
>>>
>>> The error occurs both in my RB application and also ViSql
>
> -- 
> 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
>