Query wizard

Query wizard is the second tool to be discussed in this chapter. It is similar to query generator. We are going to compare both tools later in the book.

Query Wizard overview

Query Wizard enables easy access to the database and an easy way of building user-defined reports. It is designed for data retrieval/selection only. You are not able to do any DML queries such as updates, insert, or delete. This menu item can be accessed from Tools | Queries | Query Wizard.

With this tool, you can do the following:

  • Create queries through five steps from a fixed set of tables from SAP Business One
  • Access all data in those tables and get help from tips on each step
  • Create individual reports without writing any single query statements

Step 1—Splash ...

Get Mastering SQL Queries for SAP Business One now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.