Hi all,
MSSQL driver
I have starge problem, I am calling SP from Clarion as usual using prop:sql
mytable{:prop:sql} = 'Call MySP'
usually Clarion SQL driver convert it to and executed in sql as
exec MySP
and it works fine.
But sometime it generate something like this:
SET FMTONLY On EXEC MySP SET FMTONLY OFF
so somehow it adds SET FMTONLY before and after EXEC (in one line) and prop:sql returns error 90.
Why?? Who are triggering SET FMTONLY ??
my Sp defined as this:
CREATE PROCEDURE mySP (
--@ReturnCode smallint output
) AS
BEGIN
Declare
@ReturnCode smallint
set @ReturnCode = -1
select @ReturnCode
END
so it returns some value using SELECT and we can read it by
NEXT(mytable)
best regards,
Guennadi