abby13
30th December 2008, 07:01
Is there any standard function or any other way to know whether a particular
filed is present in a table?
for eg. if "orno" is present in table tdsls400.
Thanking in advance...
SergioRuiz
30th December 2008, 09:50
Hi, you can try rdi.column.
Syntax
long rdi.column( string column_name(18), ref string domain_name(14), ref long offset, ref long size, ref long dept, ref long type, ref long flag, ref string default_val(.) )
Description
This returns information about a specified table column.
Arguments
column_name The name of the column about which you want to retrieve information.
domain_name This returns the name of the column's domain.
offset This returns the position of the column in the table.
size This returns the size of the column, in bytes.
dept This returns the depth of the column (array columns only).
type This returns the database type of the column. For
example, DB.LONG, DB.FLOAT, and so on. For a list of all
possible database types, see Database handling.
flag This returns a bit pattern that represents one or more of
the following values:DB.ARRAY,DB.FILLED,DB.CHILD
default_value This returns the default value of the column.
Return values
0 success
-1 error
© 1998 Baan Development B.V. All rights reserved
abby13
30th December 2008, 15:50
Thanks Sergio, i used rdi coulumn and it worked