Michael, At least you know that no changes will be involved if the release number goes into 4 digits if you use integers.
Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 23 January 2007 21:27 To: Profox Subject: Numeric(3) versus Integer field in VFP8/9 database table I need to add a column for "release #" in one of my tables. A numeric(3) would be plenty, but I wonder if I shouldn't just make it an integer and be done with it. I don't expect the field to be indexed, so I guess this is just silliness over 1 byte, eh? Can anyone name a valid reason why you'd make it INTEGER type instead of NUMERIC(3)? tia! --Michael -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [excessive quoting removed by server] _______________________________________________ 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 ** 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.
