Hi, as requested here is the change I made to have it
working, those are syntax error, I am presently moving
and old program from VFP7.0 to .NET and SQL server and
meanly forget to change the query.
First change: add the @ in the parameter name.
Object[,] parametre = new object[,]
{{"@client",SqlDbType.Char,60,clientID}}; //use 2-
dimension array
Second change: add the @ in the parameter name, plus
remove the !empty() function and change it to <> ' ',
because the IS NOT NULL does not return the expected
results.
string select = "SELECT distinct
details.d_nfacture,project.p_name FROM project,details
where project.p_client = @client and details.d_nfacture
<> ' ' and project.p_refno = details.d_refno ORDER BY
d_nfacture";
Carl,
