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.

Take a look at the documentation for Specifying constants for function parameters.

Matt

I've solve my problem :

EntityField2 AnyRefSearch = new EntityField2("AnyRefSearch", new DbFunctionCall("mchi({0})", new object[] {MyTabFields.Ctab}));

Thank you for your answer.