How to run SQL query executor in Marg
Email: [email protected] 1 | P a g e Web:www.margcompusoft.com
How To Run SQL Query Executor In Marg
Case1: Uses Item Wise Bill Detail
1. Update Software to with latest version from www.margcompusoft.com
2. Login with Admin ID Go To Marg/Counter Control Room as shown below and do the following setting Gateway of Marg or Counter =>Master=>Marg Setup=>Self Format=>
1st Step
2nd
Step
3rd Step
How to run SQL query executor in Marg
Email: [email protected] 2 | P a g e Web:www.margcompusoft.com
3. Enter Password.
4. Now create Query.
4th Step
5th Step
Enter Here Password
Click Here
How to run SQL query executor in Marg
Email: [email protected] 3 | P a g e Web:www.margcompusoft.com
5. Now SQL Query Form opens.
a) Add New / Modify / Delete / Save /Cancel Definition of abbreviations used
a. “Add New”= If want create new Query Now click here. b. “Modify “= If Want modify existing Query Now click here. c. “Delete”= If want to delete existing Query Now click here. d. “Save”= For Save Changes Now click here. e. “Cancel “= For Exit or cancel Now click here.
b) Code / Name Definition of abbreviations used
a. “Code”= Type here your Query Code of short form at 2 character. b. “Name”= Type here your Query full name at 25 character.
c) Date Reqd No/Yes Definition of abbreviations used
a. “No”= While run SQL Query Date selection not required b. “Yes”= While run SQL Query Date Selection Required
d) Type of Paste your SQL Query Definition of abbreviations used You can type here SQL Query.
Note: - If you trying to run INSERT, UPDATE, DELETE, ALTER, INTO command not allowed.
Use <SQL_DT1> for Date From & <SQL_DT2> for Date to.
6th Step
How to run SQL query executor in Marg
Email: [email protected] 4 | P a g e Web:www.margcompusoft.com
6. See the example.
Now I have select 3 data file and also use date command with formula system.
7. Now set User wise power authority SQL Query Executor. Login with Admin ID Go to Marg/Counter Master=>Change Operator Powers=>shown below and do the following setting. (Gateway of Marg or Counter => Master=>Change Operator Powers=>)
7th Step
8th Step
9th Step
Type SQY Query
Click Here For Save Changes
Click Here For Exit this Window
Click Here
SELECT A.VCN,A.DATE,B.MAILNAM,B.CITY,C.PRODUCT,C.PACKING,A.QTY,A.FREE,A.QTY*A.RATE AS AMOUNT FROM DIS A,ORDER AS B,PRO AS C WHERE C->CODE=A.CODE AND A.CODEP=B->ORDNO AND BETWEEN(A.DATE,<SQL_DT1>,<SQL_DT2>)
Find Below mentions SQL Query Format
How to run SQL query executor in Marg
Email: [email protected] 5 | P a g e Web:www.margcompusoft.com
8. Search SQL Query.
9. Now Enable or disable SQL Query Executor at use wise.
10. Now Execute the SQL Query. Gateway of Marg or Counter =>Daily Report=>SQL Query Executor=>
10th Step
11th Step
Search “SQL Query”
Put “Y” After That Re-login
12th Step
Click Here For SQL Query Executor
SQL Query Executor Beta Version For Testing & Use! Enjoy Free
version upto 24-08-2014
How to run SQL query executor in Marg
Email: [email protected] 6 | P a g e Web:www.margcompusoft.com
11. Now select Query and enter date range if report generates date wise.
12. Now see the result.
a. Export Output (Now you can export output DBF/Text/CSV/Excel/XML) b. If want delete any column just select column name and click on delete button. c. If want to you shift column left to right or right to left or any after column just click on column and do
the Draw and Drop thru mouse.
12th Step
Click Here For Execute Selected Query
Enter Here Date Range From & To
Click Here For Export to EXCEl file
Type Here Date Range.
13th Step
How to run SQL query executor in Marg
Email: [email protected] 7 | P a g e Web:www.margcompusoft.com
13. How to export…
14. SQL Query Executor Beta version for testing Use! Only 10 rows allowed.
14th Step
Select Path
Type File Name
Click Here For Export File
15th Step
SQL Query Executor Beta version for testing Use! Only 10 rows allowed.
16th Step
File Saved Successfully!
How to run SQL query executor in Marg
Email: [email protected] 8 | P a g e Web:www.margcompusoft.com
15. Now open exported file.
Thank You
17th Step