>>>>>>>Hi,
>>>>>>>
>>>>>>>I am trying to write a code (in a .prg) that would change a SQL Server column size from numeric(3,0) to numeric(6,0). But I can't.
>>>>>>>Anyone can suggest a code to make such a column size change?
>>>>>>
>>>>>>ALTER TABLE (?)
>>>>>>
https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql>>>>>
>>>>>Thank you. I will need to, first, create a t-sql command that will be used to check if the column is numeric(3,0) or (6,0). Then to ALTER the table.
>>>>
>>>>No need to write much code.
https://www.vfphelp.com/vfp9/_5wn12psb4.htm>>>>
>>>>In your case I don't recommend numeric(6,0), use Integer in stead.
>>>
>>>I agree that having the type integer would be better. But I need to make sure that the code won't break somewhere.
>>>Thank you.
>>
>>I can't imagine a case where that change can break anything.
>
>My code breaks all imaginations lol
Well done...! :-)