Re: create a new table (ADO)

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 01/26/05


Date: Tue, 25 Jan 2005 20:34:15 -0600


>I know about CREATE TABLE and ADOX.Catalog but I want to know how to create
>a new table in another way. All what I want is to create some resultset
>(Fields.Append) and specify the table name+save/commit - or this is
>impossible in ADO?

It sounds to me like you just need to do a Select Into query

Select * from Table1 Into NewTableName

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com


Relevant Pages

  • Re: How to get the previous value of a field
    ... Ado doesn't keep that information after Post unless you setLockType to ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: ado and delphi8
    ... >where can i find a sample showing how to use delphi 8 and ado ... Brian Bushay (TeamB) ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Updating GUID-field for ADO.NET in Delphi 2005
    ... Is the GUID-type field supported on ADO? ... Type AdGuid ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Query 200 Records?
    ... >Delphi 7, ADO, MS-SQL Database. ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: ADO connection
    ... That is not something you can detect with ADO or SQL server ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)