Powerbuilder & sql server

[Michèle Tahay]

Hello,

I have a powerbuilder 11.5 application (build 3127) which connects to
a sql server database (2008).
When I take a trace of this database I see things like these:

declare @p1 int
set @p1=NULL
exec sp_prepexec @p1 output,N'@P1 float',N'SELECT blahcolumn from
table where keyColumn = @P1',1
select @p1

I see that the variable is declared correctly, but in the call to
sp_prepexec suddenly a float is used.

I checked the retrieval argument in the datawindows in question, and
it is a number not a decimal. The column that is used in the where
clause is an integer, in the datawindow it shows as a long (which is
normal I guess). There is no apparent reason why a float would be used
in the query.

Now, the query doesn't fail but the execution plan could be better.
Could anyone explain this? Any way to solve it? Google search did not
bring me any answers (yet).

Kind greetings,

Michèle Tahay

[bruce.a...@yahoo.com]

Although this group is active on the Sybase server the feed between Google and the Sybase server is not currently working. If you post through Goolge the post will never show up on the Sybase server, and most people who answer questions in that group will never see it. Instead, you may want to access the Sybase newsgroups directly at:

http://www.sybase.com/detail_list?id=11507&pageNum=1&multi=true&show=1248