mmm I want populate a new column whith the valour of each row of the table
less the xmed variable, but not runs!
if i do:
dim xmed as float '
select avg(COL1) from Table into media 'now MEDIA contains the
average of
the COL1
xmed=media.col1 'now the xmed variable contains the average
value of the
COL1 of the Table
select COL1-xmed "Paso1" from table into Desvi ' and now the
new column
PASO1 would must contains the value of the table.COL1 - variable ... but it
oly works in the mapBasic window, not in a mapBasic program. Why?
a greeting!
-----Mensaje original-----
De: Terry McDonnell [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 28 de abril de 2005 11:03
Para: S. Esteban Rodr�guez
Asunto: RE: MI-L variable into sql
Surely you mean:
Select ColName from DEVI where ColName = xmed
?
-----Original Message-----
From: S. Esteban Rodr�guez [mailto:[EMAIL PROTECTED]
Sent: 27 April 2005 19:31
To: Terry McDonnell
Subject: MI-L variable into sql
how i can use a variable into sql? i can derive a column but it also is in
white
dim xmed as float
select avg(x) from Table into media
xmed=media.col1
select x-xmed from table into Desvi
.... BUT THE TABLE DESVI NOT CONTAINS ANY VALUE IN EACH ROW!! in the
mapbasic window runs, but in a mapbasic application it crash. someone can
explain that i must do please?
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16278
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16288
