Hi. No I don't have any problems opening my databases. And when I look at them with Notepad (or in my Mac case, TextEdit) all is encrypted. However, if I do try to look at them from within Realbasic with a database added... you know, the little disk icons in the app tab... it won't let me. I have to rebuild them unencrypted...
When I go to encrypt, as I said I use a module. Before you execute your module (I'll send you what I use if you are desperate enough to look at my programming <grin>) you have to add the password / encryption word you want... so it would be something like: ======================== Module1.ConnectDatabase: Sub ConnectDatabase(dbname as string) dim f as FolderItem db = new realsqldatabase f=getfolderitem(dbname) db.databasefile=f db.EncryptionKey = keyholder keyholder = <your password> ConnectDatabase(<databasename>) if db.DatabaseFile.Exists = false then result = db.CreateDatabaseFile <do what you want here...> Hope this helps. Regards > > From: Jamie Lay <[EMAIL PROTECTED]> > Date: 2007/03/27 Tue PM 01:14:35 EDT > To: REALbasic NUG <[email protected]> > Subject: Re: Database Encrypt > > Thanks for the reply, > > I tried calling db.encrypt( "xx") on quit but when I then go back to > open the db, I can't. > > Do you have any trouble opening your db when it is encrypted on quit? > > Thanks, > > Jamie > > Software Factory, LLC > Sales 800-539-1780 > Support 706-632-3763 > Fax 706-632-6498 > www.installfactory.com > > > > > On Mar 27, 2007, at 1:11 PM, <[EMAIL PROTECTED]> wrote: > > 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> > > _______________________________________________ > 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>
