How are you going to get the data from the middle-tier to the UI? IMO, ODBC isn't a good way. Look at XML or ADO. COMCodebook is n-tier and uses ADO by default.

>I am developing an n-tier application. For now, I'd like to have my VFP middle tier use ODBC to connect to a VFP datasource. The back-end data will have several stored procedures that my middle tier will need to call.
>
>How do I call a stored procedure in a VFP database via SQL Pass thru. As a work-around, I put a one-row-table, called SP, in the vfp database and use SQLEXEC to send a query to the DB with the stored procedure as a column. Like this:
>
>SQLEXEC(nHandle,'SELECT SP_TEST() AS result FROM SP','SPResult')
>
>Although this works, it seems kind of silly. There must be a better way.