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

Le
Fred's
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;
Vidéos High-Tech et Jeu Vidéo
Téléchargements
Vos réponses
Gagnez chaque mois un abonnement Premium avec GNT : Inscrivez-vous !
Trier par : date / pertinence
Sylvain Lafontaine
Le #18406741
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
"Source." . Naming the table for a field is only necessary when two or more
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" news:
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;


Fred's
Le #18490761
On 16 jan, 19:12, "Sylvain Lafontaine" wrote:
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 alia s
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
"Source." .  Naming the table for a field is only necessary when two or more
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"
news:



> 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;- Masquer le texte des messages pr écédents -

- Afficher le texte des messages précédents -



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

Thanks again,
Fred's
Publicité
Poster une réponse
Anonyme