realbasic-nug
[Top] [All Lists]

Re: new SQL lite db from RB Database

To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: new SQL lite db from RB Database
From: Trausti Thor Johannsson <tj at quarksbar dot net>
Date: Wed, 30 Nov 2005 22:39:00 +0100
Delivered-to: realbasic-nug at lists dot realsoftware dot com
References: <226 dot 2eb6cc2 dot 30bf74f6 at aol dot com>
Just when you declare like

dim db as realsqldatabase

or

dim olddb as realdatabase


That is pretty much it. Just remember, sqlite (real sql database) is lightning fast and supports more sql commands. But as long as your app is "normal", then all you need to change is like the above. Just remember, the datafiles are not compatible with each other. so, like above, db can not open oldfile and olddb can not work with a new file.

Trausti
On Nov 30, 2005, at 10:34 PM, GAmoore at aol dot com wrote:

You access it the same, do almost everything the same.  The only is
declare a realsqldatabase instead of realdatabase.

Right. The API should work the same. The trick will be converting
your old databases to SQLite 3.


Thanks Will (again!) and Trausti.

All of the commands to build tables and grab recordsets are the same?
Thats great. So how does my program know (or care) if its opening an old db
or a new one?
Do I make two separate OPEN_DB methods, then save in the new form?



_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

<Prev in Thread] Current Thread [Next in Thread>