Hi,
I am planning to change a field type in one of the tables from NUM 6,0 to INT. The reason is that when I make this database in SQL Server I would want this field/column to be Identity column. So in SQL Server it would have to be Int type. I currently use this field (in VFP) just like an Identity. I have a routine that sets and gets the latest value in a PK table. So each record in the table has a unique value. And no decimal is used.
My question is (and I realize that not knowing the application it is difficult for anybody to answer definitively) is there a place in the code that such change would have a negative effect? Any suggestions would be greatly appreciated.
"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