>What types of things do you use SPT for and what type do you use views for? >Are business objects still involved? If so, how?

Brian,

I am using the framework with SQL Server and have been very pleased with the results. I will soon be doing an Oracle version of our system, so I am also looking forward to the next version of the framework and the wonderfull enhancements Kevin is working on.

What I doing today is a mix and match of remote views and SPT. Basically, all of my business objects have one or more associated views. When switching to SQL, I created the coresponding remote views. This has worked well and these views are typically only working on a single or very few records at a time. This has also meant I did not have to change a lot of code, I let the framework handle the switch from local to remote.

Where I utilize SPT is when I am dealing with larger record sets and queries that get built on the fly. One area of my application allows the user to select fields from several tables, set filters (using Stonefield Query) and specify multiple level sorts. I then build a SQL statement and remotely execute to return a cursor that they can use for navigation of a subset of records. I also use SPT when building report cursors.

Kind Regards,

Mat