You aren't beggin for code. However, some of US... myself included... need a little help visually. And the way I look at it, it is a small way of repaying all the people who have helped me in the past.
Regards. > > From: Jamie Lay <[EMAIL PROTECTED]> > Date: 2007/03/27 Tue PM 01:24:31 EDT > To: REALbasic NUG <[email protected]> > Subject: Re: Database Encrypt > > 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> > _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
