https://www.omnidex.com/docs/v50/ 2026-09-24T16:44:40+0000 https://www.omnidex.com/docs/v50/ https://www.omnidex.com/docs/v50/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:28:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=programs:odxsql:commands:assignvalues&rev=1351261689&do=diff ASSIGNVALUES Description ASSIGNVALUES is used to assign an undetermined set of values contained in a buffer ($VALUES) to be used as selection criteria in a SQL select statement. The $VALUES buffer can contain a single value or an array of values. text/html 2012-10-26T14:28:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=programs:odxsql:commands:calc&rev=1351261689&do=diff OdxSQL CALC Operators: + \ / * ^ ( ) % is modulus calc 14 % 10 = is for assignment calc A = 1 calc B = 2 calc A + B KB is a constant for 2^10 MB is a constant for 2^20 GB is a constant for 2^30 text/html 2012-10-26T14:28:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=programs:odxsql:commands:connect&rev=1351261689&do=diff OdxSQL Connect Environment Description CONNECT establishes a connection to an Omnidex Environment and opens a cursor. CONNECT is followed by either an Omnidex Environment filespec or a File DSN for ODBC, JDBC or CLOA connections. Syntax CONNECT [TO] Omnidex_Environment [ON host[:port]] [AS [user]/[password]] [USING api] [WITH options] text/html 2012-10-26T14:28:09+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=programs:odxsql:commands:home&rev=1351261689&do=diff OdxSQL Commands and Omnidex SQL Statements OdxSQL: Overview Commands Settings Command Line Quick Ref Omnidex SQL: Overview Statements Functions Examples Quick Ref OdxSQL processes Omnidex SQL statements and OdxSQL specific commands either interactively or in batch oriented script files via the USE command. The following is a list of Omnidex SQL Statements and OdxSQL commands organized by type with a complete alphabetic list shown below.