Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting a Row (problem)
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
00864009
Message ID:
00864377
Vues:
13
>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.com
Never argue with an idiot. They drag you down to their level and beat you with experience.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform