SQL error message "The string returned by the builder was too long"
2 réponses
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;
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Sylvain Lafontaine
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" wrote in message 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;
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" <frederic10_mess@hotmail.com> wrote in message
news:43cbc2b3-eb5f-481c-8021-0a3b4ab32d12@t26g2000prh.googlegroups.com...
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;
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" wrote in message 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
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" wrote in message
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
Thank you Sylvain for your help! I`ve follow what you said and and my probloem is solved.
Thanks again, Fred's
On 16 jan, 19:12, "Sylvain Lafontaine" <sylvai...@community.nospam>
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" <frederic10_m...@hotmail.com> wrote in message
> 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
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" wrote in message
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
