Thanks so very much, At least I now know I'm not the only one. That helps :-) I'll try to resolve the problem myself before begging for code.
Thanks again, 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:22 PM, <[EMAIL PROTECTED]> wrote: 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> _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
