It doesn't work this way. Try to use macro substitution
IN (&chkvalue);
What is the value stored in the chkvalue variable?
>Hello, i have a problem with a select, im trying to add a variable this is my sentence:
>
>SELECT Ingeniero.nombre, SUM(Llamadas.tiempo_sol),;
> AVG(Llamadas.tiempo_sol), SUM(Llamadas.calidad), AVG(Llamadas.calidad);
> FROM helpdesk!llamadas INNER JOIN helpdesk!ingeniero ;
> ON Llamadas.ingeniero = Ingeniero.codigo;
>WHERE Sys(11,Llamadas.fllamada) >= sys(11,m.ini) AND ingeniero.codigo IN (chkvalue);
>GROUP BY Ingeniero.nombre;
>ORDER BY Ingeniero.nombre;
>Into table ingestad.dbf
>
>the variable is chkvalue and it displays an error when you run this query.
>
>How do i solve this? its something wrong in my code?
>
>Please help.
--sb--