Using GET with RecordRef

Rasmus Torpe over 18 years ago

Hi

I'm new to this RecordRef, FieldRef, RecordID functionality in Navision 3.60 so perhaps this is trivial questions, but here goes anyway... [:)]

My goal is to get one record from a table and be able to access the fields as an array.

Here's my code so far:

RecordRef.open(27); // Item Table
// Get one specific item
RecordRef.GET('1000'); // error - expects a recordID

// 'for'-loop though the fields using
// the RecordRef.FIELDINDEX function for this job
// possible change of some fields.

RecordRef.MODIFY; // save changes to record

So i guess my real question is how to use the recordID together with recordRef [?]

Any links to information about RecordRef, FieldRef, RecordID would also be nice... [:)]

Thanks in advance,

Rasmus Torpe

Parents

Emiel Romein over 18 years ago

If you create a function inwhich your parameters are tableno and the key of this table, you could do something like this.

recreffunc(database::item,item.getposition); // Call function

recreffunc(tableno : integer, tableposition : text 30);
begin
  RecordRef.OPEN(tableno);
  RecordRef.SETPOSITION(tableposition);
end

yogesh kumar over 11 years ago in reply to Emiel Romein

hi

i want to write data from table to text file when ever the record is inserted in table...
Cancel
Up 0 Down

Cancel

Reply

yogesh kumar over 11 years ago in reply to yogesh kumar

hi

is there any commend to get Table ID in to an variable
Cancel
Up 0 Down

Cancel

Children

No Data

Recommended

Using GET with RecordRef

Microsoft Dynamics 365 User Groups

Microsoft Dynamics User Groups