>>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.