TDL to connect to sql server

Sir,

In the following code I want add if condition to read data which having the status of only "Present".

110 : WALK COLLECTION : TSPL FFE ExcelInventory
112 : INSERT COLLECTION OBJECT : AttendanceEntries
113 : SET VALUE : Name : $EmployeeId
114 : SET VALUE : AttendanceType : $Status
115: IF : $$IsSysNameEqualroduction:$AttendanceProductionType:AttendanceType:$Status
116: SET VALUE : AttdTypeValue : $$TGTObject:$$AsQtyProdAttdValue / 60
117: ELSE:
118: SET VALUE : AttdTypeTimeValue : $Duration / 60
119: END IF
120: SET TARGET : ..
121: END WALK
122: SET TARGET : ..
123: SAVE TARGET


Please help me.


Thanks and Regards,
Sushma A Jainar

 

i dont know why you guys are using sql directly , it is very worse to communicate directly
because sql is very sensitive without proper sanitizing the request parameter led to corruption or deletion entire database
with the help of http track and sql map tools one can easily attack your database

i recommend you dont directly implement sql connection from tally
try to post the required parameter for your query to the backend script like php, java, node let them process request and get back the data safely


happy coding

 

Is there any sample code of bank end script in C# or Java Node please post it for community benefit sir

 

Can You provide me C# sample code to import data from excel to tally.ERP 9. Thanks in Advance

 

Sample code to import ledgers from excel to tally is available here
http://tdlexpert.com/index.php?threads/c-code-to-import-ledgers-from-excel-to-tally.6979/