From the course: SAP Business One: Reporting and Customization
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Debug a query - SAP ERP Tutorial
From the course: SAP Business One: Reporting and Customization
Debug a query
- [Instructor] Now that you're adding SQL code directly to the query structure pane, you will be making mistakes in code, what we call bugs. On the lowest level of bugs is syntax and identity bugs. SQL is really bad at giving you good advice about your errors. Let me show you what those look like and how to fix them. Now one common bug is forgetting a comma or adding too many. After Production Order, just get rid of that comma, and then go back down and click Execute, and you'll see the red message on the bottom of the screen. This is a classic message you'll get if you have any syntax error. So usually it means you left off a comma. When you get this, check if you forgot a comma. If you go back up and add that comma back in, it'll run fine. You need commas between every column but not after the last one. If you put one in there, you'll also get an error. So let's go ahead and try that. I'm going to go up here, I…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Use the Query Generator3m 2s
-
(Locked)
Open the Query Manager4m 5s
-
(Locked)
Change a query with SELECT, AS, and FROM6m
-
(Locked)
Debug a query4m 32s
-
(Locked)
Filter a query with WHERE5m 6s
-
(Locked)
Add selection criteria parameters4m 5s
-
(Locked)
Use SQL functions2m 50s
-
(Locked)
Sort a query with ORDER BY3m 29s
-
(Locked)
Make decisions with CASE4m 4s
-
(Locked)
Types in SQL3m 51s
-
(Locked)
Challenge: Sales report in SQL48s
-
(Locked)
Solution: Sales report in SQL4m 12s
-
(Locked)
-
-
-
-
-
-