https://www.omnidex.com/docs/v51/ 2026-04-23T11:52:06+0000 https://www.omnidex.com/docs/v51/ https://www.omnidex.com/docs/v51/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:57:31+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=programs:odxsql:commands:assignvalues&rev=1351263451&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:57:31+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=programs:odxsql:commands:calc&rev=1351263451&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:57:31+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=programs:odxsql:commands:connect&rev=1351263451&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:57:32+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=programs:odxsql:commands:home&rev=1351263452&do=diff OdxSQL Commands and Omnidex SQL Statements OdxSQL: Overview Commands Settings Command Line 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.