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.