>Hi everybody,
>
>I have an application that looks like it was converted from 2.6 at some point and then moved to VPM 6.0
>
>The tables are in the database, but not really properly normalized. The Orders table has OrdNo field (Numeric 7), which I believe is supposed to be a PK in this table. I'm not sure how exactly it was populated originally.
>
>The question is - how can I generate the unique Order No ? I don't know if it would be a good idea to introduce counter table to this existing application?
>
>Any ideas here? I've searched the whole project and I don't see a single INSERT command involving OrdNo field - it is probably done with APPEND BLANK and REPLACE.
>
>Thanks in advance.
If the number looks sequential then you may calculate max()+1 at saving point and use it for the next record. Insert command would be checked for candidate/primary key duplicate error. It should be sufficient if number of users is small.
Edward Pikman
Independent Consultant