>>Is there a way to convert a character field to a numeric field? (I need it to be numeric so there is a decimal)
>>
>>Thanks,
>
>Ryan,
>
>...and I'll point out the following:

CREATE CURSOR Foo (SomeNum N(7, 3))
>m.somenum = '1234.56'
>APPEND BLANK
>GATHER MEMVAR && Works
>REPLACE SomeNum WITH m.somenum && Doesn't work

Neither does insert work.

I noticed this with APPEND FROM ARRAY as well.

** with the same cursor
DIMENSION laArray(1,1)
laArray[1,1]='1234.56'
APPEND FROM ARRAY laArray && works

Why does this work?

Insanity: Doing the same thing over and over and expecting different results.