Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Execute storedproc with parameters via XData |
Thu, Apr 19 2018 5:03 PM | Permanent Link |
Mike | Hi,
I would like to run a stored procedure via TMS RemoteDB similar to, https://www.tmssoftware.com/site/forum/forum_posts.asp?TID=8605&title=about-remotedb-txdataset65288stored-procedure . Is that possible? |
Sun, Apr 22 2018 2:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mike,
<< I would like to run a stored procedure via TMS RemoteDB similar to, https://www.tmssoftware.com/site/forum/forum_posts.asp?TID=8605&title=about-remotedb-txdataset65288stored-procedure . Is that possible ? >> I'm not familiar with that product, so you'll have to ask about it on their support forums. Tim Young Elevate Software www.elevatesoft.com |
Mon, Apr 23 2018 8:19 AM | Permanent Link |
Mike | Hi Tim,
The TMS product uses the SELECT statement for retrieving datasets. I noticed the remark "You can only retrieve result sets from procedures from a client (TEDBStoredProc)."in one of your posts here. Would it be possible to support stored procedures in select statements? |
Mon, Apr 23 2018 12:04 PM | Permanent Link |
Rolf Frei eicom GmbH | << Would it be possible to support stored procedures in select statements? >>
Yes this is something I realy miss here in EDB. We shoud be able call a Procedure from a normal TEDBQuery SQL. In Informix I'm able to place "Execute Procedure myProc(a,b)" into the TQuery.SQL and get an resultset like a normal Select back. Of yourse the Procedure must return a cursor. I would be happy if we get something similar here in EDB, without to use a TEDBStoredProc. What you can do is this: "SELECT MyFunction()". This works with functions but it doesn't work with a procedures which returns a cursor. |
Tue, Apr 24 2018 1:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mike,
<< Would it be possible to support stored procedures in select statements? >> No, we cannot do so because of the way that EDB's SQL/PSM implementation works. Cursors that are returned from procedures/functions/scripts are dynamic and there is no way to gather information about their makeup without actually executing them, and this obviously can have side-effects that aren't good. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |