web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... select inside computed...

Finance | Project Operations, Human Resources, ...

Unanswered

select inside computed column method

(0) Share

Report

Report

Posted on by dark_knight

942

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.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

dark_knight 942 on at

Like (0)

Report

solved

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 663 Most Valuable Professional

#2

André Arnaud de Cal... 540 Super User 2025 Season 2

#3

Sohaib Cheema 348 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans