Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rob Vleeschhouwer
  Where is Rob Vleeschhouwer?
 Leeuwarden
 Netherlands
 Rob Vleeschhouwer
 To: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 Tags
Subject: RE: add table on the fly
Thread ID: 154403 Message ID: 154764 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 19, 2007 12:41:08 PM         
   


> > Hello All,
> >
> > In a project there must added a new table to the database.
> > From the command window there is no problem.
> >
> > open database mydbc
> > add table mytable
> >
> > But the enduser has no command window. And I cannot send him the databasefiles,
> > because there are also added some new collumns to a table.
> > A Q&D might be to remove that columns here so I can send the databasefiles.
> > But I assume there must be a better way
> >
> > What I have tried:
> >
> > I have removed the table from the database
> > In the main programm:
> >
> > use setup **(is a small Free table)
> >
> > open database mydbc
> > if setup.done=.F.
> > add table mytable
> > replace setup.done with .T.
> > endif
> >
> > When I run the program, I get an error:
> > 'Cannot add this table. It belongs to database mydbc
> >
> > Then I have done:
> > open database mydbc
> > validate database
> >
> > The same error
> >
> >
> >
> > When I remove a table from the database, remains there still
> > some information in the header off the table where it come from?
> > If so, what can I do?
>
> You can do this manually as Koen has suggested but if this is an on-going issue you really should invest in the Stonefield Database Toolkit (www.stonefield.com). It handles precisely these sorts of issues and can be distributed with your application.
>
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Tightline Computers Inc, Akron Ohio, USA

Andy,

It is, I suppose, not an on-going issue. In this case it is an extension of the programm, wich is allready in use by the client, wit one table.
But never the less I will go and see that toolkit. Thank you anyhow.

Regards

Rob

ENTIRE THREAD

add table on the fly Posted by Rob @ 12/15/2007 9:04:56 AM
RE: add table on the fly Posted by Koen Piller @ 12/15/2007 10:57:52 AM
RE: add table on the fly Posted by Eric den Doop @ 12/16/2007 8:55:03 AM
RE: add table on the fly Posted by Koen Piller @ 12/16/2007 9:39:00 AM
RE: add table on the fly Posted by Andy Kramek @ 12/15/2007 12:49:57 PM
RE: add table on the fly Posted by Rob @ 12/19/2007 12:41:08 PM
RE: add table on the fly Posted by Koen Piller @ 12/19/2007 10:14:23 AM
RE: add table on the fly Posted by Rob @ 12/19/2007 12:34:58 PM
RE: add table on the fly Posted by Koen Piller @ 12/19/2007 4:21:03 PM