Monday, 14 October 2019

Add display method to table using Extension class

[Extensionof(tableStr(CustTrans))]
final class CustTrans_Extension
{
    //[SysClientCacheDataMethodAttribute(true)]  //This attribute will cache your display method.
    public static display CustPurchaseOrder SalesTableCustReq(CustTrans _this)
    {
        CustInvoiceJour invoicejour;
        SalesTable      salesTable;
        CustPurchaseOrder  PO ="";

        select invoicejour
            where invoicejour.InvoiceId == _this.Invoice
                && invoicejour.InvoiceAccount == _this.AccountNum
                &&  invoicejour.LedgerVoucher   ==  _this.Voucher
            &&  invoicejour.InvoiceDate ==  _this.transDate;
        if(invoicejour)
        {
            select * from salesTable
                where salesTable.SalesId == invoicejour.SalesId;
            PO=salesTable.PurchOrderFormNum;
        }
       return PO;
    }
}


Add a string control to form, change properties
Data method :CustTrans_Extension::SalesTableCustReq
DataSource:CustTrans
Cachemethod:Yes

4-Customize this method in your Form 
locate your form and create a new string to add this method in the form 

set the properties for the string as the below

Data method format must be ExtensionClassName::MethodName

1 comment:

  1. Do you need Finance? Are you looking for Finance? Are you looking for finance to enlarge your business? We help individuals and companies to obtain finance for business expanding and to setup a new business ranging any amount. Get finance at affordable interest rate of 3%, Do you need this finance for business and to clear your bills? Then send us an email now for more information contact us now via (financialserviceoffer876@gmail.com) whats-App +918929509036 Dr James Eric Finance Pvt Ltd Thanks

    ReplyDelete