>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 ...)
--------------------------
Clay Angelly
cangelly@ie-inc.comNever argue with an idiot. They drag you down to their level and beat you with experience.