>1. Can one execute stored procedures via a trigger in FoxPro over ODBC?
I haven't done this in a while as i opt to stay away from the whole limited ODBC mess, but you
can access a stored procedure by executing a SQL statement that contains a UDF() that's
part of the dictionary.
>2. Can one return values from an OLE server that are not written to a form, grid, etc?
Like what? You can return any simple types and objects...
>3. Is it possible to create a public class that is based on a cursor .. ie returned from
> SELECT * FROM x INTO CURSOR y
Not really. FoxData is not something you can pass via an object. You can however pass an
object that wraps the data. For example, you can do SCATTER loObject MEMO to create an
object of the current record and pass that back to ASP.
>4. Should I just use the evil Oracle or SQL Server and forget this exercise?
The issues are much the same. There are some problems that require workarounds
with the VFP ODBC driver, but overall it works and you get the flexibility of
using Fox Expressions in your ADO queries.
ADO and VFP isn't my first choice though...