Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Sat Dec 15, 2018 10:03 pm
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: RB2005 Database
PostPosted: Thu Oct 13, 2005 11:33 pm 
Offline

Joined: Fri Sep 30, 2005 9:30 pm
Posts: 1712
Location: U.S.A.
I just looked at the database for the first time since installing 2005. Has the database engine changed again? If so, will it still support the version of database in 5.5.4? As I recall, the database file extension has changed fro .rdb to .rsd and I didn't see any options for choosing the previous version.


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Fri Oct 14, 2005 9:45 am 
Offline

Joined: Fri Sep 30, 2005 9:18 am
Posts: 239
Location: Winnipeg, Manitoba, Canada
Hi Jennifer,

The new database engine is based on SQLite. Behinds the scenes it's completely different and significantly more stable/reliable. From a developer's perspective there are some changes that you might have to make in code. But the general workings are still the same. There isn't anything in RB2005 to import a 5.5 database into the new format. But the old format is still supported (for now) in code. So you could write an application to open the old database, create a new database, and then copy the tables and records from the old to the new.

_________________
REALbasic 2006r3 Pro, Win XP Home SP2
Pentium4-2.6Ghz, 1 GB RAM


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Fri Oct 14, 2005 12:05 pm 
Offline

Joined: Sat Oct 01, 2005 5:19 pm
Posts: 3216
There's code on the Real software's ftp that will update the old databases for you.


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Fri Oct 14, 2005 9:08 pm 
Offline

Joined: Fri Sep 30, 2005 9:30 pm
Posts: 1712
Location: U.S.A.
Intersting. Thanks for the explanation. I played with it a little last night and I like it so far.


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Mon Oct 17, 2005 11:28 am 
Offline

Joined: Fri Sep 30, 2005 9:34 am
Posts: 44
And the new version supports defining your OWN primary key!

THANK GOODNESS!

(Now, if we could get a really good a-la-crystal-reports-type report generator, I'd be walking on sunshine, baby!)


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group