decrypt table problem

[Mike Wilson]

I searched and didn't see an answer. As a final addition to app before releasing, I want to encrypt one table on app close and decrypt on app open. I tested in Interactive window and get the error attached.

STEP 1:
dim t as P
t = table.open("client_info")
t.encrypt("ABCDEF")
t.close()

>>>> looked to see table in Control panel and indeed has key symbol and encrypted.

STEP 2:
t = table.open("client_info")
t.decrypt("ABCDEF")
t.close()

>>> error (see attached)

What do I do now???

[Stan Mathews]

Re: decrypt table problem

default_encryption_key_set("ABCDEF")
t = table.open("client_info")
t.decrypt()
t.close()

or

t = table.open("client_info",FILE_RW_EXCLUSIVE,"client_info","ABCDEF")
t.decrypt()
t.close()

[Mike Wilson]

Re: decrypt table problem

Thanks Stan, but neither work. Can you get it to work on your side. I tried in v11 and didn't work there either.

[Stan Mathews]

Re: decrypt table problem

Just quoting the documentation. Will try tomorrow.

[DaveM]

Re: decrypt table problem

default_encryption_key_set("ABCDEFi")
place the encryption key in another script in your app and run it. Mine is always in the autoexec.

then in the new script or wherever
dim t as p
t = table.open("client_info") or (whatever the database name is)
t.decrypt()
t.close()


That will work if the correct key is used.

I do this constantly for apps

[Stan Mathews]

Re: decrypt table problem

Is there an echo in here?

[Tom Cone Jr]

Re: decrypt table problem

If one does not set the default encryption key, but uses the tbl methods, you get the same error Mike W is reporting. The docs do not specify that one must use or set a default encryption key. Or, am I missing something?

[DaveM]

Re: decrypt table problem

just figured something was missing . I know my set default is a different place nd never have run it in the same script.

Stan and Tom taught me. LOL'

I am sleepy too.

[Mike Wilson]

Re: decrypt table problem

OK, another day and another result. I swear I tried everything, alone and with a partner using TeamViewer looking over my shoulder ... every combination possible. We spent a bunch of time and dozens of tests and couldn't get it to work. But that was yesterday. Today...

I place this on the code just before :a5.close() in the script that is called to exit the app:

default_encryption_key_set("keyword")
dim t as p
t = table.open("client_info") 
t.encrypt()
t.close()

and this in the very start of the autoexec:

default_encryption_key_set("keyword")
dim t as p
t = table.open("client_info") 
t.decrypt()
t.close()

I'm sure that it is that today the moon and mars is aligned just everso.... Thanks guys!

[DaveM]

Re: decrypt table problem

Mike, You don't have to decrypt for alpha to use the table.

Alpha knows to let users have access and will, so no need for anything in autoexec except the default line.

This part is not needed in autoexec:

dim t as p
t = table.open("client_info")
t.decrypt()
t.close()

You only need to run this one time ever, I run it in a script and then forget it unless I need to decrypt:

dim t as p
t = table.open("client_info") 
t.encrypt()
t.close()

[Peter.Greulich]

Re: decrypt table problem

Dave is right. Once you encrypt you don't need to decrypt. You do need to pass in the key - usually in the autoexec. The only reason to decrypt is if you wanted to use the table in another db.