Hi Mark - I love SQL 4 CDS! Thanks for creating and maintaining it!
I am getting the unhandled exception pasted below every time I try to execute this query with the where clause included:
select wdi_name from wdi_assignmenttype where wdi_workflow = 'Task' ;
If I execute without the where clause, it works just fine.
I finally realized I need to use wdi_workflowname (it's a lookup column), but I'm also thinking you're missing an exception handler somewhere?
Msg 2786, Level 16, State 1, Line 7
The data type of substitution parameter 2 does not match the expected type of the format specification.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
** Exception Text **
System.NullReferenceException: Object reference not set to an instance of an object.
at MarkMpn.Sql4Cds.XTB.SqlQueryControl.ShowResult(IRootExecutionPlanNode query, ExecuteParams args, DataTable results, String msg, QueryExecutionException ex)
at MarkMpn.Sql4Cds.XTB.SqlQueryControl.backgroundWorker_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
Hi Mark - I love SQL 4 CDS! Thanks for creating and maintaining it!
I am getting the unhandled exception pasted below every time I try to execute this query with the where clause included:
select wdi_name from wdi_assignmenttype where wdi_workflow = 'Task' ;If I execute without the where clause, it works just fine.
I finally realized I need to use wdi_workflowname (it's a lookup column), but I'm also thinking you're missing an exception handler somewhere?
Msg 2786, Level 16, State 1, Line 7 The data type of substitution parameter 2 does not match the expected type of the format specification.
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
** Exception Text ** System.NullReferenceException: Object reference not set to an instance of an object. at MarkMpn.Sql4Cds.XTB.SqlQueryControl.ShowResult(IRootExecutionPlanNode query, ExecuteParams args, DataTable results, String msg, QueryExecutionException ex) at MarkMpn.Sql4Cds.XTB.SqlQueryControl.backgroundWorker_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e) at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)