using stored procedure in MSSQL

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
crisg0112
Posts: 395
Joined: Fri Jan 31, 2014 3:45 am
Location: Melbourne, Australia

using stored procedure in MSSQL

Post by crisg0112 »

Hi,

I have a stored procedure that creates a subset of data based on my search criteria.

On my search criteria, one of the attribute is EmpNo.

If I leave the EmpNo blank (ie, I want it to return ALL the data). AwareIM comes up with an error 'The conversion from UNKNOWN to UNKNOWN is unsupported'.

The question is, how does AwareIM pass an 'UNDEFINED' into SQL?
Thanks in advance!

Cris
MSSQL 2008R2, Aware 7 b2146, IE11, , Firefox 35.0.1, Windows 8 Bootstrap theme
Top
Post Reply

Return to “General discussion and questions about Aware IM”