Bug? on insert into previously deleted recid

Ruslan Zasukhin sunshine at public.kherson.ua
Sat Jun 12 12:14:35 CDT 2004


On 6/12/04 2:07 AM, "Tim James" <tjames1 at bigpond.net.au> wrote:

Hi Tim,

I have found 2 problems in your project.

1) minor mistake.
    table Crheaders, field NumberU have formula text "=upper()"
                                                    ^^^

    operator = must not present here.
    you can easy see this in viSQL or in VAPP.
    such mistake means that method will not work.


2) now serious mistake. You see problem with insert after delete BECAUSE
    
    in table onlines you have BaseObject method Numberu
    created in table BEFORE the field it refers the 'Number'.

    this is mistake similar to programming languages
    you refer to variable before it is created.

    as far I see Valentina 2.0 will be able work
    correctly in such situation,


It is hard to see creation order, I should say.
ViSQL sort fields in alphabetical order
VAPP show fields in methods in different TABs of dialog. Hmm.

I think you can see this only in XML dump.

    Jochen, I think Valentina Studio must allow see fields
    a) in alphabetical order
    b) in order of creation.
    c) later we want add custom order.

Tim, are you in the mode development?
If yes, then change order of creation of fields in your code.


> In Visql I listed all olines
> 
> SELECT RECID,* FROM OLINES
> 
> I then chose a recid (55) and noted and wrote down all the values of
> the fields
> 
> (of relevance  number = 0265,isbn=0140503986,title=Bad-Tempered
> Ladybird)
> 
> I then deleted that recid by
> 
> DELETE FROM OLINES WHERE RECID = 55
> 
> I then checked to see that recid =55 was gone
> 
> SELECT RECID,* FROM OLINES
> 
> I then immediately executed the following INSERT COMMAND (copied from
> my log/debug file of my app)
> 
> INSERT INTO Olines
> (Number,LineNo,ISBN,Qty,Price,QReceived,DReceived,Status,OLMastPtr,Title
> ,CostPrice,OLSpecPtr,OLAcctPtr,Rectype,Supptr,InvoiceHdrPtr,OLReorPtr)
> VALUES (31906,1,'0732277310',2,22.95,0,'00/00/00',0,154,'Due
> Preparations For The Plague','13.08','0','0',3,77,0,0)
> 
> I then listed the recid as follows
> 
> select from olines where recid = 55
> 
> I then noted that the following fields had assumed the value of the old
> values of the record I had deleted
> 
> number = 0265,isbn=0140503986,title=Bad-Tempered Ladybird



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



More information about the Valentina mailing list