Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error: Function argument value, type, or count is invali
Message
From
16/07/2004 13:34:51
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
16/07/2004 12:32:26
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00925243
Message ID:
00925268
Views:
14
That is a long chunk of code; I suggest you eliminate or add small pieces, until you find out which specific line or option is causing the error.

>I'm having this error: function argument value, type, or count is invalid, when i'm trying to do this query:
>
>
select 	llamadas.numero				as numero		,;
>		llamadas.fllamada 			as fllamada		,;
>		llamadas.fatencion			as fatencion	,;
>		llamadas.fcierre			as fcierre		,;
>		llamadas.estado				as estado		,;
>		llamadas.host	 			as host			,;
>		llamadas.modelo 			as modelo		,;
>		llamadas.undhard 			as hardware		,;
>		llamadas.usuario			as usuario		,;
>		llamadas.reporta   			as usunombre	,;
>		oficina.nombre				as ofinombre	,;
>		llamadas.piso				as piso			,;
>		llamadas.ingeniero			as ingeniero    ,;
>		ingeniero.nombre			as ingnombre	,;
>		llamadas.servicio			as codservicio  ,;
>		sub_unidades.descripcion 	as categoria	,;
>		dispositivo.descripcion 	as disnombre	,;
>	    "1"							as temporal		;
>	  FROM  helpdesk!llamadas ;
>		    FULL JOIN helpdesk!sub_unidades ON  Llamadas.servicio = Sub_unidades.codigo;
>		    FULL JOIN helpdesk!ingeniero    ON  Llamadas.ingeniero = Ingeniero.codigo ;
>		    FULL JOIN helpdesk!dispositivo  ON  Llamadas.dispositivo = Dispositivo.codigo ;
>		    FULL JOIN helpdesk!oficina      ON  Llamadas.oficina = Oficina.codigo ;
>		    FULL JOIN helpdesk!usuarios_cia ON  Llamadas.usuario = Usuarios_cia.codigo ;
>	 where 	Sys(11,Llamadas.fllamada) >= sys(11,m.ini) and;
>            Sys(11,Llamadas.fllamada) <= Sys(11,m.fin) ;
>order by numero ;
>group by numero
>
>What's wrong with the query?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform