Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to obtain field type
Message
 
To
10/05/2005 18:03:44
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
OS:
Windows Server 2003
Database:
MS SQL Server
Miscellaneous
Thread ID:
01012618
Message ID:
01013090
Views:
32
>Thanks Brad
>
>if i type in my command windows :
>? vartype('123') VFP return N (Numeric)
>? vartype('abc') VFP return C (character)
>
>that´s ok , but i not associate like in VBA to a expecific number function.
>Is it possible ??
>if i need to type my VBA code in VFP could you give me a few lines of my code but in VFP.That´s important to me because sometimes i need to import FOX files in my SQL SERVER DATABASE.
>
>thanks
>Luis Santos


Borislav gave you a good answer, assuming that you have a native VFP cursor containing the data. If you just have a ADODB.RecordSet object or other kind of object, then you'll have to code accordingly to navigate through the data and look at the column values.

--Brad
Previous
Reply
Map
View

Click here to load this message in the networking platform