#define d_sum price*d_quantity as hello

create....
select ....

messagebox(hello)


>I use #define constant in SELECT statement and as character string like:
>
>

>CREATE CURSOR invoice ( price N(12,2), quantity N(2), packing N(2))
>#define d_quantity quantity*packing
>#define d_sum price*d_quantity
>
>SELECT d_sum FROM invoice
>
>TEXT TO ctxt noshow
>  d_sum
>  ENDTEXT
>MESSAGEBOX('Sum formula is: '+ctxt)
>

>
>This requires separate memory variable using TEXT command for each #define
>
>How to force MESSAGEBOX() to show d_sum value as character string without using TEXT command?