pcsoft.us.windevCopyright 2026, PC SOFT10 Nov 2020 12:17:30 Z9 Jan 2014 23:17:00 ZJust bought the WD18 MS SQL native access driver but I cant find a way to return the table of results, the stored procedure returns. I'm not trying to return a single parameter value, but rather pass a number of parameters to the SP, and then get a table of results back. How do I do this? Is there a way I can also get the SP table into the analysis so that I can use it elsewhere in other parts of the program I'm writing? Any pointers? TIA30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)infopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-68097/read.awp10 Nov 2020 12:17:30 ZKevin this works for me: [code:wl] MyProc is Data Source sProc is string // Run the query and retrieve the result sPro…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-68097/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-68097/read.awpHow to return table from a MS SQL Stored procedure with native access driver?Kevinpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-68095/read.awp10 Nov 2020 11:02:15 ZAny updates on this issue ?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-68095/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-68095/read.awpHow to return table from a MS SQL Stored procedure with native access driver?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-44026/read.awp15 Jan 2014 13:12:00 ZHi It's said "You cannot retrieve a stored procedure that returns records (SELECT ... FROM ...), columns." in windev help of …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-44026/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-44026/read.awpHow to return table from a MS SQL Stored procedure with native access driver?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-43939/read.awp10 Jan 2014 16:57:00 ZThanks, just checking it out now.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-43939/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-43939/read.awpHow to return table from a MS SQL Stored procedure with native access driver?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-43934/read.awp10 Jan 2014 14:59:00 ZHi Richard FYI: your question has been "automatically" copied on the pcsoft US windev forum, and got an answer over there (it…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-43934/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-43934/read.awpHow to return table from a MS SQL Stored procedure with native access driver?bobpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-43928/read.awp10 Jan 2014 09:57:25 ZThe code listed below will read the result of a stored procedure and populate a table: ======================================…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-43928/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/43923-how-return-table-from-sql-stored-procedure-with-43928/read.awpHow to return table from a MS SQL Stored procedure with native access driver?