Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining table field type
Message
From
02/10/2007 11:13:53
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01257912
Message ID:
01257925
Views:
14
Hi Sergey,

>The 6 item in the AFILEDS array will be .T. for /BINARY.
>The 18 item will be > 0 for AutoInc

Noticed that pattern on 6th column, (field_nocp ??) but did not crossed my mind to actually combine it with 18th column.

You are genius :)
Thks+++


>
>
>
>>
>>Let say we use afields() or Copy Structure Extended to read field
>>structure.
>>Now; For instance Value returned is 'C' but this stands for more then one possible field type. It could be both Character or CharacterBinary
>>The same pattern applies for Integer and Integer(AutoInc), Memo and MemoBinary etc
>>
>>Is there a way to determine exact type (subtype?) of that table field?
>>
>>Any help is greatly appreciated.
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform