Hi All,

I thought I'd try a simple Active Server page for my FoxPro back end. I've got a burgeoning application that shares data between 4 departments, EACH with their own business rules for that same data. An Intranet sounded perfect.

I have a data-mart that's essentially a crosstab query. I've built a multi-tiered, parameterized view that replaces the procedures that build the table that is cross-tabbed. I made all this a stored procedure in my DBC. Oh, it works great!

Now, I come to ODBC, which won't allow the passing of parameters. ADO seem to use ODBC, so I can't get around the limitations. I even tried using an Insert - SQL statement that puts my parameters into a logging table, but the ODBC driver errors out. Yes, I'm using 5.0!

So my questions are ...

1. Can one execute stored procedures via a trigger in FoxPro over ODBC?
2. Can one return values from an OLE server that are not written to a form, grid, etc?
3. Is it possible to create a public class that is based on a cursor .. ie returned from
SELECT * FROM x INTO CURSOR y
4. Should I just use the evil Oracle or SQL Server and forget this exercise?

Thanks in advance for any (non-flaming) input!

Sincerely,

Rod Wagoner
Tucson Electric Power