General information
Category:
Internet applications
Title:
ASP, ODBC, ADO, HTML ... BFD!
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only