I have a DataSet which is pulling from a MS SQL stored procedure. I have it working for Insert/Update/Delete commands, however I can not get the RefreshDataSet working properly. In the Business Processor I have the original DataSet command set as the RefreshDataSetName. (example: when doing an update, all I really want to do is rerun the original query with the original parameters.) On the surface, this appears to work well, HOWEVER, when the SQL is passed to the MS SQL server it gives the following error:
‘Implicit conversion from data type sql_variant to int is not allowed. Use the CONVERT function to run this query.’
On the SQL server (using the profiler) I can see that the query was setup as the following:
exec sp_prepare @p1 output,N’@P1 sql_variant OUTPUT’,N’EXEC [inters].[Client_School_GetGeneralABE] @P1’,1
The stored proc output should be specified as an INT. I can see no where to get DA to specify this as an INT.
It thought in MSSQL the return value from a stored proc was always an INT??
Help!
-Scherb
(Using Delphi Win32 & MS SQL 2005)