Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
So, I have a view to a table outside of the database....
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00660583
Message ID:
00660666
Views:
22
What happends if the folder the free table is in is on your VFP path, and you change:

FROM (cVEXPORT_DIRECTORY + 'vmodel')

to

FROM vmodel



>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).
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform