This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:home [2009/12/03 19:01] tdo |
dev:sql:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| ====== Omnidex SQL Quick Reference ====== | ====== Omnidex SQL Quick Reference ====== | ||
| - | ^[[programs:odxsql:overview|OdxSQL Overview]]^ [[programs:odxsql:commands:home|OdxSQL Commands]] ^[[programs:odxsql:settings:home | OdxSQL Settings ]]^OdxSQL Scripts^SQL SELECT^ Omnidex SQL ^ | + | {{page>:sql_bar&nofooter&noeditbtn}} |
| - | ===== Description ===== | ||
| - | ===== Syntax ===== | + | ===== Most Common Statements ===== |
| - | Statement | + | * SELECT |
| - | + | * CREATE TABLE | |
| - | ===== Discussion ===== | + | * CREATE INDEX |
| - | == arg1 == | + | ===== 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}} | ||