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

Debug a query - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

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…

Contents