Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Command to programmatically read a structure of a table?
Message
From
20/08/2001 09:36:00
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00546169
Message ID:
00546174
Views:
21
This message has been marked as the solution to the initial question of the thread.
>I want to programmatically look at the structure of a table, similar to when you type MODI STRUCT in the command window and can see the structure, but I want to grab some info from the structure such as field length and field type (character, date, whatever) and stick it in my data dictionary without having to manually look it up and do it?
>
>I saw ALTER LTABLE - SQL command, but I don't think that will help me do this.
>
>Thanks for the help.

Steve,
There are bunch of them. afields() and copy structure extended to name 2.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform