On Thu, Sep 8, 2011 at 7:29 PM, Lew Schwartz <lew1...@gmail.com> wrote:
> I thought everything else was quirky and Fox was normal. Fox was Dr. Dave's best approximation of what Wayne Ratliff's second attempt at a database language should be. There's hardly another DBMS with phantom records, negative RECNO()'s, DELETE/RECALL, etc. But don't feel like we're a poor stepchild. Oracle is a horrible mess. MS completely rewrote all the bugs in Sybase SQL Server - a Microsoft/Sybase/Ashton-Tate joint project -- to make the bugs their own. MySQL has gone through several owners and directions. We're all bozos on this bus. - Frank Zappa > It seems that > Access distinguishes between a column definition and the data that in > it, ie a col c, 5 will have a data width of 0, 1, 2, 3, 4 or 5 > depending on what, if anything is in it. > > How do they create compound keys where col widths & not data widths > are significant? By padding to the maximum column length? I can't think of another solution. Of course, if they're building B+ trees, they're really only storing incremental diffs of the key values within the tree. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: ProFox@leafe.com 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/cacw6n4vqkkcs8wvwbb2jutbn_-ziuwyfexchxxhyfo3knyn...@mail.gmail.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.
