Bug? on insert into previously deleted recid

[Ruslan Zasukhin]

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 ?

What type of Title field?  Text?

Can you send me db into which I can insert in viSQL?

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


> 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

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