This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
programs:odxsql:home [2009/12/08 17:17] tdo |
programs:odxsql:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 36: | Line 36: | ||
| * OdxSQL connects to an Omnidex Environment or ODBC or JDBC Omnidex File Datasource (DSN). | * OdxSQL connects to an Omnidex Environment or ODBC or JDBC Omnidex File Datasource (DSN). | ||
| - | | + | * connect myenv.env |
| + | * connect mydsn.dsn using odbc (needs OdxNet running) | ||
| + | * connect mydsn.dsn using jdbc (needs OdxNet running) | ||
| * OdxSQL automatically terminates commands and SQL Statements with a return <cr>. | * OdxSQL automatically terminates commands and SQL Statements with a return <cr>. | ||
| * Use the backslash %%[ \ ]%% statement continuation character for multi line statements. | * Use the backslash %%[ \ ]%% statement continuation character for multi line statements. | ||
| Line 50: | Line 53: | ||
| * Use SHOW ALL to see all tables, including internal system tables. | * Use SHOW ALL to see all tables, including internal system tables. | ||
| - | * Create scripts and process with the USE <scriptfile> command or the OdxSQL -use scriptfile | + | * Create scripts with an editor and process with the USE <scriptfile> command or the OdxSQL -use scriptfile |
| | | ||
| * Use EDIT to edit the last statement using Windows Notepad or Linux/Unix vi or emacs. | * Use EDIT to edit the last statement using Windows Notepad or Linux/Unix vi or emacs. | ||