The BUG relating to SQL-SELECT statements
The SQL-SELECT statement in Tally returns incorrect result when some specific characters are used like period (a dot).
Steps to replicate the problem:-
Step 1
Create a new Company in Tally (we tested it with Tally 7.2, Tally 9 Release 2.14, Tally 9 Release 3 [Beta])
Step 2
Select option "Gateway of Tally >> F12 >> Accts / Inventory Info". Next, set the option "Use PART NUMBERS for Stock Items" to YES under the section "Inventory Masters"
Step 3
Next, create two Stock Items using option "Gateway of Tally >> Inventory Info >> Stock Items >> Create" as shown below:-
Step 4
STOCKNAME PARTNUMBER
Cylinder 100
Cyl. Block 101
Try out the using following SQL-SELECT statement.
SELECT $Name,$AdditionalName FROM Ledger where $Name="Cylinder"
Result:-
Correct. You get one record.
Step 5
Next, try out the following SQL-SELECT statement.
SELECT $Name,$AdditionalName FROM Ledger where $Name="Cyl. Block"
Result:-
Incorrect. There is no output even though the Stock-Item "Cyl. Block" exists in Tally.
Step 6
Next, try out the following SQL-SELECT statement.
SELECT $Name,$AdditionalName FROM Ledger where $Name="Cyl Block"
Result:-
Correct. You get one record.
Conclusion
Case 1 (refer Step 5)
$Name="Cyl. Block" does not work even though the Stock Item exists in Tally. This is because we have used a dot (period) i.e (Cyl. Block)
Case 2 (refer Step 6)
$Name="Cyl Block" works fine and the query returns data.
2 comments:
Can we extract invoice details from tallyodbc server to MS excel / MS access, if possible please guide me to get it.
Sunil
We have two free Utilities viz a) UDIMagic Free Edition in which you can pull data using SQL-SELECT statements. However, there is limitation like all LedgerNames will appears in a single column. b) RTS-XQuery Freemium which uses XQuery to retrieve data from Tally. You can retrieve almost anything from Tally, in flat (single table) or in multiple tables (relational tables). Refer this link to get more details on the above two utilities :- http://www.rtslink.com/free-tally-utilities.html
Post a Comment