Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view redefine field to support NULL
Message
From
19/05/2003 14:24:38
 
 
To
19/05/2003 13:55:56
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00789213
Message ID:
00790083
Views:
30
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
Previous
Reply
Map
View

Click here to load this message in the networking platform