I have a bizobject executing a sql-select statement that works in my ASP.NET page and the actual query works directly in Oracle, but fails in Windows Forms.

Actual Sql statement:
SELECT digest as digest_short, prop_id, prop_no, prop_year, com_id,status_id, introduced_date, initiated_by, proposal.ordtype_id, ordtype_desc, ordinance_no, drafted_by, proposal.com_id, com_name FROM OTS.PROPOSAL LEFT JOIN ordinance ON proposal.ordtype_id = ordinance.ordtype_id LEFT JOIN committee ON proposal.com_id = committee.com_id WHERE 1=1 AND prop_year=2004 ORDER BY LPAD(PROP_NO,4,'0')


winforms code:
this.dsProposal = this.oProposal.GetProposals(this.cboYear.Text.Trim(),this.txtPropSearchNo.Text.Trim());

I step through the code in WinForms, copy the select statement from QuickWatch(debugger)
paste it in my Oracle client software(TOAD) and it works. Try to step pass the line that actually calls the GetDataSet ...

--
return this.GetDataSet(selectStatement);
--

with the same sql-select and the following Error occurs.




If there is no problem with the SQL statement why am I getting this error?


The Error reads: Object reference not set to an instance of an object.

at OakLeaf.MM.Main.Windows.Forms.mmBindingStrategySimple.BindData(ImmBindingSimple mmControl, DataSet ds, String tableName, String fieldName, mmBusinessObject bizObj)
at OakLeaf.MM.Main.Windows.Forms.mmBindingStrategySimple.BindData(ImmBindingSimple mmControl, mmBusinessObject bizObj, mmBusinessStateChangeEventArgs e)
at OakLeaf.MM.Main.Windows.Forms.mmTextBox.OnBindData(mmBusinessObject bindingSource, mmBusinessStateChangeEventArgs e)
at OakLeaf.MM.Main.Windows.Forms.mmTextBox.StateChangeHandler(mmBusinessObject bizObj, mmBusinessStateChangeEventArgs e)
at OakLeaf.MM.Main.Business.mmBusinessStateChangeDelegate.Invoke(mmBusinessObject bizObj, mmBusinessStateChangeEventArgs e)
at OakLeaf.MM.Main.Business.mmBusinessObject.OnStateChange(mmBusinessState bizState, String tableName, Object primaryKeyValue, Object[] primaryKeyValues)
at OakLeaf.MM.Main.Business.mmBusinessObject.CallStateChange(mmBusinessState bizState, String tableName)
at IEI.OTS.Business.ABusinessObject.FillDataSet(DataSet ds, String command, String tableName, String databaseKey, CommandType cmdType, IDbDataParameter[] dataParams) in o:\ots business\business.cs:line 235
at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey, CommandType cmdType, IDbDataParameter[] dataParams)
at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey, IDbDataParameter[] dataParams)
at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey)
at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName)
at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command)
at IEI.OTS.Business.Proposal.GetProposals(String propYear, String propNumber, String propCouncillorID, String propKeywords, Boolean propTruncateDigest) in o:\ots business\proposal.cs:line 470
at IEI.OTS.Business.Proposal.GetProposals(String propYear, String propNumber) in o:\ots business\proposal.cs:line 341
at IEI.OTS.Main.Windows.Forms.mmProposalForm..ctor(mmStatusBar oStatusBar) in o:\ordinancetrackingsystem\mmproposalform.cs:line 237
at IEI.OTS.Main.Windows.Forms.MainForm.lblUpdateProposalActions_LinkClicked(Object sender, LinkLabelLinkClickedEventArgs e) in o:\ordinancetrackingsystem\mainform.cs:line 1223
at System.Windows.Forms.LinkLabel.OnLinkClicked(LinkLabelLinkClickedEventArgs e)
at System.Windows.Forms.LinkLabel.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Label.WndProc(Message& m)
at System.Windows.Forms.LinkLabel.WndProc(Message& msg)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.ComponentManager.System.Windows.Forms.UnsafeNativeMethods+IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at IEI.OTS.AppMainEntry.Main() in o:\ordinancetrackingsystem\main.cs:line 56