Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursorgetprop('Fields')('Tables')
Message
De
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:
00639552
Vues:
21
Hi David,

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,
>
>>Is there any way to get a list of fields that may be updated from a view (IOW have a check mark next to them in the "update criteria" tab of the view designer)?
>>
>>CURSORGETPROP("UpdatableFieldList")and CURSORGETPROP("UpdateNameList") don't say whether the field is checked.

>
>UpdatableFieldList is a list of the updateable fields, the ones checked as update.
>
>UpdateNameList is the full list of fields in the view.
>
>
>>CURSORGETPROP("Tables") doesn't always return a complete list of Tables.
>>I think I've determined that it only lists those tables that are included in CURSORGETPROP("UpdateNameList").
>>Is that right?

>
>Yes, it only gives you the tables involved in the view.
>
>If you want all of the tables of a DBC look at DBGetProp()
Bill Morris
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform