A blog on Tally Integration, to import and export data from Tally.ERP programmatically using VB6, VB.NET,C#,ASP.NET etc

Monday, February 13, 2012

DOT in Ledger Name

Case I - Works Fine
Ledger Name: Arihant Industries
SELECT Statement : Select $Name,$Parent From Ledger where $Name="Arihant Industries"

Case II - Does not Work
Ledger Name: Arihant Industries.
SELECT Statement : Select $Name,$Parent From Ledger where $Name="Arihant Industries."

Remarks:-
1) In Case II, the Ledger Name contains a dot (.) in the Ledger Name (viz Arihant Industries.). Using the SELECT SQL to search for the ledger name containing dot returns no result.
2) To resolve the issue, search for "Arihant Industries" (i.e. remove the dot from the Ledger Name)

No comments: