Field Exist

BHT
BHT Member Posts: 56
edited 2005-01-27 in NAV/Navision Classic Client
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: :?
Regards,
BHT

Comments

  • Tim81
    Tim81 Member Posts: 68
    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
    BHT Member Posts: 56
    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.
    Regards,
    BHT
  • randrews
    randrews Member Posts: 135
    RR - type RecordRef
    Item - type record Item

    For Example:

    RR.OPEN(DATABASE::Item);
    MESSAGE := FORMAT(RR.FIELDEXIST(Item.FIELDNO("No.") ));
  • BHT
    BHT Member Posts: 56
    Thanks randrews.

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

Categories