Bug? on insert into previously deleted recid

Tim James tjames1 at bigpond.net.au
Fri Apr 23 10:30:12 CDT 2004


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


More information about the Valentina mailing list