General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi All,
I am trying to figure out how to use the stored procedure. I want to create a SP on the database. And with an SQLEXEC call it and have it return the result set of the query in the SP. I just want to start simple. Just to prove to the Dept Head that they are faster and easy to maintain. Versus keeping all the querys client side. We intend to move to an Oracle database in the new year. ( Finally ) And I'd like to do it right the 1st time.
The test: I want to have the query in the SP. Call it passing 1 numeric parameter. And have a cursor returned with my data.
VFP6 SP5 The database is a standard VFP .dbc
TIA
Mike
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