Hi all, I have 2 models using different schema of a database. but these schemas have table which have relationship. So in my model "A", I use a fetch spec. on a table which have the maximum relation with tables in model "A" and "B". So when I excute my fech spec, WO don't see the schema of model A and show exception ORA-00942 : table or view does not exist. This a the querry generate by WO on fetching :
"SELECT t0.ANC_UV_OUVERTE_ID, t0.CATEG_ID, t0.CRE_DATE, t0.DIPL_SPEC_$C, t0.DIPLOME_$C, t0.MAJ_AUTEUR, t0.MAJ_DATE, t0.NLE_UV_OUVERTE_ID, t0.UV_CREDITS_ECTS, t0.UV_OUV_ID FROM UV_OUVERTES t0, INDIVIDU T4, UV_OUV T1, ETU_INSCR_ADM T3, DIPLOME T2 WHERE ((T1.AN_UNIV like ? ESCAPE '\' AND T1.PRD_UNIV like ? ESCAPE '\') OR t0.DIPLOME_$C like ? ESCAPE '\' OR T3.NIVEAU_ADM = ? OR T1.UV_OUV_ID = ?) AND T3.CONSEILLER_ID = T4.INDIV_ID AND t0.UV_OUV_ID = T1.UV_OUV_ID AND T2.DIPLOME_$C = T3.DIPLOME_$C AND t0.DIPLOME_$C = T2.DIPLOME_$C ORDER BY T4.NOM ASC, T4.PRENOM ASC" withBindings: 1:"2005"(anUniv), 2:"1A"(prdUniv), 3:"ING2"(diplomec), 4:"1"(niveauAdm), 5:131(uvOuvId)>" tables INDIVIDU, ETU_INSCR_ADM and DIPLOME are table of schema B but WO can't translate it like that i.e : A.INDIVIDU or A.ETU_INSCR_ADM. Thanks for your help PS : I have a storedProcedure which return data and do the same request but I don't know how to insert it in my code and binding it with WODisplayGroup for batch view (previous, next) with 10 students per batch.
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
