>>By default, the views do not share the same connection (although they are defined using the same connection!). I had to make sure that all views were marked to share the same connection....
>
>HUH? what do you mean 'marked'? Is there a way to force views to use the same connection? I'm stumped.
In the advanced options of the view designer (Menu option Query - Advanced Options) there is a check box for Share Connection. Be sure that this is checked because the default is not to share connections. Or you can manipulate this option in code with DBSetProp
DBSetProp('RV_INCOME', 'View', 'ShareConnection', .T.)
It is handy to run GENDBC to have a prg that will recreate your remote views. Sometimes I find that the view designer just doesn't create the right SQL statement so I cut the view's code from the gendbc program, save it as its own program and then edit the SQL statement. By running this program I also set all of the properties as well.
If you issue something like
CREATE SQL VIEW "RV_Test" ;
REMOTE CONNECT "testconnection" ;
AS SELECT ....
from the command line, then SHARE Connection is set to .F. by default.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement