Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accesing to a field in a table
Message
From
15/05/2002 11:15:10
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Accesing to a field in a table
Miscellaneous
Thread ID:
00656934
Message ID:
00656934
Views:
48
Hello, i've created a table with a query, this is my query:

SELECT distinct Llamadas.numero, Llamadas.ingeniero, Ingeniero.codigo,;
Ingeniero.nombre AS ingeniero, Llamadas.fllamada, Llamadas.fcierre,;
(val(sys(11,Llamadas.fcierre))-val(sys(11,Llamadas.fllamada))) AS Dias;
FROM helpdesk!llamadas, helpdesk!ingeniero, helpdesk!festivos;
WHERE Sys(11,Llamadas.fllamada) >= sys(11,m.ini) and;
Sys(11,Llamadas.fllamada) <= Sys(11,m.fin) and ;
Llamadas.ingeniero = Ingeniero.codigo;
AND (EMPTY(Llamadas.fllamada) <> .T.;
AND EMPTY(Llamadas.fcierre) <> .T.);
into table unotab.dbf

I need to deal with the alias field Dias, i been trying with the unotab.dias, but its hopeless, am i doing something wrong?
Please help.

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform