Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG TYPE('blobfield') AND VARTYPE(blobfield)
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01060805
Message ID:
01060818
Views:
8
Very fast :-) I just want to update my post with IN ADDITION:


>>>Why TYPE() and VARTYPE() returns different results for field type BLOB
>>>
>>>
CLEAR
>>>CREATE TABLE Test (bugfield W)
>>>INSERT INTO Test VALUES (FILETOSTR(HOME()+'beautify.app'))
>>>? TYPE('bugfield')   &&& return W
>>>? VARTYPE(bugfield)  &&& return Q
>>
>>Also there is an omission in HELP. There is no "W" type in HELP for VARTPE() and TYPE() functions. Only in AFIELDS() you can get it.
>
>Yes, I know this.
>But the question is:
>WHY TYPE and VARTYPE returns different results ???
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform