General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
The view designer doesn't work well with more than 2 tables in a view. This is a limit of the view designer. VFP SQL can have many many tables. For a report you might want to consider just using a cursor generated from your tables. The power of a view is that updated data can be sent back to the base tables. In a report this feature isn't useful.
>My question on the subject is because I need to create a View that will be the base for a Report. This View must have fields from seven different tables, these tables being connected by relations.
>
>When I finish my desing work, in the View Assistant (I work in a spanish version, so maybe it has a different name in the english version), when I try to leave it, it says it can't find a certain field that is already in one of the tables of the DataEnvironment of the View! sO, When, later, I try to reopen to modify it, it appears with only the tables inside, no relations, no fields selected!
>
>I took the SQL generated command and tried it in a PRG... and it didn't work!!!
>
>Has VFP SQL a limit in number of tables or something??
>
>TIA!!
Previous
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