The St James Software jQuery package is an interactive macro assembler and query tool that connects to the via the St James Software OLE DB provider.
You can type the query directly into the application and run the query immediately.
The results of the query will be displayed in the results window.
Alternatively, you can write SQL macros (meaningful segments of the SQL statement)
and the jQuery tool will put the complete statement together. Then just click
on the run button and the query will be executed.
To use jQuery, all you need to know is SQL. You can type in simple queries directly and get immediate results in the results window. As you get more proficient in SQL, you will be able to use more complex statements and then the macro ability of the tool will start to become extremely useful. Power users can of course dive straight into the macro side of the tool and start writing power SQL statements from the start.
Let us say you want to know what the last 24 hourly averages for two tags FIC100
and LIC100 are. You would type in the following command:
Select logtime, FIC100, LIC100 from one_hr where logtime > sysdate -1.
Now press the run button and you will see the results immediately. (For the
technically minded, the OLEDB server maps the highly optimized historical tables
into logical tables where the names of the columns are the names of the tags.)
You can write SQL statements that look at any data in the database, not just
the historical data. For example, you could look at data in a Lab results table,
or your tag name table, or your employee file etc, etc.
You can also write SQL statements that combine historical and non-historical
statements together. Now you can really use the power of the SQL language. Take
a look at the white paper on the jQuery tool for more examples on using the
jQuery tool.
jQuery is licensed per user. I.e. you purchase a license for each user that
will be using the package. You may also get the free jQuery which must be re-registered
at the end of each month at our website. We provide a button on the tool to
enable you to re-register quickly and easily.
A single jQuery license will cost you US$99 or you can buy the 5 pack for US$345. Alternatively, you can go for the free version, which you must re-register at the end of each month.
You can use all the constructs available in the database that you are using.
For example, you can create joins, unions, etc. You can create databases, modify
tables, delete etc. etc. Additionally, you can nest the SQL statements and sub
statements and you can write macro subroutines using the for..next macros.
The size of a single SQL statement must not exceed 64K characters. (This is
normally large enough for most applications.)
The queries run extremely quickly since they are passed directly to the database. Using the macro compiler of jQuery, you can replace big sections of VB code (where simple SQL statements are executed repetitively) with a single multi-nested SQL statement. In one example, where this was done, a single nested SQL statement took 4 seconds to execute where the equivalent VB program was taking 45 minutes!
Currently, jQuery will work with Oracle, Microsoft Access and Microsoft SQLServer. The data can be historical data or data that has been stored by any other program.
Once you have developed the SQL statement and checked that it works in the interactive window, you can store the compiled SQL statement using the "Save Results" button. You can then run this SQL statement a number of ways….You could run it from an SQL tool, you could insert it into a Crystal report application, or you can run the statement from a Visual Basic program using ADO. For the more advanced power users, you can even run the jQuery macro compiler on the fly and create a SQL statement and then run that statement all within the Visual Basic environment.
The jQuery package will run on Windows 95, 98, NT and Windows 2000.
In Visual Basic, you can pass parameters to the jQuery tool by modifying specific macros (for example a time clause) and then execute the macro.
You can get more summarized information by looking at our jQuery specs or if you want more detailed information you can look at (or download) our jQuery on-line help. Alternatively, you can download our free version here or purchase the Professional version here. Of course, you can email us or request a call from one of our engineers or from one of our system integrators. In any event, the power of jQuery is yours to enjoy!