Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EMPTY() working with SQL Server 2005
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01109876
Message ID:
01109944
Views:
29
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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform