Skip to Content
0
Former Member
Sep 07, 2005 at 04:16 PM

What table store numbering Items - Query category?

538 Views

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