Friday, June 22, 2007

Working with User-Defined-Collections

This post illustrates how to fetch data from User-defined-Collection (MyStatistics) which is created in program TDL26. For information on program TDL26, visit tdlplayground.blogspot.com


Usage:-

SQLRequest("Select $AllLegers,$DebtorsLedgers,$CreditorsLedgers from MyStaistics")

Using WRAPPER.EXE:-
1) Create a TXT file (say Test.txt in C:\RTSLINK folder) that contains the following SQL-SELECT statement:-

Select $AllLegers,$DebtorsLedgers,$CreditorsLedgers from MyStatistics

2) Go to DOS-prompt and change to C:\RTSLINK folder.
3) Type out the following command:-
   WRAPPER    TEST.TXT   /SQL

Notes:-
1) Wrapper.exe is shipped with RTSlink DLL
2) You must have RTSlink (Original or Demo version) installed in your system.

0 comments: