Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursorgetprop('Fields')('Tables')
Message
 
 
To
01/04/2002 13:01:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00639264
Message ID:
00639564
Views:
20
Bill,

If t3 doesn't have any fields in the view then I don't think it'll appear in table list. It definately won't appear in the updateablefield list. If you want t3 in the table list include a t3 field that is non-updateable in the view result fields.

>Misunderstanding here.
>I have a view: (note no fields are selected from t3, just used for filtering)
>
>Select t1.Field1, t2.Field2 ;
>  from t1, t2, t3 ;
>  where t1.Key1 = t2.Key1 ;
>    and t2.Key2 = t3.Key3 ;
>    and t3.Flag
>
>CURSORGETPROP("UpdateNameList") returns 't1.Field1, t2.Field2' (just what I expected)
>but:
>CURSORGETPROP("Tables") returns 't1,t2' (I expected 't1,t2,t3')
>
>Is this the way it's supposed to be?
>IOW:
>Can I COUNT ON CURSORGETPROP("Tables") only returning a list of tables that are included in CURSORGETPROP("UpdateNameList")?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform