Labelling a T-SQL Stored procedure as a database field 关注

0
Avatar
Jason Ruiter

I have a T-SQL stored procedure that returns a serial number. When I create a database field, I can use the "Custom SQL Statement" to call the procedure (exec usp_NextSerialNumber '231C'). I am unable to label it as a database field, so I can't access it from within a Bartender form. What's the proper way to do this?

3 评论

0
Avatar
Jacob Pazitka
评论操作 固定链接

In the stored procedure, does the return value have a label?

0
Avatar
Bob Steele
版主
评论操作 固定链接

Jacob,

Is there anyway to use a standard SQL statement to query and pull the correct records or possibly make a view table of the data that you need?  We do not officially support Stored Procedures in Bartender.

 

Thank you,

0
Avatar
Jacob Pazitka
评论操作 固定链接

Bob, that would depend.  The amount of data that a standard view would need to retrieve prior to filtering with the database prompts could be extensive.  This would negatively impact the SQL server as well as require tremendous resources on the Bartender client, and network infrastructure.  

If Bartender passed the prompts into the sql server to allow filtering to be performed on the sql server prior to data retrieval, then that process would be preferred.

It all depends on how Bartender and the ODBC function together.  

请先登录再写评论。