how to run sql query executor in marg case1: uses...

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



3. Enter Password.

4. Now create Query.

4th Step

5th Step

Enter Here Password

Click Here



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



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



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



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



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!



15. Now open exported file.

Thank You

17th Step

how to run sql query executor in marg case1: uses...

Documents