Modify record with RECORDID

vijay4398

Hi Experts,

I wish to find and modify a record based on the RECORDID i have in the text variable . Like for GL Entry i have

text1:= 'Entry No. : 12353' in the text variable . while trying to find this record i am doing the below


recref.OPEN(17);

evaluate(recid,text1);// Here it doesn't convert it right , gets something like 'Entry No. Amount Buffer : 12353'
recref.GET(recid);
recref.SETTABLE("GL ENTRY");
Message('%1',"GL ENTRY"."Posting Date");

Could anyone guide me with this ,Where i am wrong.

Thanks in Advance,

Vijay

kapamarou

vijay4398 wrote:

'Entry No. : 12353'

Where do you get this value from?

crisnicolas

Try GETTABLE instead of SETTABLE

vijay4398

The Error comes on this statement

recref.GET(recid);

as i understand ,here recid has wrong value(so its not able to find the record) : how could i get the value that i have in text variable change to type recid as evaluate is getting me wrong result..

Any other way to do this

Thanks,

Vijay

Duikmeester

Step 1, text1 should be 'G/L Entry: 12353' for it to work the way you want it.

Step 2 should be: recref := recid.GETRECORD;

dipsy2011

Just change the text1 to 'G/L Entry: 12353' or '17:12353'.
It will work