Valentina ADK for REALbasic 4.0.1

Enhancements:

• Valentina for REALbasic Improvements
• • [NEW][API] Class VProject
  • [NEW][API] Class VReport
  • [NEW][API] Class VQueryResult
  • [NEW][API] Valentina.GetLocalConnection()
  • [NEW][API] VConnection.SqlExecute()
  • [NEW][API] VConnection.SqlQuery()
  • [NEW][API] VConnection.SqlSelect()
  • [NEW][API] VDatabase.Connection
  • [NEW][API] VDatabase.SqlQuery()
  • [NEW][API] Constructor VDatabase( inRbDatabase as VRBDatabase ) - bridge from RBDB way to Valentina API way.
• 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
• REALbasic 5.5 or later.