4 replies to this topic

[lanta]

Hi,

I am having Issue with deleting the record in Auto Seq file (We are using PROIV Ver 7 and Reality Database). After deleting the records the subsequent records do not Auto Sequence.

I have tried deleting from a paging screen and report, both delete the records but do not auto seq.

 

In the Example below, We have 3 records with the same primary key plus the highlighted is the Auto Seq number Key (Last key on record)

 

BEFORE DELETING RECORDS

CEX  NTS-ADH2

OE  603873      DET  090314165529  0001

           AUTO NOTE FROM PROPOSAL-COST:000026.62 ITEM:!ADH COL:!6500 VEND:    300090

OE  603873      DET  090314165529  0002

           TEST NOT FOR AUTO SEQ

OE  603873      DET  090314165529  0003

           TEST NOTE FOR AUTO SEQ 2

 

 

When I delete the first record with the Auto Seq 0001 (ref below), number 0002 should become 0001 and 0003 should become 0002. But its not as shown below.

 

AFTER DELETING RECORDS

CEX  NTS-ADH2

OE  603873      DET  090314165529  0002

           TEST NOT FOR AUTO SEQ

OE  603873      DET  090314165529  0003

           TEST NOTE FOR AUTO SEQ 2

 

Thanks 

[Richard Brauer]

Lanta,

 

If you are still having problems with this please call me in the morning (after 8:30) at 951-334-2508.  I am in CA and hope you are not a Seahawks fan!

 

Richard Brauer

[lanta]

Hi Richard, I am still having the issue, I will call you tomorrow morning. Well I sometimes watch the Seahawks game and had a reason to party when they won the Super bowl.

Thanks 

Ajay 

[DARREN]

I recall us having a similar issue when using PROIV and Reality with auto-sequenced files. We tried to stay away from the auto-seq feature. If we needed the auto-seq feature we would load up the rows into a memory file that was defined as auto-sequenced, allow the user to manipulate the data, and then save it back to the masters.Not a solution but a work arround.

[lanta]

Thanks Richard and Darren, 

I guess this is a bug then, I will try to use the work around that you suggested.

I appreciate your feedback.

Ajay