View auto-incremented

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
numberz
Posts: 166
Joined: Sat Aug 05, 2017 12:13 am
Location: New Hampshire - USA

View auto-incremented

Post by numberz »

Hi,
I created a number attribute and made it auto-incremented. The number value shows up in the displayed list but I need it to show WHEN I'm entering values for other attributes. Why doesn't this value show up when entering?
Regards,
Numberz
Regards and thanks,
Harry Carter
rbross
Posts: 441
Joined: Wed Nov 19, 2014 4:13 am
Location: Coventry, Connecticut USA

Re: View auto-incremented

Post by rbross »

numberz wrote:Hi,
I created a number attribute and made it auto-incremented. The number value shows up in the displayed list but I need it to show WHEN I'm entering values for other attributes. Why doesn't this value show up when entering?
Regards,
Numberz
From my understanding, the auto-increment fields will get updated when the record is created.
If you want to see it when you are entering a new record create a rule like this
IF BO IS NEW
THEN BO.Number=MAX(BO.Number)+1 and it should display the next number
Roger Ross
AwareIM 8.7 (build 3025) ~ MS-SQL ~ Windows 10 ~
AwareIM 8.5 (build 2828) ~ MS-SQL ~ Windows 10 ~
customaware
Posts: 2400
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: View auto-incremented

Post by customaware »

Did you actually get this to work Roger.

I am trying it but that usage of MAX (and even COUNT) does not work
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
rbross
Posts: 441
Joined: Wed Nov 19, 2014 4:13 am
Location: Coventry, Connecticut USA

Re: View auto-incremented

Post by rbross »

Mark, yes I did get this to work. I use it when a new inventory item is created. The inventory number if separate from the ID that Aware created for the new record.
I have a process that does a ENTERNEW InventoryMaster with InvNo=MAX(InvNo)+1 etc...
Roger Ross
AwareIM 8.7 (build 3025) ~ MS-SQL ~ Windows 10 ~
AwareIM 8.5 (build 2828) ~ MS-SQL ~ Windows 10 ~
Post Reply