Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vartype and type not interchangeable on field in table
Message
 
 
To
01/03/2011 19:53:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01502308
Message ID:
01502318
Views:
37
>Thanks Sergey and James. I had stopped coding in VFP for the past year or so, doing other stuff. My memory isn't what it used to be. I've used afields a zillion times, but I didn't think of it.. lol.
>
>Regarding the type function, I still don't get it - why doesn't it return X then, when there is a null in the field, like vartype does?


The TYPE() function existed before NULLs were introduced in FoxPro.
The VARTYPE() function returns type as well when second parameter is .T.
IMO, it should be default behavior.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform