TDL Post Sql

[#Menu : Gateway of Tally]

	Add	: Item	: Fun	: Call	: FuncSQL1

[Function : FuncSQL]
	
	Variable	: SQLSTAT	: String
	Return	: String

	00 : Walk  Collection : Ledger
	01 : Set 			  : SQLStat 	: 'Insert into SundryDebtors (Name,Address) Values (' + "'" +$Name + "'" + ',' + "'" + $Parent + "'" + ')'
	02 : Log : ##SQLStat
	06 : Call			  : SQLColl
	05 : END WALK
	
[Function : SQLColl]
	02	: Walk Collection	: SQL Insert Query
	01	: Log : "Test"
	04	: Log	: ##SQLStat
	03	: End Walk

[Collection: SQL Insert Query]
	
	ODBC : "DRIVER=SQLite3 ODBC Driver;Database=D:\Db\CustomerInfo.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;" ;; connection string with db file name
	SQL :  ##SQLStat 
	
[System:Variables]
	
	SQLStat	: ""
	
[Variable : SQLStat]
	
	Type	: String