This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dev:sql:home [2009/12/03 18:59] tdo created |
dev:sql:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| <html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| + | ~~NOTOC~~ | ||
| ====== Omnidex SQL Quick Reference ====== | ====== Omnidex SQL Quick Reference ====== | ||
| - | ===== Description ===== | + | {{page>:sql_bar&nofooter&noeditbtn}} |
| - | ===== Syntax ===== | ||
| - | Statement | + | ===== Most Common Statements ===== |
| - | + | ||
| - | ===== Discussion ===== | + | |
| - | == arg1 == | + | * SELECT |
| + | * CREATE TABLE | ||
| + | * CREATE INDEX | ||
| + | |||
| + | ===== SQL Interfaces ===== | ||
| + | |||
| + | * JDBC | ||
| + | * ODBC | ||
| + | * Stored Procedures | ||
| + | |||
| + | ===== Omnidex SQL Tips ===== | ||
| + | |||
| + | SQL is the preferred way to access Omnidex enhanced data. | ||
| + | |||
| + | Use SELECT over QUALIFY whenever possible. | ||
| + | |||
| + | Getting Counts. | ||
| + | ===== Learning Omnidex ===== | ||
| + | * [[ tutorials:simple_flatfile | Creating a very simple flat file Environment and doing retrievals. ]] | ||
| + | * [[ tutorials:simple_flatfile_java_JDBC | Writing a simple JDBC program to access the simple flatfile Environment. ]] | ||
| + | * [[ tutorials:simple_flatfile_cpp_ODBC | Writing a simple ODBC program to access the simple flatfile Environment. ]] | ||
| + | * [[ tutorials:simple_flatfile_EXCEL | Using EXCEL to access Omnidex Environments with the ODBC Driver. ]] | ||
| + | |||
| + | ===== Special Omnidex SQL tokesns ===== | ||
| + | |||
| + | $omnidex - special table of one row and one column. Good to test functions, etc. | ||
| + | |||
| + | $uniquekey - | ||
| + | |||
| + | $ROWID - | ||
| - | == arg2 == | + | ===== See Also ===== |
| - | ===== Examples ===== | + | Omnidex SQL Statements |
| - | ==== Simple ==== | + | Standard SQL Functions |
| - | ==== 2nd example ==== | + | Omnidex Extended Functions |
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||