Bug? on insert into previously deleted recid

[Tim James]

Whoops the message should read 'but instead the string value from the  
PREVIOUS recid'
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,Titl 
> e,CostPrice,OLSpecPtr,OLAcctPtr,Rectype,Supptr,InvoiceHdrPtr,OLReorPtr) 
>  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
>
>
> TIA
>
>
> Tim James
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>