I just tested this, and it does work when you create an index on the VAL() of the FormName field.
select str(formname, 10, 0) as FormName, "Desc" as Descript ;
from AcordFrm into cursor crsForms
sele crsForms
index on val(formname) tag formname
index on descript tag descript
Since DESC is a reserved word you may have problems. I would alias it in the SELECT command and use that instead.
>Is there a quick way to select from a table into another table and change the type from numeric to character during the process? In this form the listbox is simply used as a selection tool...
>
>Current Live fields in acordfrm table:
>
>acordfrm.desc c(50)
>acordfrm.formname n(10,0)
>
>Desired for testing in taccord table:
>
>acordfrm.desc c(50)
>acordfrm.formname c(10)
>
>Can't find anything like that in help - I've never done it. Is it possible without stepping through the table record by record and converting the values in the temporary table?
>
>TIA,
>Tracy
Mark McCasland
Midlothian, TX USA