Re: Alter table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Anders Altberg (x_pragma_at_telia.com)
Date: 04/28/04


Date: Wed, 28 Apr 2004 12:42:14 +0200

Clean up the database using the Database Designer menu or the PACK DATABASE
command.
Rebuild your project in the Build tab.
Did you enter any column names by hand - check the spelling.
-Anders

"Jane" <anonymous@discussions.microsoft.com> wrote in message
news:9082A815-7C2F-48CF-9FA4-56E2731E28DC@microsoft.com...
> Hello,
> I am a new FoxPro programmer. I just modified a table, I added a field to
it. and used that field in a view. I checked the view, it gave me the right
answer, but when I run the application, opened the form that used the view,
it gave me error message: "SQL: column 'colName' is not found". When I
opened another form I got: "Base table fields have been changed and no
longer match view fields, view fields properties cannot be set".
> I have tried to delete all of the views from one of the form, removed the
views from the designer, create the veiws, add them to the form again. It
still didn't work. Now I really don't know what to do. Any ideas?
> Thanks in advance!
> Cheers
> Jane



Relevant Pages

  • Re: ADP Applications
    ... That's right, hon. Paying the rent, putting food on the table, and having ... You and I both know that there are only three reasons for reducing a database ... The database designer wasn't yet competent in relational database design ... which the previous database system employed. ...
    (comp.databases.ms-access)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: data base testing
    ... questiosn like "why I am being asked to test back end", ... DBA or Database designer group ... I have found that "Reviewing Database design - ... called "testing team" to perform them with unknown objectives. ...
    (comp.software.testing)
  • Re: Bank Of Scotland Botched Disguised Mail
    ... >> Edinburgh's habit of giving different parts of longer streets subsiduary ... > database designer. ...
    (soc.culture.scottish)
  • Re: MANY-to-MANY-to-MANY ....
    ... For this, you will need "associative objects", otherwise known as "link ... In the Northwind database, the Order Details ... I'm not experienced database designer and i've a academic project ...
    (microsoft.public.sqlserver.programming)