Gilles,

You may want to add a space between each semi-colon. When you continue a line, VFP doesn't add any kind of separation. For example, this:

SELECT *;
FROM clubapp!membres;
WHERE ...

Translates to this:

SELECT *FROM clubapp!membresWHERE ...

>Hello !
>
>Impossible to make programmatically on VFP6 a view like :
>
>CREATE SQL VIEW lv_findmembres AS;
>SELECT *;
>FROM clubapp!membres;
>WHERE UPPER(Membres.cnom) LIKE UPPER(?vp_cNom);
>AND UPPER(Membres.cprenom) LIKE UPPER(?vp_cPrenom)
>
>I get an error message (Function argument value, type or count is invalid)
>and then for the pleasure an C0000005 Exception error !!!
>
>Help !
>
>Gilles