FormType of UDT

[Former Member]

Hi Experts,

I would make additional user authorization for some UserDefinedTable (UDT).

I have no problem in doing it by hand. Now I would try to automate this stuff.

Suppose I have an UDT called TRUCKS (belongs to @TRACKS table).

When I open the UDT form, I can read the Form Type. Suppose the FormType is '11005'.

Yes, of course, If I make this table on a new company most likely the FormType changes.

I have done a little test.

SELECT TblNum FROM OUTB WHERE TableName = 'TRUCKS';

On a system where the FormType is '11005' the query returns 5.

On a system where the FormType is '11011' the query returns 11.

So I can automate the process by retrieving the TblNum, add it to 11000 and cast it as string.

It is correct this method or I can't make assumption about the FormType of UDT?

Thanks in advance.

Carmine

[Former Member]

Jànos confirms my intuition. Thanks.

[Former Member]

Hello,

Yes, your are right, this is always true to receive the formid of a UDT

SELECT 11000  + TblNum FROM OUTB

Regards,

J