Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Determining table field type
Message
De
02/10/2007 11:13:53
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01257912
Message ID:
01257925
Vues:
16
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform