Sorry. I mis-understood/mis-read your message and example. :-)
-----Original Message-----
From: S. Esteban Rodr�guez [mailto:[EMAIL PROTECTED]
Sent: 28 April 2005 21:31
To: Terry McDonnell
Subject: RE: MI-L variable into sql
either works .... i don't know that happend but don't work.
Thanks Terry, but i can't do use the variable into a sql statement. If someone
can help me i will be tankfull Remember the problem:
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 18:49
Para: S. Esteban Rodr�guez
Asunto: RE: MI-L variable into sql
Perhaps you need to include at least one of the subjectr table's fields for it
to work?
Select COL1, COL1-xmed "Paso1" from table into Desvi
Terry
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16299
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16302
