Re: Increase field size


david@epsomdotcomdotau wrote:
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.

Rather than designating whole areas 'off limits', I prefer to be aware
of the limitations and see how far I can get.

From a practical point of view, I'd restrict my use of MEMO to things
like free text 'notes' for users i.e. I wouldn't want to UNIQUE, JOIN,
UNION, GROUP, SORT, etc but I would want to limit the length, restrict
the contents (allow Unicode and you will get Unicode <g>), etc.

You comments reminds me of something on Allen Browne's site
(http://allenbrowne.com/tips.html):

"These can ALL fail: PARAMETERS clause; SELECT clause; DISTINCT
predicate; FROM clause; WHERE clause; GROUP BY clause; ORDER BY clause.
Getting hard to write a query without considering the bugs?"

I realise his tongue is firmly embedded in his cheek but the point is
there are limitations and bugs throughout the product and you just have
to get on with things.

I could count on two fingers the number of new features in
Jet 4.0 that were actually useful

Ah yes, table-level CHECK constraints, the DECIMAL data type (including
native decimals), CASCADE in DRI, improved SQL DDL syntax (e.g. CREATE
PROCEDURE with default values for parameters), Unicode compression,
@@IDENTITY, ... sorry, did you say two fingers <g>?

Jamie.

--

.

Relevant Pages

  • Re: Establishing Precedence In ORDERBY Condition Causing Problems.
    ... tab4.login_date from (select distinct emailAddress from Users union ... I created the UserPrecedence table that describes the ordered ... ORDER BY CASE @sort ... The sp_ prefix is reserved for system procedures, and SQL Server first ...
    (comp.databases.ms-sqlserver)
  • Re: Changed fields
    ... The N just signifies that the string is Unicode. ... select 'insert into ChgMster' oneLine, ... union all' ...
    (microsoft.public.sqlserver.server)
  • RE: Query sort not working after NULL column
    ... There is no sorting in any of the queries except the last one. ... that and sort when the query is run from VB. ... UNION ALL but I'm sure that will complicate things even more and lead me to ... have to insert even another extra query to get rid of the duplicates. ...
    (microsoft.public.access.queries)
  • Union Select sorting
    ... hidden column if you wish to sort by it. ... >I'm having trouble sorting a Union Select query. ... like to sort on a hidden field, but from what I've read in ...
    (microsoft.public.access.queries)
  • Re: Dynamic ORDER BY
    ... you can stack case expressions to selectively sort (although it may ... required no dynamic SQL: ... > UNION ... >>> IT Consultant ...
    (microsoft.public.sqlserver.datamining)