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:
01060822
Views:
12
>>>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.
>
>But i read in help this:
>VARTYPE( ) is similar to the TYPE( ) function, but VARTYPE( ) is faster and does not require quotation marks ("") to enclose the specified expression.

I not argue with you. THIS IS A BUG for me. I just want to put some additions to your post.
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