>>>>>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.
VFP code that uses FSIZE() (to determine number of digits) may break.