Hi Florin
A consideration here is whether you want to be able to de-code the data.
An example is a users table, which contains an encrypted password. You never
want to decode the password, you want to compare the encrypted users
password against the value stored - a one way street, in other words.
To do this you can use sys(2007) to generate a checksum of the values, which
you can store in the table.
If you are going to want to decode the stored data, use something like Dae
suggested, which is secure but easily reversed. There is a reversible
encryption library out there somewhere (Tom Rettig's CIPHER.FLL?) if you
want something a bit meatier.
hth,
stuart
-----Original Message-----
From: Florin Marta [mailto:flmarta@romtelecomtm.ro]
Sent: 14 July 2000 16:34
To: Multiple recipients of ProFox
Subject: (No subject)
I'm looking for a way to encode the caracter fields in a table. Something
light, doesn't have to be rock solid, but enough to don't understand
anything with a browse. Does anybody has write code to do something like
this?
(English is not my 1st language :)
Florin Marta
"No amount of advance planning will ever replace dumb luck."
--Anonymous
Tom Rettig's CIPHER is at http://www.takenote.com/downloads.htm. It's in
the public domain.
Cindy Winegarden
Microsoft Certified Professional, Visual FoxPro
Duke Children's Information Systems
Duke University Medical Center
cindyw@duke.edu
----- Original Message -----
From: "Stuart Dunkeld" <Stuart.Dunkeld@eastsussexcc.gov.uk>
To: "Multiple recipients of ProFox" <profox@leafe.com>
Sent: Friday, July 14, 2000 11:57 AM
Subject: RE: Encryption of data (was no subject)
| Hi Florin
|
| A consideration here is whether you want to be able to de-code the data.
|
| An example is a users table, which contains an encrypted password. You
never
| want to decode the password, you want to compare the encrypted users
| password against the value stored - a one way street, in other words.
| To do this you can use sys(2007) to generate a checksum of the values,
which
| you can store in the table.
|
| If you are going to want to decode the stored data, use something like Dae
| suggested, which is secure but easily reversed. There is a reversible
| encryption library out there somewhere (Tom Rettig's CIPHER.FLL?) if you
| want something a bit meatier.
|
| hth,
|
| stuart
|
|
| -----Original Message-----
| From: Florin Marta [mailto:flmarta@romtelecomtm.ro]
| Sent: 14 July 2000 16:34
| To: Multiple recipients of ProFox
| Subject: (No subject)
|
|
| I'm looking for a way to encode the caracter fields in a table. Something
| light, doesn't have to be rock solid, but enough to don't understand
| anything with a browse. Does anybody has write code to do something like
| this?
| (English is not my 1st language :)
|
| Florin Marta
| "No amount of advance planning will ever replace dumb luck."
| --Anonymous
|
|
| ----------------------------------------
| Subscription maintenance at:
| http://leafe.com/mailListMaint.html
|
|
|
|
Sorry i wasn't more clear.
I wanna be able to de-code the data. I wrote a program that use e-mail to
transmit a table from one point to another. The problem is that the users
who have Visual FoxPro now modify the table directly before sending it. This
should be done only from the program and causes me a lot of problems (at
destination the table is processed automaticly and invalid data may cause
unpleasant error messages).
Thank you all for your help
Florin Marta
----- Original Message -----
From: "Stuart Dunkeld" <Stuart.Dunkeld@eastsussexcc.gov.uk>
To: "Multiple recipients of ProFox" <profox@leafe.com>
Sent: Friday, July 14, 2000 5:57 PM
Subject: RE: Encryption of data (was no subject)
> Hi Florin
>
> A consideration here is whether you want to be able to de-code the data.
>
> An example is a users table, which contains an encrypted password. You
never
> want to decode the password, you want to compare the encrypted users
> password against the value stored - a one way street, in other words.
> To do this you can use sys(2007) to generate a checksum of the values,
which
> you can store in the table.
>
> If you are going to want to decode the stored data, use something like Dae
> suggested, which is secure but easily reversed. There is a reversible
> encryption library out there somewhere (Tom Rettig's CIPHER.FLL?) if you
> want something a bit meatier.
>
> hth,
>
> stuart
>
>
> -----Original Message-----
> From: Florin Marta [mailto:flmarta@romtelecomtm.ro]
> Sent: 14 July 2000 16:34
> To: Multiple recipients of ProFox
> Subject: (No subject)
>
>
> I'm looking for a way to encode the caracter fields in a table. Something
> light, doesn't have to be rock solid, but enough to don't understand
> anything with a browse. Does anybody has write code to do something like
> this?
> (English is not my 1st language :)
>
> Florin Marta
> "No amount of advance planning will ever replace dumb luck."
> --Anonymous
>
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>
Hi
Then I'd suggest adding a field with a CRC using SYS(2007, field) so you
can verify that it hasn't been tampered with underway.
-Anders
----- Original Message -----
From: "Florin Marta" <flmarta@romtelecomtm.ro>
To: "Multiple recipients of ProFox" <profox@leafe.com>
Sent: Friday, July 14, 2000 8:11 PM
Subject: Re: Encryption of data (was no subject)
> Sorry i wasn't more clear.
> I wanna be able to de-code the data. I wrote a program that use e-mail to
> transmit a table from one point to another. The problem is that the users
> who have Visual FoxPro now modify the table directly before sending it.
This
> should be done only from the program and causes me a lot of problems (at
> destination the table is processed automaticly and invalid data may cause
> unpleasant error messages).
> Thank you all for your help
> Florin Marta
>
> ----- Original Message -----
> From: "Stuart Dunkeld" <Stuart.Dunkeld@eastsussexcc.gov.uk>
> To: "Multiple recipients of ProFox" <profox@leafe.com>
> Sent: Friday, July 14, 2000 5:57 PM
> Subject: RE: Encryption of data (was no subject)
>
>
> > Hi Florin
> >
> > A consideration here is whether you want to be able to de-code the data.
> >
> > An example is a users table, which contains an encrypted password. You
> never
> > want to decode the password, you want to compare the encrypted users
> > password against the value stored - a one way street, in other words.
> > To do this you can use sys(2007) to generate a checksum of the values,
> which
> > you can store in the table.
> >
> > If you are going to want to decode the stored data, use something like
Dae
> > suggested, which is secure but easily reversed. There is a reversible
> > encryption library out there somewhere (Tom Rettig's CIPHER.FLL?) if you
> > want something a bit meatier.
> >
> > hth,
> >
> > stuart
> >
> >
> > -----Original Message-----
> > From: Florin Marta [mailto:flmarta@romtelecomtm.ro]
> > Sent: 14 July 2000 16:34
> > To: Multiple recipients of ProFox
> > Subject: (No subject)
> >
> >
> > I'm looking for a way to encode the caracter fields in a table.
Something
> > light, doesn't have to be rock solid, but enough to don't understand
> > anything with a browse. Does anybody has write code to do something like
> > this?
> > (English is not my 1st language :)
> >
> > Florin Marta
> > "No amount of advance planning will ever replace dumb luck."
> > --Anonymous
> >
> >
> > ----------------------------------------
> > Subscription maintenance at:
> > http://leafe.com/mailListMaint.html
> >
> >
>
>
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>