7.5.3 SQL Views and Remote Databases

[tagersea]

SQL Views that are enabled within the database administrator are created as tables in new remote databases.  If you do not enable the SQL View it is excluded altogether from the remote database.

At this time we still do not have support for SQL Views.

[RJLedger]

Timmus,

 Is this happening when:

     A - a remote (user/office) exists and one "enables" the view via the DBadmin (and were getting a synch out)?

     B - you apply SP3 (it does a bit of a "hack" - which was identified as a defect during beta) and it creates the SQL views the new web based admin needs?

     C - you cut a new remote user/office db after upgrading to SP3?

All/any/any combo of the above?.. or something I missed?

We have several Windows/LAN upgrades we're doing right now for several clients and I\m concerned.

[tagersea]

I have not tested A.  Will test this soon.

This is not B - interestingly these views were created correctly in the new remote db.

C is the issue that I ran into so far.  

1. Create custom SQL view
2. Db Manager - enable the view - there is no primary key and I dont need one as I am not creating an entity based on the view
3. Create a remote database
4. A table is created instead of a view

Again, it is very bizarre that the stock SQL views are created no problem.  Hopefully Sage did not hard code exceptions...

I am going to test a view with a primary key to see if that is the crux of the problem.  I will also test creating/enabling a view and seeing if it syncs to existing remotes.

[tagersea]

I have retested the remote database creation and it correctly created the SQL Views.  I suspect I was running the 7.5.2 version of the administrator against a 7.5.3 database by accident.  My mistake - please disregard...