>>>>>>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.
Thank you. I will check this.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham