Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote view redefine field to support NULL
Message
De
19/05/2003 14:24:38
 
 
À
19/05/2003 13:55:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00789213
Message ID:
00790083
Vues:
23
Thanks Aleksey for workaround.

I uses CONVERT(,) function, but NULLIF() is datatype invariant.

I check various function, and :

SELECT f1+0 f1 FROM AR
is local nullable

but:

SELECT ISNULL(f1,NULL) f1 FROM AR

is not nullable on local cursor.

SQL optimizator resolve null invariance of not nullable field.
Remarkable!

I hope on VFP get this capability on next release.

Example:
CURSORSETPROP('Nullable','fieldName'[, cTableAlias | nWorkArea ])

CURSORSETPROP('NotNullable','fieldName'[, cTableAlias | nWorkArea ])

Fabio
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform