Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error: Alias not found
Message
From
25/07/2003 14:35:12
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error: Alias not found
Miscellaneous
Thread ID:
00813595
Message ID:
00813595
Views:
39
I'm generating aleatory names of cursor and it was working just fine with some modifications that someone recommend me in this forum, but now i don't know what's happening? this is the code modified:
Set hour to 24
local i,j,TrendFunc,xlsheet,XLApp,tmpsheet,fllam,faten,fcier,taten,tsolu
public sietab,miarchivo
Set date dmy
SET CENTURY ON
set exclusive off
store substr(sys(2015),3) to unotab
store substr(sys(2015),3) to dostab
store substr(sys(2015),3) to tretab
store substr(sys(2015),3) to cuatab
store substr(sys(2015),3) to cintab
store substr(sys(2015),3) to seitab
store substr(sys(2015),3) to sietab
store substr(sys(2015),3) to curtab
m.ini = "01/01/2000"
m.fin = "31/12/2009"
m.usuario = 0
m.ingeniero = 0
m.grupo = 0
m.servicio = 0
m.modelo = " "
m.host = 0
Do form fecllam
SET STEP ON
*		usuarios_cia.nombre			as usunombre	,;

select 	llamadas.numero				as numero		,;
		llamadas.fllamada 			as fllamada		,;
		llamadas.fatencion 			as fatencion	,;
		llamadas.fcierre 			as fcierre		,;
		llamadas.undhard 			as hardware		,;
		llamadas.modelo 			as modelo		,;
		llamadas.mantenim 			as sernombre	,;
		llamadas.host	 			as host			,;
		llamadas.piso				as piso			,;
		llamadas.usuario			as usuario		,;
		llamadas.ingeniero			as ingeniero    ,;
		llamadas.grupo				as grupo	    ,;
		llamadas.servicio			as servicio	    ,;
		llamadas.reporta   			as usunombre	,;
		oficina.nombre				as ofinombre	,;
		oficina.hinicio				as hinicio		,;
		oficina.hfin				as hfin			,;
		dispositivo.descripcion 	as disnombre	,;
		ingeniero.nombre			as ingnombre	,;
		grupos_ing.nombre			as grunombre	,;
		sub_unidades.descripcion 	as mantenim		,;
		llamadas.ttransport			as taten		,;
		llamadas.ttransport			as tsolu		,;
		llamadas.nota				as nota			,;
		llamadas.fasignacion		as fasignacion	,;
		llamadas.fcierrerpt			as fcierrerpt	,;
		""							as vacio1		,;
		""							as vacio2		,;
		""							as vacio3		,;
		""							as vacio4		;
	from 	llamadas, usuarios_cia, oficina, dispositivo, ingeniero, grupos_ing, sub_unidades ;
	where 	Sys(11,Llamadas.fllamada) >= sys(11,m.ini) and;
            Sys(11,Llamadas.fllamada) <= Sys(11,m.fin) and ;
			!empty(llamadas.fcierre) and ;
			llamadas.usuario		= usuarios_cia.codigo		and ;
			llamadas.oficina		= oficina.codigo			and ;
			llamadas.dispositivo	= dispositivo.codigo		and ;
			llamadas.ingeniero		= ingeniero.codigo			and ;
			llamadas.grupo			= grupos_ing.codigo			and ;
			llamadas.servicio		= sub_unidades.codigo		;
order by numero ;
group by numero ;
into table (unotab)

select (unotab)
When i use the select (unotab) sentence it brings me the error Alias "cursor_name" not found

How can i fix this?
Thanks for the support
Next
Reply
Map
View

Click here to load this message in the networking platform