>>>hmm, how about replacing the variables with DEFINITIONs ?
>>>This way you keep readability but skip variable assigninments.
>>
>>What do you mean here? Could you please elaborate?
>>
>>>Have a good Shabos haChodesh .
>>
>>Good Shabbos to you too!
>>
>>Thanks.
> well, if you promise to get home in time for `licht benching` :-)
>sometimes when i have complicated variable assingnments I use DEFINE 's.
>so instead of something like:
> lcVar = str(field1)+substr( field2, at("-",field3))+transform( val( lcVar1,"99.999")
> insert into tbl01 (field5) value (lcVar)
>i would do:
>

>#DEFINE VALUE_NEW str(field1)+substr(field2,at("-",field3))+transform(val(lcVar1,"99.999")
>.
>.
>.
>   insert into tbl01 (field5) value (VALUE_NEW)
>.
>.
>.
>#UNDEF VALUE_NEW
>

I'm now leaving at 3pm on Fridays, come home at 4pm, so I have ~ 2 hours before candles lighting.

The suggested change would not help a bit and I don't think it makes any difference in your code execution. Basically, in compile time your insert will look exactly the same as you would type long string in the insert command...

Anyway, thanks for the ideas. Keep am coming <g>