>Will that also help with the errors I am getting with the CTOD() Function. I keep getting a data mismatch using:
>
>SCAN WHILE ! EOF()
>rpl = ''
>drpl = ''
>rpl = LXPOS.ACTION+ALLTRIM(LXPOS.START)+ALLTRIM(LXPOS.XDATA)+ALLTRIM(LXPOS.ENDING)
>drpl = ALLTRIM(LXPOS.XFIELD)
>REPLACE &drpl WITH rpl
>ENDSCAN
>
>The Start and Ending are just "(" and ")" in my dbf with the action being CTOD.
You can not sum variables or fields of a different type. Perhaps you're thinking of DTOC function, e.g. convert date to character.
rpl = LXPOS.ACTION+ALLTRIM(LXPOS.START)+ALLTRIM(LXPOS.XDATA)+ALLTRIM(LXPOS.ENDING)
Action here must be a character field or DTOC of the date field.
If it's not broken, fix it until it is.
My Blog