martinrybak / SQLClient

Native Microsoft SQL Server client for iOS
http://objcsharp.wordpress.com/2013/10/15/an-open-source-sql-server-library-for-ios/
MIT License
125 stars 51 forks source link

Nulls in temp tables cause issues #7

Closed nhgrif closed 7 years ago

nhgrif commented 10 years ago

A null value in temp table (using the #) in a column not marked as nullable will prevent any results from being returned and fires the error:code:severity:, with code #515, "General SQL Error, check messages from server" (or something like this). This can be worked around by marking the tables as nullable on the server end.

nhgrif commented 10 years ago

Again, this is happening on SQL Sever 2008 R2 and SQL Server 2005

martinrybak commented 8 years ago

Please try out the types branch. This issue should be fixed.