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:
01109878
Views:
23
>Hi,
>
>
>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

If the field value is NULL EMPTY() returns .f.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform