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>
