Windows 7 - SQL error message "The string returned by the builder was too long"

Asked By Fred's on 16-Jan-09 04:47 AM
Hello,

I have this below SQL Statement and now when I try to add other other
fields from the table source, I have the following message: "The
string returned by the builder was too long
The Result will be truncated "

Does anyone knows how to solve this problem??
Thank you for your help!
Fred's


SELECT Source.[WMS Shipment #] AS SHIPMENT_NUM, Source.TRAILER_NUM,
Source.[Retek 9 PO] AS ORD_NUM, Source.[Old PO] AS PO_REF_NUM,
Source.ORDER_TYPE, Source.[PO Type], Source.Supplier AS VENDOR_NAME,
Source.Style AS VENDOR_STYLE, Source.[BQC approved], Source.[Merch
Type] AS Merch_Type, Source.MerchTypeDesc, Source.Division AS
DIVISION_DESC, Source.ITM_STYLE, Source.[AS400 Style #] AS
ITM_STYLE_DESC, Source.ITM_COLOR, Source.Color AS ITM_COLOR_DESC,
Source.SumOfREQUESTED_QTY, Source.QtyPreviousShipment,
Source.QtyScanned, Source.QtyUploaded, Source.BalanceToBeReceived,
Source.Allocation, Source.SumOfQTY_ORD, Source.SumOfORIG_QTY_ORD,
Source.[Transportation Record] AS Transportation,
Source.MaxOfDT_TM_CREATED, Source.AppointmentDate, Source.ArrivalDate,
Source.YardLocation, Source.[Date In], Source.WhseLocation, Source.
[Receiving scan date] AS MinOfDT_TM_RECV, Source.[Receiving Upload
date] AS MaxOfUPLOAD_DT_TM, Source.FlgRapportDesReceptions,
Source.FlgReadyToReceive, Source.Index, Source.[Priority as per
Michel's file], Source.[Shipment creation date], Source.[Issue ?],
Source.[Total Qty], Source.[Qty-Bulk Carton], Source.[Problem
details], Source.[Catalyst Clean?], Source.Subdivision, Source.
[Problem details1], Source.[Problem details2], Source.[Problem
details3], Source.[Problem details4], Source.[Problem details5],
Source.[Problem details6], Source.T1, Source.T2, Source.T3, Source.T4,
Source.T5, Source.T6, Source.T7, Source.T8, Source.T9, Source.T10,
Source.M01, Source.M02, Source.M03, Source.M04, Source.M05,
Source.M06, Source.M07, Source.M08, Source.M09, Source.M10,
Source.M11, Source.C01, Source.C02, Source.C03, Source.C04,
Source.C05, Source.C06, Source.C07, Source.C08, Source.C09,
Source.C10, Source.C11, Source.P01, Source.P02, Source.P03,
Source.P04, Source.P05, Source.P06, Source.P07, Source.P08,
Source.Q01, Source.Q02, Source.Q03, Source.[Nonconformity
Description], Source.YMS
FROM Source
ORDER BY Source.[WMS Shipment #], Source.[Retek 9 PO],
Source.ITM_STYLE, Source.ITM_COLOR;




Sylvain Lafontaine replied on 16-Jan-09 07:12 PM
It looks like that you have hit the limit of the query builder.  Try to
switch to the SQL view and directly enter your sql text or define an alias
for the table Source, for example S:

SELECT S.[WMS Shipment #] AS SHIPMENT_NUM, S.TRAILER_NUM,
S.[Retek 9 PO] AS ORD_NUM, S.[Old PO] AS PO_REF_NUM,
S.ORDER_TYPE, S.[PO Type], S.Supplier AS VENDOR_NAME,
S.Style AS VENDOR_STYLE, S.[BQC approved], S.[Merch
Type] AS Merch_Type, S.MerchTypeDesc, S.Division AS
DIVISION_DESC, S.ITM_STYLE, S.[AS400 Style #] AS
ITM_STYLE_DESC, S.ITM_COLOR, S.Color AS ITM_COLOR_DESC,
S.SumOfREQUESTED_QTY, S.QtyPreviousShipment,
S.QtyScanned, S.QtyUploaded, S.BalanceToBeReceived,
S.Allocation, S.SumOfQTY_ORD, S.SumOfORIG_QTY_ORD,
S.[Transportation Record] AS Transportation,
S.MaxOfDT_TM_CREATED, S.AppointmentDate, S.ArrivalDate,
S.YardLocation, S.[Date In], S.WhseLocation, S.
[Receiving scan date] AS MinOfDT_TM_RECV, S.[Receiving Upload
date] AS MaxOfUPLOAD_DT_TM, S.FlgRapportDesReceptions,
S.FlgReadyToReceive, S.Index, S.[Priority as per
Michel's file], S.[Shipment creation date], S.[Issue ?],
S.[Total Qty], S.[Qty-Bulk Carton], S.[Problem
details], S.[Catalyst Clean?], S.Subdivision, S.
[Problem details1], S.[Problem details2], S.[Problem
details3], S.[Problem details4], S.[Problem details5],
S.[Problem details6], S.T1, S.T2, S.T3, S.T4,
S.T5, S.T6, S.T7, S.T8, S.T9, S.T10,
S.M01, S.M02, S.M03, S.M04, S.M05,
S.M06, S.M07, S.M08, S.M09, S.M10,
S.M11, S.C01, S.C02, S.C03, S.C04,
S.C05, S.C06, S.C07, S.C08, S.C09,
S.C10, S.C11, S.P01, S.P02, S.P03,
S.P04, S.P05, S.P06, S.P07, S.P08,
S.Q01, S.Q02, S.Q03, S.[Nonconformity
Description], S.YMS
FROM Source as S
ORDER BY S.[WMS Shipment #], S.[Retek 9 PO],
S.ITM_STYLE, S.ITM_COLOR;

You can also drop the " AS ", as this will make your text even shorter.  In
fact, as you have only one table, you can even drop all these "S." or
tables have the same field with the same name.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
Fred's replied on 26-Jan-09 08:42 PM
On 16 jan, 19:12, "Sylvain Lafontaine" <sylvai...@community.nospam>
s
=A0In
more
=E9c=E9dents -

Thank you Sylvain for your help! I`ve follow what you said and and my
probloem is solved.

Thanks again,
Fred's