>I have a few questions.
>
>How do you like Fox as your UI/middle as opposed to you using a .Net platform.

No contest. It does everything that is needed, fast and very easy to update.

>
>Do you guys do Sql pass-thru's or CursorAdapters?

Mostly CA's with a few SPT thrown in.

>
>How many sprocs? ( How much backend processing versus middle )

Many. Depends on what is needed. If the data to be manipulated is big, then backend, otherwise frontend. Most business rules built in frontend.

>
>How many round trips are you making to get the data you want in the business tier?

No separate business tier. Data is always connected (bound) to fields using CA's. Digging deeper, BI incorporated into form's DE.

>
>We are a very heavily meta data driven app and thus do a lot of function calls to build all our view queries and other queries at runtime.

All CA's completely datadriven, Forms - datadriven, Reports datadriven. Almost everything is datadriven.

>
>We also allow the user to dynamically add udf's to the database and feel the management of that in SQL will be harder since we replicate to remote users.
>

Not allowed.

>
>
>Thanks for answering.

Also we use Application role so no one can get at the data. Application role is also used in active directory (impersonation) for the VFP app so no one can get at the source.

The system I work on uses VFP9 as front end and SQ:Server as back end, and runs on TS. About 160 users, 130 reports and numerous other ancillary processes.
^
Answers to your questions are above |