SetControlValue From ClientExecSQL With Parameter
Fazlı Akça
Posted on January 15, 2024
<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>
<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>
💖 💪 🙅 🚩
Fazlı Akça
Posted on January 15, 2024
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.