Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with a variable into a select
Message
From
18/04/2002 18:11:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Problem with a variable into a select
Miscellaneous
Thread ID:
00646663
Message ID:
00646663
Views:
49
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.
Next
Reply
Map
View

Click here to load this message in the networking platform