Cyril,
as you already mentioned. All attributes which you have defined for locking
in your model will be included in the where clause for
updates/inserts/deletes. Deselect all attributes which you don't want to be
in the where clause in the model and it should work.
Dominik
> WO 4, NT 4, SP 4
>
> Hi,
>
> I have a problem when I update some info on a MSSQL database. Some columns
> are in "text" type, so when I try to update, I have a message telling me
> that I cannot use text or image datatypes in a where clause. This is because
> EOF uses a where clause on the whole row, rather than only on the primary
> key.
>
> I digged into the documentation to find where I could change that behavior,
> and found the documentation about the locking mechanism, but I am unsure
> wether this will work with MSSQL, and solve my problem. And it doesn't
> answer my problem, which is:
> how do I update rows using the primary key to select them?
>
> I also found the programming topic "Updating with the Adaptor Level" on
> Apple website, but the example is in ObjectiveC and I was unable to find the
> corresponding method in Java. And it looks like I loose all the advantages
> of the EOEditingContext, and have to manage a lot of things myself (which I
> don't want to do).
>
> I have enclosed the error message (some is in French sorry).
>
> ==================================
> Cyril Godefroy
> Lab Production - CD and web development
> 105 rue La Fayette - 75010 Paris
> Tel (33) 1 55 07 28 28
> Fax (33) 1 55 07 80 92
> ===================================
>
> EOGeneralAdaptorException: Exception occured while evaluating 'submit', on
> target:<change_surname 0xaa1c00>:
> SQLExecDirect in -[ODBCChannel evaluateExpression:(<ODBCSQLExpression:
> "UPDATE "PERSONNE" SET surname= ? WHERE (PERS_ID = ? AND Nom = ? AND
> Prenom = ? AND Telephone = ? AND mail = ? AND poste = ? AND surname= ? AND
> userLevel = ?)" withBindings:(1:bonhomme(surname), 2:26(PERS_ID),
> 3:Godefroy(nom), 4:Cyril(prenom), 5:01 42 29 51 34(telephone),
> 6:[EMAIL PROTECTED](mail), 7:301(poste), 8:maxou(surname),
> 9:5(userLevel))>)]
> 37000-306: [Microsoft][ODBC SQL Server Driver][SQL Server]Il n'est pas
> permis d'utiliser les types de donn\U00e9e TEXT et IMAGE dans une clause
> WHERE, sauf avec l'expression LIKE
>
