>I am wondering if ALTER TABLE (in code) on a table with about 1 million records may take a long time or even time out. Also, as I already wrote to Tore, I need to make sure that nowhere the code will break because it depends on NUMERIC() type.
>Thank you.
It should be relatively fast command,
In VFPP you should not do any changes. The int field is NUMERIC in VFP.
CREATE CURSOR aaa (fld1 I)
WAIT WINDOW TYPE("Fld1")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.