sql string length

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using sql language to filter my database and I get an error message.
The message says that I have eexceeded the 1024 character length. Is ther a
way around this? It lets me run the sql statement and query, but is not very
happy about it.

Any ideas?
 
There's only one practical way for us to know: Show us the SQL. Open the
query in SQL view and copy and past it here. Information on primary keys and
relationships would be a nice touch too.

One trick is to use a shorter alias for the table names.

SELECT Karol.ORG, Karol.RECNUM, Max(Karol.EPISODE) AS MaxOfEPISODE
FROM Karol
GROUP BY Karol.ORG, Karol.RECNUM;

SELECT K.ORG, K.RECNUM, Max(K.EPISODE) AS MaxOfEPISODE
FROM Karol K
GROUP BY K.ORG, K.RECNUM;

Another somewhat sloppy method is to use * to output all the fields instead
of naming them.

SELECT *
FROM Karol ;
 
Hi,

You may have hit the maximum character in a single cell:

Number of characters in a cell in the query design grid:
1,024


It is under the topic "Access specifications" in the help file.


If the expression is that complex, try to split it in two cells, and use the
alias of the first column in the second column to continue the expression.

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top