Jump to content


Photo
- - - - -

Deleting record in Auto Seq file

Auto Seq Deleting reality

4 replies to this topic

#1 lanta

lanta

    Member

  • Members
  • PipPip
  • 12 posts
  • Gender:Male
  • Location:Seattle

Posted 25 September 2014 - 09:34 PM

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 



#2 Richard Brauer

Richard Brauer

    Member

  • Members
  • PipPip
  • 24 posts
  • Gender:Male
  • Location:Riverside, United States

Posted 30 September 2014 - 12:02 AM

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



#3 lanta

lanta

    Member

  • Members
  • PipPip
  • 12 posts
  • Gender:Male
  • Location:Seattle

Posted 30 September 2014 - 12:16 AM

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 



#4 DARREN

DARREN

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 396 posts
  • Gender:Male
  • Location:Florida,USA

Posted 30 September 2014 - 08:44 PM

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.


Things should be made as simple as possible, but not simpler

#5 lanta

lanta

    Member

  • Members
  • PipPip
  • 12 posts
  • Gender:Male
  • Location:Seattle

Posted 30 September 2014 - 10:04 PM

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 





Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users