I’m working in NBS-3.70. In the table “Field” I got one record. For example: TableNo: 18 TableName: Customer FieldNo.: 2 Fieldname: Name With this record I want to get all the records in the “customer” table in the field “name”. Does anybody know how I can do that? Thanks.
I don’t now if this is what you want but I give it a try. Name DataType Subtype Field Record Field RecRef RecordRef FldRef FieldRef IF Field.GET(DATABASE::Customer,2) THEN BEGIN RecRef.OPEN(Field.TableNo); IF RecRef.FIND(’-’) THEN REPEAT FldRef := RecRef.FIELD(Field.“No.”); MESSAGE(FORMAT(FldRef.VALUE)); UNTIL RecRef.NEXT = 0; END;