I think I found a bug in ADO.NET driver for SA 11. if I try to execute this code:
Works fine. But if I change to use parameters, I get this error: "iAnywhere.Data.SQLAnywhere.SAException: Cannot convert 'my string' to a int at iAnywhere.Data.SQLAnywhere.SACommand._ExecuteReader(CommandBehavior commandBehavior, Boolean isExecuteScalar, Boolean isBeginExecuteReader) at iAnywhere.Data.SQLAnywhere.SACommand.ExecuteScalar() " In Interactive SQL, this command executes fine. If I change sql command to "select 'my ' || 'string' from DUMMY', ADO.NET executes fine too. It's an bug or an expected behavor? I'm using sa 11.0.1.2355 asked 17 Dec '09, 14:00 Zote |
New question created for this. http://sqlanywhere-forum.sap.com/questions/267/bug-in-sa-11-net-driver-2 answered 10 Jan '10, 19:17 Zote |
I copied/pasted your code into a VS2008 project and the last line gives the error: Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?) So if I do either of:
-or-
Then I get the correct result. Is this what you expected? I'm using SA 11.0.1.2324. José answered 04 Jan '10, 21:23 José Ramos sorry, i'll correct above code. I'm working like your first option. Whats your SA version ? Sorry, it's my fault :( I'm using 11.0.1.2308. I'll update it and test again. +1 fault mine. Using above sql command, it works fine. But using parameters (and its my real case) it crashes. Try starting a new question, with exact code and exact versions of everything and exact error message if possible... sometimes a reboot helps :) Nice tip! Tomorrow I'll, I'm at home now. More comments hidden
|