fawzy_i_05
3rd December 2008, 22:15
Please I want a help files to create a table data field Authorization when the data in numerated like transaction types Quotation Status and its Created like that form "0x01" in SQL Server database
yashwant
4th December 2008, 07:55
What exactly you want,"how to give autoraization to table data field" or "to create a help file for this".
fawzy_i_05
22nd December 2008, 08:49
exactly i want to make authorizations on a table data on a specific user
but in some cases the table data in the database " SQL server 2000" are numerated type
plz help me
EdHubbard
22nd December 2008, 12:39
In 4c4, using session ttaad4134m000 Maintain Table Data Authorisations, you would enter a condition on the relevant field and in the Value1 field you can zoom off to see "Display Enum Constants". If you select one it enters that value in the Value1 field.
e.g. for tcyesno, you can select tcyesno.no which puts the value "no" in the Value1 field.
I haven't tested this actually works at session run time though!
Ed
fawzy_i_05
24th December 2008, 14:36
thx, but if the field data type is numerated, i connected to the sql database and its seen as 0x01 and 0x02 etc. what can i do with this case