Re: MS Word/Query AS400 database error -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Jim,

I understand that this problem has been solved with SR-1 of Office 2000, but I 
can't 
say that for sure.  Microsofts support website reports the 255 character SQL 
limit as 
a problem between MSQuery & Word.

On 23 May 2003 at 22:52, Jim Franz wrote:

> Chris/Melinda - thanks for the tips. The joblog on 400 showed it was
> looking for a field name not in the table (the sql string was
> truncated at the 255 bytes?). I played with MS Query for hours trying
> to save a "Select * from ..." but every time I did that, upon re-open,
> all the fields were again in the Select statement. I took Melinda's
> advice and did MS-Query to Excel, and used Excel as the "get data". I
> will need to solve this in the future if you have any ideas how to get
> MS Query to behave. thanks jim ----- Original Message ----- From:
> "Chris Devous" <cdevous@xxxxxxxxxxx> To: "Midrange Systems Technical
> Discussion" <midrange-l@xxxxxxxxxxxx> Sent: Friday, May 23, 2003 1:17
> PM Subject: Re: MS Word/Query AS400 database error
> 
>

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.