>Is there a way to generate SHA1 in VFP?
>
>Right now I'm using MySQL to generate SHA1
>
>

>STORE calcSqlConnect() TO dlnConnHandle
>TEXT TO dlcSQL TEXTMERGE noshow
>select sha1('abcde')
>ENDTEXT 
>STORE SQLEXEC(dlnConnHandle, dlcSql, 'dummy') TO dlnSql
>

>
>But then I don't know how to take out the return value
>
>Thanks for the help
>
>Jerry

Without changeing much you could replace the line

select sha1('abcde')

with

select sha1('abcde') AS sha1

And after running the SQLEXEC() you could access it like a field of the "dummy" cursor, for example:

? dummy.sha1

Hope it helps.