Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL View - visibility across objects
Message
 
 
To
27/12/2006 12:29:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01180523
Message ID:
01180528
Views:
9
Howard,

Do both form objects share the same data session? If yes, then they should see the view.

>I am creating a SQL view in an object (Object 1) - the main part of my program.
>
>I want to open another form by doing a CREATEOBJECT of the class that is the form (Object 2). There are grids in Object 2's form, and there are RowSource references to the views created in Object 1.
>
>Should that second object (Object 2) be able to see and use the SQL Views created by Object 1?
>I am getting an error - "field" phrase is not found (Error 1130) - when I do the CREATEOBJECT, and I am guessing that it is due to the RowSource view references.
>
>This all works fine if I use DO FORM on the form version of this class rather than CREATEOBJECT on the class.
>
>Not sure that this matters, but the program is an .exe COM server.
>
>Thanks,
>Howard
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform