Article View: borland.public.vdbase.data.sql
Article #777Re: SQL and GRID object
From: Ken Mayer [TeamB]
Date: Thu, 16 Jul 1998 00:00
Date: Thu, 16 Jul 1998 00:00
30 lines
1458 bytes
1458 bytes
"Doug MacKinnon" <dmack@home.com> wrote: >>Use a LONG in the FULFILLMENT table. >I have changed it because I'm obedient. But why would you suggest this? Is >it: >c) relation may not compare properly? > -from what I've tested it worked fine. This is the problem here. An AUTOINCREMENT field is in reality a LONG file with special properties. >d) scalability? > -I have 70,000 customers, increasing at about 3%/year; I'll be dead >before I need a width of 7, and then it would be easy to change anyway. The width of 4 is misleading -- a LONG can hold something like 2 billion ... I can't remember exact amounts, but you're not too likely to run out. Ken --- Ken Mayer [TeamB] Please respond in the newsgroup unless explictly asked otherwise Golden Stag Productions http://www.mindspring.com/~hirschv/homepage.htm http://www.mindspring.com/~hirschv/dbase/dbase.htm
Technical Details
Message-ID:
<35ad6f4f.891690@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6o9af8$rrh1@forums.borland.com> <MPG.101561dad72538f998af91@forums.borland.com> <6ojkar$71p11@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,9780f046f4c80b16 X-Google-Attributes: gidff5a1,public From: supportInfo@borland.com (Ken Mayer [TeamB]) Subject: Re: SQL and GRID object Date: 1998/07/16 Message-ID: <35ad6f4f.891690@forums.borland.com> X-Deja-AN: 371899385 References: <6o9af8$rrh1@forums.borland.com> <MPG.101561dad72538f998af91@forums.borland.com> <6ojkar$71p11@forums.borland.com> Organization: Golden Stag Productions Reply-To: teamb@opto-pps.com Newsgroups: borland.public.vdbase.data.sql