课程: SAP Business One: Reporting and Customization

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Debug a query

Debug a query - SAP ERP教程

课程: 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…

内容