Re: Remote view but too many columns

From: Kathy Weise (kw_at_kathyweise.com)
Date: 03/18/04


Date: Thu, 18 Mar 2004 22:20:34 GMT

Rick,
Thanks a ton!

Kathy

"Rick Bean" <rgbean@unrealmelange-inc.com> wrote in message
news:Ob%23zghSDEHA.1600@tk2msftngp13.phx.gbl...
Kathy,
You'll just need to create the view in code. Create a simple view (with a
table that's got fewer fields<g>), then use GENDBC, to see the code that's
necessary to create a view from scratch. I've found this is easier than
figuring it out from the syntax in the Help file!

Rick

"Kathy Weise" <kw@kathyweise.com> wrote in message
news:pUj6c.27587$%06.2840@newsread2.news.pas.earthlink.net...
> How would I do that? I can't connect to the table to select fields and I
> can't alter the table.
>
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:OxfuQ4PDEHA.3348@TK2MSFTNGP11.phx.gbl...
> > You're limited to 255 fields. You'll have to do a subset of the fields.
> >
> > Fred
> > Microsoft Visual FoxPro MVP
> >
> >
> > "Kathy Weise" <kw@kathyweise.com> wrote in message
> > news:r_i6c.27436$%06.26730@newsread2.news.pas.earthlink.net...
> > > I'm trying to set up a remote view to a table that has 304 fields.
When
> I
> > > try to add the table, it says, "Too many columns".
> > >
> > > Is there a way to do this?
> > >
> > >
> > > Kathy Weise
> > >
> > >
> >
> >
>
>