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
