Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL View - visibility across objects
Message
 
 
To
27/12/2006 13:06:45
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:
01180543
Views:
14
This message has been marked as the solution to the initial question of the thread.
>The views are created in the Init event of Object 1.
>
>RowSourceType for all of Object 2's combo boxes is 2 - Alias

Could it be that one of the views was closed? In the Load method of object 2 put something like this
dodefault()
#define CRLF chr(13) + chr(10)
local lnUsed, lnI, lcStr
local array laTables[1]
lnUsed = aused(laTables)
lcStr = ""
for lnI = 1 to lnUsed
   lcStr = m.lcStr + laTables[m.lni,1] + CRLF
next
=messagebox(m.lcStr)
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