Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Has anyone used any bulk (file, directory, disk) encryption methods successfully? Date: Mon, 5 Sep 2016 05:07:16 +0200 Lines: 73 Message-ID: References: <69f01469-469a-4799-b440-265867c5fdbb@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 X-Trace: individual.net zVLNr1506SkAhL7N7i3pmwaqjx75GJfCgWGBdFaEW3clLGKs8= Cancel-Lock: sha1:pdezrJmte86H0/wqr+MgF0ztlGY= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:9712 Hi Steve, this is easily doable with several possibilities: you can encrypt single fields and crypt/decrypt on FieldGet/FieldPut level of your DBServer (the following code is from a now 10 years old project): method FieldGet( uField ) class AppCDBServer local uValue as usual local nLen as dword local cValue as string local cBuffer as string uValue := super:FieldGet( uField ) if IsString( uValue ) if self:IsFieldToCrypt( uField ) .and. ! AllTrim( uValue ) == "" cValue := uValue if SLen( cValue ) > 2 nLen := Bin2W( Left( cValue, 2 ) ) if nLen == 0 uValue := Space( nLen ) else cBuffer := SubStr2( cValue, 3 ) cValue := JPMCrypt( cBuffer ) uValue := Left( cValue, nLen ) endif endif endif endif return uValue method FieldPut( uField, uValue ) class AppCDBServer if IsString( uValue ) .and. self:IsFieldToCrypt( uField ) uValue := AllTrim( uValue ) uValue := W2Bin( word( SLen( uValue ) ) ) + AllTrim( JPMCrypt( uValue ) ) endif return super:FieldPut( uField, uValue ) Or you can use a crypting RDD (there was a sample by someone, Robert v.d.H. I think). But beware: my method seems to have issues with the Vulcan RDDs. Wolfgang SteveMcNaughton wrote: > I'm looking for a way to encrypt the data files so that the data is > not readable by simple things like Notepad, but is readable by my VO > programming. I've mulled over using field based encryption, but then > indexing them would be an issue. > > I goofed around with a windows method, but then other network users > could not read the files. > > It's like there has to be an encryption key that is able to be shared > with others. > Anybody been to this mountain already? > > thanks. > > Steve. --