>Thanks for your answer.I tried the solution you appointed when the use of parameters failed and it works.But I'd like to know why the solution using parameters doesn't work with numeric or boolean parameters.Do you have any idea?
>
>Moacyr

The use of the parameters collection is appropriate for calling stored procedures with parameters and a CommandType property of adCmdStoredProc. While I have used them with SQL Server stored procedures I haven't tried with the VFP OLEDB provider yet and a stored procedure in a DBC. Having said that I would say that the OLEDB provider does not automatically understand the question mark in a SQL statement (?) to be a parameterized query.