Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
EMPTY() working with SQL Server 2005
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01109876
Message ID:
01109878
Vues:
21
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform