DEV Community

Fazlı Akça
Fazlı Akça

Posted on

SetControlValue From ClientExecSQL With Parameter

<row>
    <cell colspan="2">
        <control FieldName="ZZClientExecProc1" ControlType="Button" Caption="Yenile" ControlEditEnabled="False" Width="150">
            <ClientSideEvents ValueChanged="function (s,e) 
                              {ClientExecSQL('select AVG_BALANCE_DATE||chr(124)||AMT_BALANCE from table(get_entity_balance(@p1,@p2,@p3))', function (p) { var arr = p.split('|'); SetControlValue('ZZAvgBalanceDate',arr[0]),SetControlValue('ZZAmtBalance',arr[1]) } ,GetControlValue('CoId'), GetControlValue('CreditAccId')||'0', GetControlValue('DocDate'));}">
            </ClientSideEvents> 
        </control>
    </cell>
</row>
Enter fullscreen mode Exit fullscreen mode
<row>
<cell colspan="3">
<control FieldName="ZZAmtBalance" ControlType="SpinEdit" Caption="Bakiye Tutar" ControlEnabled="false" ServerAttribute="BackColor=#99FF99"/>
</cell>
</row>
<row>
<cell colspan="3">
<control FieldName="ZZAvgBalanceDate" ControlType="DateEdit" Caption="Ortalama Vade Tarih" ControlEnabled="false" ServerAttribute="BackColor=#99FF99"/>
</cell>
</row>
Enter fullscreen mode Exit fullscreen mode

Image description

Top comments (0)