Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursorgetprop('Fields')('Tables')
Message
From
01/04/2002 14:02:36
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00639264
Message ID:
00639594
Views:
19
I'm trying to confirm that t3 WON'T appear in the "TABLES" list. Can I count on that behavior? I'm desigining a class that will DEPEND on that behavior. If I can't DEPEND on that behavior in future versions, then I'll parse throught UpdateNameList looking for the Tables that MAY get updated.


>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")?
Bill Morris
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform