Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 4.1

COLUMN

REALbasic 2005 New Database Features

A look at REALSQLDatabase and more

Issue: 4.1 (September/October 2005)
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software, producers of SQLVue, RBUnit and other products.
Article Description: No description available.
Article Length (in bytes): 4,347
Starting Page Number: 32
Article Number: 4114
Related Link(s): None

Excerpt of article text...

Welcome back! This month we'll be going over some of the database-related changes included in REALbasic 2005.

REALSQLDatabase

The biggest change is that REAL Software has added yet another built-in database format. This new format, REALSQLDatabase, is based on SQLite 3 and SQLite Plugin Pro. SQLite Plugin Pro used to sell for $120 just by itself. Now it is included in REALbasic 2005 for free!

REALSQLDatabase is supported on Mac OS X, Windows and Linux, but it is not supported on Mac Classic so you'll need to keep using the older REALDatabase there.

SQLite is different than most databases in that it is not really type-specific. Although you can specify a type when defining columns (referred to as its "affinity" in the REALbasic Language Reference), you can pretty much store anything you want in any column. REALbasic attempts to be smart about this so that a column defined to store integers will attempt to have data converted accordingly, but there is nothing that prevents you from storing a string in an integer column. There is also no specific date column type.

SQLite supports more SQL than REALDatabase does and also has the ability to have views.

...End of Excerpt. Please purchase the magazine to read the full article.