how to retrive specific data in Master Data Rows - GetByKey(code)

[Former Member]

hi

if user defined table is No Object type then we can retrive data by GetByKey(Code)

how can retrive data in Master Data Rows which contain Code & LineNum on both conditions i want to retrive data .

to retrive data should have to use query base select statement and assign to record set for this

pls give me the better solution for this

thanq

[gilbert_ngo2]

Hello,

Try using the recordset instead of getbykey function. But the Code column is unique so you won't be needing the LineNum column.

Regards,

Gilbert Ngo

[Former Member]

i want retrive data from master data rows where code and linenum is unique.

[Former Member]

You say you want to get things by Code and LineNum - my question is why ? Code is a unique column, you don't need to take LineNum into account.

But if you must have both, you can try using a recordset to query for the lines you need.