That's right Thomas :) I know how to use SYS(2007). I am thinking of trying to implement the function in another langauge if its not too much work.


>Hmm,
>
>I thought Jos was after the code used to implement the vfp version OF sys(2007) to use perhaps in a another tier...
>
>Jooooos ?
>
>
>
>>ENTER IN THE COMMAND WINDOW
>>HELP SYS(2007)
>>
>>I use it to compare 2 values to see if they no longer match. Such as when updating a remote MySQL database. No need to send the update over the wire if no changes where made. Note that I am leaving out the flags, etc here to simplify but you should get the idea.
>>
>>

nOrgCkVal =  SYS(2007,CustName)
>>...user edits data here...
>>before save
>>if nOrgCkVal <> SYS(2007,CustName)
>>  update the server cause the data has changed
>>endif
>>