Lounge - .Net tally integration - Asked By priyanka ranka on 16-Feb-12 06:45 AM

hii,
i am working on tally integration project
i want to write a Tally definetion function into xml format



The above code id written in TDL . I want to write this function into xml format
can anyone help me
Somesh Yadav replied to priyanka ranka on 16-Feb-12 08:06 AM
A Collection can be made available to ODBC by following two
steps procedure
1.By exposing methods of the Object(s) of the Collection.
2.By using Collection attribute 'Is ODBC Table
Exposing Methods to ODBC
By prefixing '_ to external method(s) of an internal object or method(s) of an external Object can be exposed to ODBC.
  • By default all the methods of the internal objects are exposed to ODBC
  • Only First level methods of an Object can be exposed directly
Example :
[#Object : Ledger]
_Difference : $ClosingBalance -$OpeningBalance
The code snippet alters an internal object, Ledger, to add an external method, _Difference and
exposes it to ODBC.
Exposing Collections to ODBC
A Collection is exposed to ODBC by using the attribute, IsODBCTable.
Example :
[Collection : Vouchers]
Type : Voucher
Is ODBCTable: Yes
The Collection Vouchers is exposed to ODBC by using the attribute IsODBCTable.
after doing that you can use either of
TallyCn ADODB.Connection;
TallyCn = New ADODB.Connection();
TallyCn.Open ("TallyODBC_9000");
ADODB.Recordset rst = New ADODB.Recordset();
rst.Open ("Select $Name From Ledger", TallyCn, adOpenDynamic, adLockOptimistic);
OR

objCmd.ActiveConnection = TallyCn;
objCmd.CommandType = adCmdStoredProc;
objCmd.CommandText = "_PartyBills";
//'Pass the the Stock Item Name as Parameter
objCmd.CreateParameter (ODBCMAIN.CmbLedger.Text);
//'Call the SQL procedure
DataSet objRs = objCmd.Execute();
priyanka ranka replied to Somesh Yadav on 17-Feb-12 12:47 AM
thank u

but i want to write this code using XML interface only