Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursorgetprop('Fields')('Tables')
Message
 
 
À
01/04/2002 13:01:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00639264
Message ID:
00639564
Vues:
19
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform