General information
Title:
OLEDB Stored Procedures and ASP
I am trying to write ASP code to access VFP tables. My thoughts are the most efficient method would be to use OLE DB and run queries via stored procedures inside the VFP 8 database. Thus far I have not been able to figure out (or maybe it is not possible) how to pass results of a query from the stored procedure back to the ASP engine. I can successfully call the stored procedures (for example returning a string works), so I know I have the communication path working. I also was able to send a query from ASP and get the result set, but I don't think sending all of the SQL I will be writing back and forth from ASP is the best means. So my questions are:
Are my thoughts in the 2nd sentence above correct and possible? If not, what is the most efficient means of data i/o to a VFP database? If so, does anyone have a working example?
I can post code examples if needed. Right now I get 'True' returned instead of the record set.
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