Hi,
I want to make this kind of query with LLBGENPRO but I don't know how :
select M_ID, mchi(ctab) from MMOL
- M_ID is a field in my database
- mchi is a function of my database
- ctab is a value, not a field or a variable
I've tried with this code but it doesn't work, i've got an Oracle exception "Operation not allowed" :
EntityField2 AnyRefSearch = new EntityField2("AnyRefSearch", new DbFunctionCall("mchi(ctab)", null));
ResultsetFields fields = new ResultsetFields(2);
fields.DefineField(MMOLFields.MId, 0, "ID");
fields.DefineField(AnyRefSearch, 1, "Chime");
RelationPredicateBucket bucketTest = new RelationPredicateBucket();
DataTable dynamicList = new DataTable();
adapter.FetchTypedList(fields, dynamicList, bucketTest, false);
Please help me.
Thank you very much.