Field Exist

BHT

Hi all,
I need to have function to determine whether or not a field exist in a table.
Anyone have idea how to get this?

Tks.
:oops: :?

Tim81

Maybe, this:

FIELDEXIST (RecordRef)
Use this function to find out if the field that has the number fieldno exists in the table that is referred to by the recordref. The function returns an error if no table is currently selected.

Exist := RecordRef.FIELDEXIST(FieldNo)

Exist
Data type: boolean
The return value. The possible values are:
TRUE The field exists in the table
FALSE The field does not exist in the table

RecordRef
Data type: recordref
The recordref that identifies the record and the table that you are interested in.

FieldNo
Data Type: integer
The fieldno that you want to know whether or not it exists in the table.

The question is: for what do you need it?

BHT

Hi Tim81,
I've tried that function. But I can not compile it. it always prompt error message when compiled.
The error message indicating that the C/AL can not recognize this function.


Can you send me some sample of how using this function? :roll:
Thanks.

BHT.

randrews

RR - type RecordRef
Item - type record Item

For Example:

RR.OPEN(DATABASE::Item);
MESSAGE := FORMAT(RR.FIELDEXIST(Item.FIELDNO("No.") ));

BHT

Thanks randrews.

I've just found a sample of it in codeunit 408.
Thanks anyway.
BHT.