How to Restrict Maximum Data Collection In ODBC

Discussion in 'Tally Developer' started by Arun Prasath, Jan 29, 2021.

    
  1. Arun Prasath

    Arun Prasath Member


    Dear Friends,


    I have done a TDL to display the Data in ODBC. Pls, see below TDL. I need to limit the entries, therefore I used “Max” attribute the limit of the entries.

    [Collection: VchSMSMsgColl]

    Type: Vouchers
    ;; Is ODBCTable: Yes
    Max : 5


    [Collection:NGST SMS Messages]

    Source Collection: VchSMSMsgColl
    Compute: SMSName : If @@IsSales then $PartyLedgerName Else $LedgerName
    Compute : SMSMessage : $NGSTSMSMsg
    Compute : LedMasterID : $MasterId
    Compute : LedAlterID : $AlterId

    Is ODBC Table: Yes
    Sort : @@Default : $LedMasterID

    Filter: IsEmptyMsges


    [System:Formulae]

    IsEmptyMsges : Not $$IsEmpty:$SMSMessage


    But I am getting the same entries. Pls let me know how I shold use “Max” attributes in the collection level or do I need to use any other attributes?
     


Share This Page