Hello guys,
Could you pls give me an advice?
I'm trying to create a computed column method on my custom view.
Here is the code
private static server str accountName()
{
SysDictTable CustTable = new SysDictTable(tableNum(CustTable));
str strQuery;
strQuery = strFmt("select top 1 &1 from %2",
CustTable.fieldname(fieldNum(CustTable, AccountNum), DbBackend::Sql),
CustTable.name(DbBackend::Sql)
);
return strQuery;
}
it's not synchronised giving an error. What am I doing wrong? isn't it possible to build free sql queries for the computed column?
Thanks.


Report
All responses (
Answers (