Valentina ADK for Revolution 4.0.1

Enhancements:

• Valentina for Revolution Improvements
• • [NEW][API] Class VProject
  • [NEW][API] Class VReport
  • [NEW][API] Class VQueryResult
  • [NEW][API] Valentina_GetLocalConnection()
  • [NEW][API] VConnection_SqlSelectRecords()
  • [NEW][API] VConnection_SqlExecute()
  • [NEW][API] VConnection_SqlQuery()
  • [NEW][API] VConnection_SqlSelect()
  • [NEW][API] VDatabase_Connection property
  • [NEW][API] VDatabase_SqlQuery()
  • [NEW][Example] SQL_way/Field_Pictures
• Valentina KERNEL Improvements
• • NEW] UUID() -- function that returns 16 byte unique value
  • [NEW] get_fields_as_string() -- function to concat all fields values to the string
  • [NEW] Last_RecID_Of_Table(tblName) - return the last inserted recID for particular table
  • [NEW] Current_UserID()
  • [NEW] List_ItemCount( inList as string [, inDelimiter as string] )
  • [NEW] List_NthItem( inList as string, inItemIndex as integer [, inDelimiter as string] )
• Valentina SQL Improvements
• • [NEW][SQL] SELECT ... FOR XML [RAW|AUTO ELEMENT] -- produce XML output from inside of a TEXT Field of a returned cursor
  • [NEW][SQL] SELECT ... FOR REPORT project.report AS {PDF|HTML|JPG} PAGES start TO end
  • [NEW][SQL] Correlated sub-queries implemented.
  • [NEW][SQL] CREATE/DROP USER command
  • [NEW][SQL] GRANT/REVOKE commands
  • [NEW][SQL] SHOW GRANTS
  • [NEW][SQL] DROP CONNECTIONS
  • [NEW][SQL] REGISTER/UNREGISTER DATABASE
  • [NEW][SQL] REGISTER/UNREGISTER PROJECT
  • [NEW][SQL] CREATE/OPEN/CLOSE PROJECT
  • [NEW][SQL] SHOW PROJECT
  • [NEW][SQL] SET var = GET PROPERTY X [OF Y] syntax for Stored Procedures
  • [NEW][SQL] Dynamic cursor declaration
  • [Impr][SQL] CREATE EVENT now have [OR REPLACE] part.
  • [Impr][SQL] CREATE DATABASE [IF [NOT] EXIST] db_name [WITH SET PROPERTY property_name_list OF DATABASE TO property_value_list]
  • [Impr][SQL] Ability of using aggregative function in the having clause for pointing out the group by result column.
  • [Impr][SQL] Joins on Recursive tables for FK and ObjectPtr links now take into account order of fields in the join-condition.
  • [Impr][SQL] Joins on recursive link specified by name now can choose ToParent or ToChild direction.

Requirements:

• Mac OS X 10.4 or later
• Revolution 2.8 or later.