O'Reilly logo

Mastering SQL Queries for SAP Business One by Gordon Du

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required