Hello!
I'm trying to insert a new query category into table OQCN.
The column CategoryId is the numeric field that identify de category.
When I try to insert the new category, I can get the max number in that column and set the new categoryid to (max + 1). The problem is that in another some table in SBO DB, that sequence is stored, and if a try to insert at front end SBO it tries to insert in the same number that I've added and retrieve a primary key violation.
My question: Where do SBO store the numbering of CategoryId - OQCN?
Thanks in advance
Hélio F. F. Félix