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)
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:
Post a Comment