Creating SQL Procedures using TDL

We can create a SQL procedures in Tally using TDL by adding "_" prefix to the collection name in the collection definition.

Code:

Syntax:
[Collection  : _CollectionName]

Sample TDL:

Code:

[Collection  : _LedBills]
Type: Bills
Child of : #UName
SQLParms: UName
SQLValues: Bill No : $Name
SQLValues: Bill Date : $$String:$BillDate:UniversalDate

 

If you are familiar with SQL Procudure.. use the above code and call it from SQL

 

It is not essential to learn this as a New TDL developer. You will get understand once you are become a basic TDL programmer. If we tell now also , you cannot understand.

 

Do you know any other programming language with Database concepts?