|
Home > Archive > FoxPro Help and Support > January 2006 > recreating view
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| ExtraT 2006-01-12, 8:25 pm |
| Hi,
When a table structure on wich a local view is based is changed then
it will issue a error msg. telling you
"base table fields have been changed and no longer match view fields.
view field properties cannot be set"
Is there an easy way to recreate the view, actually I want to know how
I can get at the information how this view has been set up so I can
recreate it.
Any help greatly appreciated!
| |
| Dan Freeman 2006-01-12, 8:25 pm |
| The easy way to find out how it was set up is to run GENDBC (you'll find it
in the tools folder).
You can CREATE SQL VIEW AS SELECT ....
but there's a boatload of other stuff that needs to be set, and gendbc will
show you that.
Dan
ExtraT wrote:
> Hi,
>
> When a table structure on wich a local view is based is changed then
> it will issue a error msg. telling you
> "base table fields have been changed and no longer match view fields.
> view field properties cannot be set"
> Is there an easy way to recreate the view, actually I want to know how
> I can get at the information how this view has been set up so I can
> recreate it.
> Any help greatly appreciated!
| |
| Cindy Winegarden 2006-01-12, 8:25 pm |
| Just to add to what Dan said, you need to run GenDBC before you run into
trouble since you may not be able to after the view is broken. It's a great
idea to run GenDBC after each database change, and put the generated program
under source control.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"ExtraT" <nospam@nospam.net> wrote in message
news:pugds1dv7h4pmio
fg8c2e8e92kgfip2j73@
4ax.com...
> Hi,
>
> When a table structure on wich a local view is based is changed then
> it will issue a error msg. telling you
> "base table fields have been changed and no longer match view fields.
> view field properties cannot be set"
> Is there an easy way to recreate the view, actually I want to know how
> I can get at the information how this view has been set up so I can
> recreate it.
> Any help greatly appreciated!
| |
| Craig Berntson 2006-01-13, 11:24 am |
| Sounds like you may have done a SELECT * when creating the view. See
http://rickschummer.com/blog/2005/1...-not-break.html
--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net
"ExtraT" <nospam@nospam.net> wrote in message
news:pugds1dv7h4pmio
fg8c2e8e92kgfip2j73@
4ax.com...
> Hi,
>
> When a table structure on wich a local view is based is changed then
> it will issue a error msg. telling you
> "base table fields have been changed and no longer match view fields.
> view field properties cannot be set"
> Is there an easy way to recreate the view, actually I want to know how
> I can get at the information how this view has been set up so I can
> recreate it.
> Any help greatly appreciated!
|
|
|
|
|