Nope, it's actually more like the opposite of what the old Fox did, ie a col defined as
name (c,10) returns "BOB " for 'BOB" in good, ole Fox whereas in Access, the value is just "BOB" as though all character fields are the new varchar Fox type. So my user has a problem trying to cook up a compound lookup scheme, because all empty character cols are treated as empty strings, ie they seem to disappear. On Thu, Sep 8, 2011 at 7:43 PM, Jarvis, Matthew <[email protected]> wrote: >> -----Original Message----- >> From: [email protected] > [mailto:[email protected]] >> On Behalf Of Lew Schwartz >> Sent: Thursday, September 08, 2011 4:30 PM >> To: [email protected] >> Subject: Re: MS Access quirky import >> >> I thought everything else was quirky and Fox was normal. 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? >> > > > IIRC the Fox does something similar when you do a SELECT - the first > value in a field it finds will define the width (or precision) of all > the rest... > > Or am I just confused with something else? > > > Thanks, > > Matthew Jarvis || Business Systems Analyst > IT Department > McKenzie-Willamette Medical Center > 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: > 541-744-6145 > > -------------------------------------------------------------------------- > Disclaimer: This electronic message may contain information that is > Proprietary, Confidential, or legally privileged or protected. It > is intended only for the use of the individual(s) and entity named > in the message. If you are not an intended recipient of this > message, please notify the sender immediately and delete the > material from your computer. Do not deliver, distribute or copy > this message and do not disclose its contents or take any action in > reliance on the information it contains. > [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 Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cafuu78dvvu28hbee-fyq_ymszqusqbnjaiohq7yuiweb3tw...@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.
