Dynamically creating tables

From: jason (jason_at_messagemotion.dotcom.dutau)
Date: 03/21/05 

Date: 20 Mar 2005 22:27:31 -0800

Hi all,

I dynamically create new tables within my app at start up to
cater for new fields, tables, etc with new releases of my app.

However I have built forms to edit the new tables, but I can't
binde a DataSource to DBcomponents such as a DBEdit box
because the new table isn't defined at design time.

I have a DataModule that contains an TADOConnection that is set
to the database (MS Access).

How can I binde the DataSource's DataSet to the new table name
at runtime?

Hope you can help.
Cheers,

Jason.

Relevant Pages

  • Re: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Portable Database Choice
    ... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Portable Database Choice
    ... database alternatives and did find the options below from this search. ... of data from the desktop to mobile. ... The read-only app requires speedy lookup of data in a flat table ... Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... one app attempts to connect to a sdf file on a network share, ... possible that the database is already in use when you attempt to ...
    (microsoft.public.sqlserver.ce)
  • Re: MSVC++ app type choice, form design questions
    ... > 1) MSVC Project definition requires that for an MFC app I choose ... MFC's built-in database support is really built around the document/ ... with the full version of SQL Server, but it's still pretty usable -- ...
    (microsoft.public.vc.mfc)