Manual SQL Queries in QQube for QuickBooks | CLEARIFY

Creating Manual SQL Queries

We provide an easy way to create manual SQL queries, as the Excel Add-In is actually a front-end to MSQuery.

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 SQLAnyhwere version 17, but the commands and functions have not materially changed from version 12.x