>>Clay,
>>
>>>The tablename propery on the business class is used for the Save, NewRow and Cancel.
>>
>>Gotcha...if the TableName property is different than the actual Oracle table name, try setting the ConcurrencySelectStatement property as demonstrated in the MM .NET Developer's Guide topic "Jump Start - Creating Business Objects (C# or VB .NET) - Step 5: Creating an OrderDetail Business Object".
>>
>>Regards,
>
>
>The TableName Property and the actual Table name in Oracle are the same, even the same case.
>I traced the problem to this line in GetConflictData
>
>string SelectStatement = "Select * From [" +tableName + "] WHERE ";
>
>Oracle does not recognize the square brackets in the sql statement as valid.
>I also discovered that I need to prefix the table name with the Oracle Schema name (.ie. select * from OTS.ORDINANCE WHERE ...)
I followed the error further into the dao.SaveDataSet(dsDelete, TableName, null, false, null) method and got this error
OleDbCommand.Prepare method requires all parameters to have an explicitly set type.
--------------------------
Clay Angelly
cangelly@ie-inc.comNever argue with an idiot. They drag you down to their level and beat you with experience.