>>>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')
>>>? VARTYPE(bugfield)
>>
>>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.