Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to protect pic. in blob fields
Message
From
05/10/2011 05:30:26
 
 
To
05/10/2011 05:26:19
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01525343
Message ID:
01525634
Views:
36
>>>>
>>>>FUNCTION XORDATA(data,Key)
>>>>	RETURN BITXOR(m.Data,REPLICATE(m.Key,CEILING(LEN(m.Data)/LEN(m.Key))))
>>>>ENDFUNC
>>>>
>>>
>>>This won't work. BitXor() works with integers only, not strings.
>>>
>>>Which is a shame - it should.
>>
>>
>>It does work on Blob fields - you may need a cast
>>
>>
>>return bitxor( cast(m.data as blob), cast(otherdata as blob))
>>
>
>Didn't know that - and I need to :).
>
>Tried to see what happens if I cast it as varbinary - and it worked the same when I cast only the first parameter. When I cast both, it worked... sort of - the length of the result was 1.

I did a simple test before answering
xx=repl('a', 20)
yy=repl('b', 20)
zz= bitxor(cast(xx as blob), cast(yy as blob))
?zz
?len(zz) && 20
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform