Rosetta Xtra's database functions provides Director developers the power and ease of integrating databases into their products. There is no need to study hundred page manuals or learn low level database architecture. These high level database functions allows any developer the ability to add database features into their application quickly, and painlessly. For users wishing for maximum flexibility, Rosetta now provides capabilities to work on a recordset level.
By having the ability to work with any database format using the same syntax, you can effortlessly migrate you database solutions with very little code change. Many developers like to start small with a Microsoft Access database. When the project grows large, they can switch to Microsoft Exchange Server without having to worry about rewriting their entire database code.
The database functions uses Microsoft ADO technology. With the proper drivers, these database functions support all the popular databases such as SQL Server, MySQL, Microsoft Access, Oracle, Microsoft Access, Microsoft Excel, dBASE and many others. There is no need to waste valuable time and processor power to covert your database into proprietary formats. By working with standardized and popular database format, developers will enjoy the benefit of integrating or sharing data with other software applications and vendors. There is no need to worry about incompatibility issues.
Working with recordsets
With version 1.0.5, Rosetta provides the ability to navigate through recordsets. A Recordsets is a collection of records. By using recordsets, users can traverse through rows of records, update existing rows, and insert new rows. All recordset functions begin with the prefix "dbRs". In order to use the recordset functions, you must first open a valid connection using dbOpen( ) then open a recordset using dbRsOpen( ). Once you are done working with a recordset, be sure to call dbRsClose( ).