Discussion :

[Yepraqsya]

Hi everyone. I'm starting learning Sage ERP X3 v6.I want to get table data using table field name as string in function like this
Func GET_VALUE(TB_ABBR, TB_FLD_NAME)
Value Char TB_ABBR, TB_FLD_NAME
Return [TB_ABBR]TB_FLD_NAME
Help please!!!!!

[BF0509]

HI,

what is your goal ?

if you want to read one line of your table, you have to use the function read after using clalev

clalev is for open the table
read is for reading a line with the indek key value

if !clalev[ITM]ITMMASTER : local file [F:ITM]ITMMASTER

read [ITM0]ITMREF = XXXX

MYFILD1 = [F:ITM]FIELD1
...

return MYFILD1 ...

[Yepraqsya]

I want write function for more tables not for one. So i want to call giving table name and field name.

[Yepraqsya]

I found solution ))))
Funprog GetValue(Tb_name, Field_name)
Value Char Tb_name
Value Char Field_name
Local File =Tb_name [XXX]
Local Char Field_Value
Field_Value = num$(evalue("[F:XXX]"+Field_name))
End Field_Value