HELP! How to get table structure??? 
Author Message
 HELP! How to get table structure???


i am trying to figure out a way to allow the user to look at a table's
structure, and also alter it, the way you can in database desktop.  the
problem is, how do i get that info???  the best i can do is get a field's
name, type, and sometimes its size.  and for the type, i get values like
ftString, ftFloat, ftSmallInt, etc.  i need a way to get, for example, for
a dBase database, if the field is numeric (and then its size and decimal),
character, etc.  i can only get size for certain fields - as the delphi
help indicates,
        Size is meaningful only for a TFieldDef object with one of the
        following FieldType values: ftString, ftBCD, ftBytes, ftVarBytes,
        ftBlob, ftMemo or ftGraphic.

how can i get the basic values for the table structure?  please help!!!
you can reply here to the newgroup or to me via email.

thanks much,

Tue, 17 Mar 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Help with DBF table structure info gathering

2. Help!. Getting Pdox message when accessing dbase tables

3. Help me getting Paradox table rights

4. HELP: Getting an Answer Table out of Local SQL

5. Changing of structure Paradox-tables (Table Language)

6. Creating Empty Table with Structure of existing table

7. Updating table structure from code

8. Printing Paradox Table Structures

9. Modifying database table structure

10. Table Structures

11. Duplicate table structure w/val checks, passwords etc?

12. xBase table structures?


Powered by phpBB® Forum Software