| Hi,
I use SOAP-calls to WO and I get strange effects in the following routine:
public void deleteWebtextValue (String webtext, String language) {
EOEditingContext ec = new EOEditingContext(); EOQualifier aQual; NSMutableArray qbind; EOFetchSpecification fs;
LanguageWebtext lwObject; qbind=new NSMutableArray(); qbind.addObject(webtext); qbind.addObject(language); aQual = EOQualifier.qualifierWithQualifierFormat("(webtext.webtext=%@) and (language.language=%@)",qbind); fs = new EOFetchSpecification("LanguageWebtext",aQual,null); NSArray arLanguageWebtext = ec.objectsWithFetchSpecification(fs); // should only be 1 for (int i=0;i< arLanguageWebtext.count();i++) { lwObject = (LanguageWebtext)arLanguageWebtext.objectAtIndex(i); ec.deleteObject(lwObject); } ec.saveChanges(); }
Most of the time this results in a delete-statement: delete from languagewebtext where languagewebtext_id=8788;
but sometimes I get a (strange) update-statement:
update languagewebtext set language_id = NULL, webtext_id = NULL where languagewebtext_id=8898; Both can't be NULL; This results in currupting the database!
I don't understand that!
Thanks for helping, Frank Stock |