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
View auto-incremented
View auto-incremented
Regards and thanks,
Harry Carter
Harry Carter
Re: View auto-incremented
From my understanding, the auto-increment fields will get updated when the record is created.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
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 ~
AwareIM 8.7 (build 3025) ~ MS-SQL ~ Windows 10 ~
AwareIM 8.5 (build 2828) ~ MS-SQL ~ Windows 10 ~
-
- Posts: 2400
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: View auto-incremented
Did you actually get this to work Roger.
I am trying it but that usage of MAX (and even COUNT) does not work
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: View auto-incremented
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...
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 ~
AwareIM 8.7 (build 3025) ~ MS-SQL ~ Windows 10 ~
AwareIM 8.5 (build 2828) ~ MS-SQL ~ Windows 10 ~