Hi there. I had the same problem.
If you use the online help with realbasic, you will see something like db.Encryptionkey = <whatever> and when I quit I do db.encrypt <whatever> this is what I use, and it seems to work for me... I have it as a Module subroutine, that I call whenever I have to deal with a database... dim f as FolderItem dim db as realsqldatabase db = new realsqldatabase f=getfolderitem(dbname) db.databasefile=f db.EncryptionKey = "your_password" Hope this helps a little... Regards > > From: Jamie Lay <[EMAIL PROTECTED]> > Date: 2007/03/26 Mon PM 09:35:50 EDT > To: REALbasic NUG <[email protected]> > Subject: Database Encrypt > > Hello All, > > I'm working with 2007r1 on an Intel Mac running Parallels. (Love it!!) > When trying to create an encrypted database, I'm still able to view > the plain text using WordPad / NotePad. > > My code is: > > OpenDB: > db.password = "jamie" > db.databasefile = GetFolderItem( "mydb.rsd") > > if not db.connect then > return false > end > > return true > > > NewDB: > db.password = "jamie" > db.databasefile = GetFolderItem( "mydb.rsd") > > if not db.CreateDatabaseFile then > // Handle error > return > end if > > > Add some tables, etc. > > > > > I'm sure this is really simple but I'm not finding any happy. > Checking the archives and Language Reference didn't help > much either. > > Any suggestions would be appreciated. > > Thanks, > > Jamie > > Software Factory, LLC > Sales 800-539-1780 > Support 706-632-3763 > Fax 706-632-6498 > www.installfactory.com > > > > > _______________________________________________ > Unsubscribe or switch delivery mode: > <http://www.realsoftware.com/support/listmanager/> > > Search the archives: > <http://support.realsoftware.com/listarchives/lists.html> > _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
