You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Submitted by: Victor Israel Herrera Coronado (ppman5k)
The problem or issue that I've with the new version of http://Firebird.Net 2.6. library it's that I can't execute store procedures as I'd usually do with the previous version (2.5). Not produces any kind of error, only the procedure that would output information returns nothing.
For example: With C#, Getting a DataSet
// Supposed m_fb_cnn as a valid FirebirdConnection
FbAdapter m_fb_ad = new FbAdapter("GET_INFO", m_fb_cnn);
m_fb_ad.SelectCommand.CommandType = CommandType.StoreProcedure;
m_fb_ad.SelectCommand.Params.Add("V_PARAM","VALUE");
// new dataset
DataSet m_dst = new DataSet();
// fill dataset
m_fb_ad.Fill(m_dst);
It supposed that the dataset wouldn't be empty. With the library 2.5 that not occurs, this functioned very good but in this one (2.6) doesn't function.
What I do wrong??
Best regards
The text was updated successfully, but these errors were encountered:
I created simple SP "create procedure get_info(v_param varchar(20)) returns (i int, j int) as begin suspend; suspend; end" and tested your code (in 2.7.7) and it works correctly. Can you check version 2.7.7 and/or provide the code for SP (and related objects if needed) for me to check the behavior?
Submitted by: Victor Israel Herrera Coronado (ppman5k)
The problem or issue that I've with the new version of http://Firebird.Net 2.6. library it's that I can't execute store procedures as I'd usually do with the previous version (2.5). Not produces any kind of error, only the procedure that would output information returns nothing.
For example: With C#, Getting a DataSet
// Supposed m_fb_cnn as a valid FirebirdConnection
FbAdapter m_fb_ad = new FbAdapter("GET_INFO", m_fb_cnn);
m_fb_ad.SelectCommand.CommandType = CommandType.StoreProcedure;
m_fb_ad.SelectCommand.Params.Add("V_PARAM","VALUE");
// new dataset
DataSet m_dst = new DataSet();
// fill dataset
m_fb_ad.Fill(m_dst);
It supposed that the dataset wouldn't be empty. With the library 2.5 that not occurs, this functioned very good but in this one (2.6) doesn't function.
What I do wrong??
Best regards
The text was updated successfully, but these errors were encountered: