( catching up on old messages )
I'm confused - is EMPTY() a legitimate function in a remote view or is this not what he's doing ? I can't find EMPTY() in any SQL Server documentation and I am testing for empty character strings with field = '' where local views used EMTPY(field) - is there a better way ?
>How do you know that lcValue is an empty string? Maybe it only looks like an empty string but has some non-printable character in it.
>
>>
>>After installing SQL Server 2005, my VFP projects started to give some errors, on my lines with EMPTY() function.
>>
>>It seems that EMPTY() doesn't return .t. if the variable is "".
>>
>>Example:
>>
>>IF EMPTY(lcValue)
>> * It's entering here if lcValue = .f. but not if lcValue = ""
>>ENDIF
>>
>>
>>Any idea? Could it be any property of remote views or cursors...?
>>
>>
>>Best regards,
>>
>>
>>Ricardo Almeida
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.