Re: Create A Table From A FieldList?


> Given a list of field objects, either in a dataset, or getfieldlist,
> etc, is there a straightforward way to create a new table in a database
> based on that list of fields?

As an alternative to Adox you could use SQL DDL commands e.g. CREATE TABLE
or ALTER TABLE. But you would need to construct the SQL from the properties
of the field objects and knowledge of the data types supported by your
database.

Dave


.

Relevant Pages

  • Re: Passing collection objs as parameters
    ... I am not sure what you mean "Field Objects", ... I am not using "containers" but "collection" ... >> The container was filled with values from a database table. ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Create A Table From A FieldList?
    ... Andrew ... > Given a list of field objects, either in a dataset, or getfieldlist, ... is there a straightforward way to create a new table in a database ... Prev by Date: ...
    (borland.public.delphi.database.ado)