>When SELECTing into a cursor, is there a way to convert to Integer? Int(MyNumericField) seems to create a field of type N(10).
>
>Hilmar.
No direct way. If you want to have Integer field, which is not in original table, you can do:
create cursor curTemp (MyIntField I)
insert 0 into curTemp
select * from myTable, curTemp into ...
Otherwise you have to ALTER TABLE after it's created.
If it's not broken, fix it until it is.
My Blog