Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
So, I have a view to a table outside of the database....
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00660583
Message ID:
00660661
Vues:
16
First of all, thanks for the help :)

The table is named vmodel, the view is named v_vmodel

The basic setup of the free table is a field "pk", the primary key marked as candidate, and several other fields.

The setup of the view is:
CREATE SQL VIEW v_vmodel AS ;
	SELECT * ;
	FROM (cVEXPORT_DIRECTORY + 'vmodel') ;
	WHERE PK = ?m.PK
Where cVEXPORT_DIRECTORY is a constant string to the table.

The properties worth noting:

"v_vmodel.pk" is the only key field.
All fields are updateable from the view.
"sendupdates" = .T.
"tables" = "vmodel" (I've also tried "(table path)\vmodel.dbf")
"updatetype" = 1
"wheretype" = 1

The view opens up fine, requeries, etc. The only thing it does wrong is not allow me to update the table, stating that the "tables" property isn't set (although it is).
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform