Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with a variable into a select
Message
De
18/04/2002 18:11:54
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Problem with a variable into a select
Divers
Thread ID:
00646663
Message ID:
00646663
Vues:
50
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform