Hi Matt
I having been using integer fields for a long time, for primary indexes and integer stuff. Never had a problem and i heard somewhere that they r faster and smaller than numeric fields. So, go ahead and make the change. E. I have several DBF tables where that I designed YEARS ago where I frequently used a lot of N(3) or N(5) field definitions, and somewhere along the way over the years, I started using simple Integer fields, which I kind of like better now, just because it seems more flexible and less rigid. It seems like your always taking a guess and limiting yourself when using N(x) field definitions. For example: using N(3) for an OrderQty field just because you assume no customer will ever order more than 999 copies of your booklet. Who knows, maybe someone will order 1,000 or even 10,000 one day. Now I am hoping to soon Upsize my tables to Sql Server, and I'm kind of tempted to just go ahead and switch all the N(3) and N(5) over to Integer fields before I do and just be done with it. Are there any pros or cons to my "old way" vs. my new plan to just use Integer fields everywhere? Also, I know that Sql Server has other Int options too, like "Small Int" and "Tiny Int". Seems tempting, but we don't have that in VFP, and I really want to do all my schema changes in VFP as much as I can before I push it over. By the way, most of the tables have less that 50,000 records, but a few have about 400,000 records. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/02f001cb4f15$7c7ee6b0$757cb4...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
