Overview
The purpose of QQube is to hide the complexities of getting data from QuickBooks, but there are instances where a project developer needs to create a SQL query to extract a certain piece of information. We provide an easy way to create manual SQL queries, as the Excel Add-In acts as the front-end to MSQuery. No need to write code from scratch
Steps
First load the data model you want and ensure that there are no synch errors.
Open up one of the examples, invoke the add-in and select your fields.
Retrieve the SQL Statement from the Connection Properties as shown here:
If your needs are for advanced SQL elements and functions, you can use this page on Version 12.0.1 for SQLAnywhere for reference:
NOTE: QQube uses SQLAnywhwere version 17, but the commands and functions have not materially changed from version 12.x
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article