[Ver 7.0] Can't set parameter for stored procedure

Forum related to MS SQL Server

Moderators: gto, cipto_kh, EgonHugeist

User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

ManoShu,

thats's no good sign. I'm forced to roleback this patch.

So what can we do to handle this part right? Either we can ask the Server for a Unique Value which identifies exactly the SQL Server 2008. then we need some additional Parameters to check the inherited classes if ObjectNames MUST be escaped.
Or the Microsoft-Documentations can help here to find out if there is a Connection-Paramter which we can send to force him to unescape such "_" chars right again. I know ProstgreSQL supports such options.

Hmm the null-values making me curious too. Can you find out something for me?
What happens here?
Statement.SetNull(I+1, ConvertDatasetToDbcType(Param.DataType))

Can you also try to send the Server a Query like Update Table1 Set Field1=1 Field2=NULL where ....;
Is this Statement valid?

Michael
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
Post Reply