General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Query & View Problems
I'm not sure if this posted so if this is a duplicate, I apologize.
Greetings,
I recently removed all of my tables from my database because of occasional DBC corruption. When I try to create new views or queries of more than 2 tables my results are not correct.
I join table1.mfg_code to table2.mfg_code and table1.eq_code to table3.eq_code. My results from the first 2 tables are correct but when I look at the column from table3 (desc), all the records are showing the same descriptive value.
Also, when I try to save a view or query of 3 or more tables, I get an error saying a field name doesn't exist. When the tables were in the database, I would get this same error on 4 or more tables (views only).
I ended up creating 3 views of 2 tables each to ulitmately get to my desired result. Why is this happening? I never had this problem in VFP 3.0. I am using VFP 6 for this project.
Thanks in advance.
Scott
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only