Re: Runtime adding files to database via a TADOConnection - how?

Just execute the CREATE TABLE statement to create the new table in your ADO
connection

--
With best regards, Mike Shkolnik
E-mail: mshkolnik@xxxxxxxxxxxxx
WEB: http://www.scalabium.com

"Pontus Berg" <pontus@xxxxxxxxxxxxxxxxx> wrote in message
news:447995c0@xxxxxxxxxxxxxxxxxxxxxxxxx
Howdy!

If I have connected to an Access database on disk, via a TADOConnection
component, then how do I add fields at runtime? I find no method that
would enable me to do it. Adding via SQL - is that it? (This is no SQL
group, but any hints?)

Also, if a TADODataset contains the field I want to add, but the base on
disk doesn't, how do best I read the characteristics (type and so on) of
the field from the Dataset and add it to the base on disk? Again, this
must all be at runtime!

Identifying the fields missing on disk and finding the name of it from
the Dataset is under control. What I now need help with is "only"
identifying the datatype of the field and how to add it to the database
on disk.

/Pontus

Setup: Delphi 2006, Windows


.

Relevant Pages

  • RE: DVD multi drive malfunctioning.
    ... Dila up is only used for internet connection. ... Run Dr. Watson if you can and let ... >> at the disk drive they all report there is no disk or that it can not be ... Through drive properties made sure autoplay was set to launch my DVD ...
    (microsoft.public.windowsxp.general)
  • Re: Sudden freezes, and bits missing
    ... windows no disk in drive warning when I try to do some things with it. ... I tried an experiment and unplugged the LAN ... > connection (most dial-up users don't actually use a LAN to connect to the ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Odd disk-read problem
    ... unformated disk ... Artistic CNC Mill, Router and Engraver Programming ... With the Ethernet connection in place two rs232 ports ... wireless cards. ...
    (alt.machines.cnc)
  • T42 mit 40GB und g4u Sicherung
    ... der vorinstallierten 1.Prim und der 2.Prim.Part. ... (Recovery-Partition) ... 125 Data connection already open; ... und gzip -9) der gesamten "unberuehrten" 40 GB Disk ...
    (de.comp.sys.notebooks)
  • Re: XP does not recognise my second hard disk
    ... Not that the LS-120 is not a good idea, but that it uses the IDE connection. ... Perhaps a special Floppy Disk Drive controller to handle the LS-120 as a floppy ... On XP, however, my master HD is Drive 0, bit it is the LS120 which is identified as Drive 1, with no mention of my 40GB slave disk. ... installing XP?Thanks for any help or advice you can give me. ...
    (microsoft.public.windowsxp.newusers)