Re: Increase field size

Tech-Archive recommends: Fix windows errors by optimizing your registry

But, at the risk of repeating my self :~), this feature is buggy,
and will return garbage characters from some queries. Do
not sort, group, join or union on a memo field if more than
one table is involved. Exercise discipline and good judgement
by not sorting or grouping even if only one table is involved.

I could count on two fingers the number of new features in
Jet 4.0 that were actually useful, and this is not one of them.

(david)

"onedaywhen" <jamiecollins@xxxxxxxxxx> wrote in message
news:1154351719.783722.325790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

onedaywhen wrote:
If you think "You cannot index it" still applies and "only the first
255 characters are used" then why do the following produce no errors in
creation and usage?

I'll answer my own question: because the text values are less than 255
characters!

No biggie, I just made a misstatement based on the inability to count
beyond 200 <g>.

Jamie.

--



.

Relevant Pages

  • Re: Looking for other themes in anime (and manga, if youd like)
    ... visitors could ask about anime series, OAVs and manga/doujinshi that featured other themes, character types and/or storylines. ... How many anime and/or manga feature the 'traditional' pantaloon-clad, wish-granting genie? ... dressed up as American characters (Shinobu as Wonder Woman, ...
    (rec.arts.anime.misc)
  • Re: Combine 12 seperate queries into 1
    ... MS Access MVP ... I want to be able to sort the releases like it was a date ... Run 12 seperate queries to evaluate the first 3 characters and then update ...
    (microsoft.public.access.queries)
  • Re: Looking for other themes in anime (and manga, if youd like)
    ... How many anime and/or manga feature the 'traditional' pantaloon-clad, ... I know that there was one in the anime series, Gokudo, that changed his ... the characters, not a temple guardian). ...
    (rec.arts.anime.misc)
  • Re: Why is my merge data being truncated?
    ... Is this what you would call a feature of Word or a limitation or a problem. ... characters appeared instead of the full data. ... >>ODBC option mimicked the OLE option, but the Converter ...
    (microsoft.public.office.misc)
  • Re: processing more than two files...
    ... First field of my data has maximum 9 characters and minimum 8 ... You can of course replace that GNU specific feature by operating on the ...
    (comp.lang.awk)