Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Koen Piller
  Where is Koen Piller?
 Santpoort-Zuid
 Netherlands
 Koen Piller
 To: Rob Vleeschhouwer
  Where is Rob Vleeschhouwer?
 Leeuwarden
 Netherlands
 Rob Vleeschhouwer
 Tags
Subject: RE: add table on the fly
Thread ID: 154403 Message ID: 154789 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 19, 2007 4:21:03 PM         
   


> > Rob,
> >
> > Does it work?
> >
> > Regards,
> >
> > Koen
>
>
> Hi Koen
>
> Almost ready with rebuild and reinstall the PC. I will try it on the end of this day,
> unless I'm going to skate :)
> Never the less, I think I will try a variant, cause the table has 165 fields.
>
> Add fields to an existing table was not the problem.
>
> So:
>
> I make a copy structure extend from the table (mytable_struc)
>
> ******** code
> open database mydbc
>
> If not inDBC(mytable)
> create mytable from mytable_struc
> index on .........
> endif
>
> As far I can see(think) it is the same, but easyer because there is no need
> to define 165 fields.
> Do you agree?
>
> Regards,
>
> Rob
Rob,

if this approach does not return you with your initial error:
> > 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 you are done.
Happy skating, it will keep on freezing. :(

Regards,
Koen

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