>>>>Have you tried removing the table ref?
>>>>i.e...
>>>>CREATE SQL VIEW lv_findmembres AS ;
>>>>SELECT * ;
>>>>FROM clubapp!membres ;
>>>>WHERE UPPER(cnom) LIKE UPPER(?vp_cNom);
>>>>AND UPPER(cprenom) LIKE UPPER(?vp_cPrenom)
>>>>
>>>>or
>>>>
>>>>CREATE SQL VIEW lv_findmembres AS ;
>>>>SELECT * ;
>>>>FROM clubapp!membres ;
>>>>WHERE UPPER(cnom)=UPPER(?vp_cNom);
>>>>AND UPPER(cprenom)=UPPER(?vp_cPrenom)
>>>
>>>Thanks to all for your help !
>>>
>>>Gilles
>>What was the solution?
>Hi !
>The solution was strange !!! but it works :
>On my database membres I had an index on UPPER(cnom) named CNOM... I just deleted this index and everything is working now... I have to say that I don't understand why at all but it works...
>
>Perhaps someone has an answer to this mystery ???
>
>Gilles
If you don't have an index on UPPER(cnom) then your SELECT statement will suffer a significant performance degredation.