Tables are not Equivalent???? 
Author Message
 Tables are not Equivalent????

I have a simple form with a 1-1 and a 1-M relationship between
3 tables.

    - Classes -->> Clist
   |
    -> Test

Classes and Clist are in a different directory with aliases
assigned :SHOW:Classes.db   :SHOW:Clist.db, while Test is in
the working directory :WORK:Test.db

When I built the form, everything worked fine.  Then I realized
that I wanted to put a filter on Clist to exclude those records
which were "Withdrawn".  In design mode, I went to the data model
and modified Clist to specify a filter on the "Withdrawn" field.

Form ran fine.  Results clearly showed the effects of filtering.

Saved form.  Tried to run from Project Viewer.  Got notice
"Tables are not equivalent", form came up in design mode.

Ran tutility on the tables -- it reports everything fine.

I have seen discussion of this before, but can't seem to find
old references to this behavior.  Any help? Pdoxwin5.0.

I have another form with a similar relationship between
Classes and Clist, and a similar filter on Clist.  It comes up
fine.

--

Coupled Climate Dynamics Group/971            
NASA Goddard Space Flight Center              
Greenbelt, MD 20771



Fri, 24 Jul 1998 03:00:00 GMT
 Tables are not Equivalent????

: I have a simple form with a 1-1 and a 1-M relationship between
: 3 tables.

:     - Classes -->> Clist
:    |
:     -> Test

: Classes and Clist are in a different directory with aliases
: assigned :SHOW:Classes.db   :SHOW:Clist.db, while Test is in
: the working directory :WORK:Test.db

: When I built the form, everything worked fine.  Then I realized
: that I wanted to put a filter on Clist to exclude those records
: which were "Withdrawn".  In design mode, I went to the data model
: and modified Clist to specify a filter on the "Withdrawn" field.

: Form ran fine.  Results clearly showed the effects of filtering.

: Saved form.  Tried to run from Project Viewer.  Got notice
: "Tables are not equivalent", form came up in design mode.

: Ran tutility on the tables -- it reports everything fine.

: I have seen discussion of this before, but can't seem to find
: old references to this behavior.  Any help? Pdoxwin5.0.

Tables are not equivalent means that the LINK you placed on the table is
no longer valid. Suggest you go into the data model and relink the
tables, THEN save the form and see if that helps.

--
=========================================================================
Kasey K. S. Chang (a guy)             | Paradox for Windows Programmer

URL> http://userwww.sfsu.edu/~kschang | X-COM Guru   General PC expert
--------------------------------------+----------------------------------
Editor of XCOM and XCOM2 UN-official Strategy Guide -- FREE!  (See URL)



Sat, 01 Aug 1998 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Tables are not Equivalent

2. Tables are not equivalent

3. Paradox 5 - "Tables are not equivalent"

4. Tables not equivalent (ver5)

5. Tables not equivalent messg.

6. Paradox 5 for win and Tables are not equivalent error msg

7. Tables not equivalent - Error Msg

8. Tables are not equivalent error

9. Tables are not equivalent

10. filter with graphs(table not equivalent)

11. filter with graphs(table not equivalent)

12. Error MSG "Tables not Equivalent"


 
Powered by phpBB® Forum Software