In the Item Maintenance Page web page, we need to show a “Get ID” button.
When the “Get ID” button is clicked, it will access a database sequence called dbo.item_id_sequence and get the next value, like
SELECT NEXT VALUE
FOR dbo.item_id_sequnec AS SequenceValueWink
and populate the item_id field in Item Maintenance screen.
We wrote the business rule for the above and when we test in the item maintenance screen, we get an error
Login failed for user ‘MYDOMAIN1P21WEB1$’
We tested this C# code as a console app – that works fine.
Any suggestions are welcome.
1