How to access the record based on Record ID value

navmukesh

Hi

I have to access the record of the table based on the following information. Please guide as how this can be done -

Table Name - Record ID
Purch. Rcpt. Line - Document No.: PR01788, Line No.: 10000
Analysis View Entry - Analysis View Code: TEST1, G/L Account No.: 1350, Dimension 1 Value Code: 10, Dimension 2 Value Code: DEL, Dimension 3 Value Code: '', Dimension 4 Value Code: '', Business Unit Code: '', Posting Date: 16-12-1612, Entry No.: 22063

Thanks in advance

Regards

Luc_VanDyck

The shown Record ID's are the result of the function

String := Record.GETPOSITION([UseNames])

The opposite of GETPOSITION is

Record.SETPOSITION(String)

Both also have a RecordRef variant.

navmukesh

Hi Luc,

Thanks for the reply.

Actually I am in process of upgrading the Native database to SQL database. In the process, the table Incorrect Data Value is updated which ask if you would like to update the value to new value. I said no.

Now I want to update this with the new value. I have data in the Table Incorrect Data Value table.

Regards,

pdj

Why do you want to re-invent this code - why not just use the existing code?