Clay,

>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.

From what I can see by the error you posted, the problem is not in the SQL SELECT statement, but in data binding to the data retrieved from that object. If you look at the following excerpt, you can see your business object calls GetDataSet, which in turn calls FillDataSet. Afterwards, the businesss object raises a StateChange event to alert listeners that it has retrieved data. Next, a textbox responds to the StateChange event and attempts to bind to the data retrieved from the business object. You may want to check your Windows Forms binding properties to see if they're OK. If you don't see any problem initially, you can turn off binding on individual textboxes by setting the BindingFlag to false to see which textbox is giving you the problem. You may also need to set a breakpoint and look at the DataSet returned from the business object at runtime.

Regards,


> at OakLeaf.MM.Main.Windows.Forms.mmBindingStrategySimple.BindData(ImmBindingSimple mmControl, DataSet ds, String tableName, String fieldName, mmBusinessObject bizObj)

// Textbox calls the binding strategy class where the error occurs
> at OakLeaf.MM.Main.Windows.Forms.mmBindingStrategySimple.BindData(ImmBindingSimple mmControl, mmBusinessObject bizObj, mmBusinessStateChangeEventArgs e)

// Textbox calls its OnBindData method
> at OakLeaf.MM.Main.Windows.Forms.mmTextBox.OnBindData(mmBusinessObject bindingSource, mmBusinessStateChangeEventArgs e)

// Textbox responds to the event
> at OakLeaf.MM.Main.Windows.Forms.mmTextBox.StateChangeHandler(mmBusinessObject bizObj, mmBusinessStateChangeEventArgs e)

// Delegate invoked
> at OakLeaf.MM.Main.Business.mmBusinessStateChangeDelegate.Invoke(mmBusinessObject bizObj, mmBusinessStateChangeEventArgs e)

// Business object raises the actual StateChange event
> at OakLeaf.MM.Main.Business.mmBusinessObject.OnStateChange(mmBusinessState bizState, String tableName, Object primaryKeyValue, Object[] primaryKeyValues)

// Business Object CallStateChange
> at OakLeaf.MM.Main.Business.mmBusinessObject.CallStateChange(mmBusinessState bizState, String tableName)

// Business Object FillDataSet executed
> 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

// Business Object GetDataSet executed
> at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey, CommandType cmdType, IDbDataParameter[] dataParams)