#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?