ID #1447

How to use Query Analyzer in FusionRetail6?

Answer:

New functionality added in FusionRetail6. Now you can run SQL queries directly from FusionRetail6 software. This query will run on the currently active database. Please use the following steps to implement this feature…

  1. Go to Settings > Database Maintenance > Query DB (T> D> Q)
  2. Type your query
  3. Press F5 (or you may also use ‘F5 Execute’ button)

To run your query on a different database use the following steps

  1. Go to Settings > Database Maintenance > Query DB (T> D> Q)
  2. Alt + N (or you may also use ‘–N New Con’ button)
  3. It will open a new window
  4. Select ‘Server Name’, 'Auth Mode’, ‘User Name’, ‘Password’ and ‘Database Name’, here.
  5. Click on ‘Ok’ button
  6. Type your query
  7. Press F5 (or you may also use ‘F5 Execute’ button)

Notes:

  1. All type of Query Execute here.
  2. When selecting data, all return data shows in Grid like Reports.
  3. In case of other Query such as Insert, Update, Delete message will be shown in Message Panel.
  4. If any Error in Query then shows in Message Panel with "Red" font.
  5. All the Status of Query , Server Name, Database Name and No of Rows shows in Bottom panel.
  6. Only one query can be run at a time.

Tags: Query Analyzer

Related entries:

You cannot comment on this entry