Limit to Custom Screens
Hi guys,
Im having trouble with a custom screen which holds a customer questionnaire. There is about 60 questions with associated data fields to record the customers response.
The problem started yesterday when I added about another 16 questions and answer boxes. I had to create around 40 new fields to build these question into the screen.
Now when I add more fields, Im seeing other fields disappear from the screen and I suspect there is a limit to how many fields and be added to a customer screen.
You guys come across this issue before?
D
Im having trouble with a custom screen which holds a customer questionnaire. There is about 60 questions with associated data fields to record the customers response.
The problem started yesterday when I added about another 16 questions and answer boxes. I had to create around 40 new fields to build these question into the screen.
Now when I add more fields, Im seeing other fields disappear from the screen and I suspect there is a limit to how many fields and be added to a customer screen.
You guys come across this issue before?
D
ASKER
Here you go, is this what your after GMG?
ACCOUNTNO 20
ACTIONON 8
CALLBACKAT 8
CALLBACKON 8
CALLBKFREQ 3
CLOSEDATE 8
COMMENTS 65
LASTATMPAT 8
LASTATMPON 8
LASTCONTAT 8
LASTCONTON 8
MEETDATEON 8
MEETTIMEAT 8
NEXTACTION 65
PREVRESULT 65
U2NDINCLAB 10
U2NDLABEL 10
U5B 10
U5BANS 3
U5BSTRING 10
UA1BANKYRS 2
UA1BTTC 10
UA1DEPEND 10
UA1DOB 8
UA1JB 25
UA1JBEMPST 15
UA1JBHRS 5
UA1JBINCAA 10
UA1JBINCAF 15
UA1JBINCAS 25
UA1JBINCAY 3
UA1JBINCFQ 15
UA1JBINCGR 10
UA1JBINCPF 20
UA1JBMTHS 2
UA1JBSEACQ 3
UA1JBSEACY 2
UA1JBSEIPF 20
UA1JBYRS 2
UA1MAIDEN 15
UA1MARITAL 20
UA1MOTHERM 20
UA1ORA2 10
UA2BANKYRS 2
UA2BTTC 10
UA2DEPEND 10
UA2DOB 8
UA2JB 25
UA2JBEMPST 15
UA2JBFTPT 10
UA2JBHRS 5
UA2JBINCAA 10
UA2JBINCAF 15
UA2JBINCAS 25
UA2JBINCAY 3
UA2JBINCFQ 15
UA2JBINCGR 10
UA2JBINCPF 20
UA2JBMTHS 2
UA2JBSEACQ 3
UA2JBSEACY 2
UA2JBSEIPF 20
UA2JBYRS 2
UA2MAIDEN 15
UA2MARITAL 20
UA2MOBNUM 12
UA2MOTHERM 20
UA2WORKNUM 12
UA3ADD1 40
UA3ADD2 40
UA3ADD3 40
UA3BTTC 20
UA3CITY 30
UA3COUNTY 20
UA3DOB 8
UA3JB 25
UA3JBEMPST 15
UA3JBFTPT 10
UA3JBHRS 5
UA3JBINCAA 10
UA3JBINCAF 15
UA3JBINCAS 25
UA3JBINCFQ 15
UA3JBINCGR 10
UA3JBINCPF 20
UA3JBMTHS 2
UA3JBSEACQ 3
UA3JBSEACY 2
UA3JBSEIPF 20
UA3JBYRS 2
UA3MAIDEN 15
UA3MARITAL 20
UA3NAME 40
UA3PCODE 10
UA3PHONEHM 12
UA3PHONEMB 12
UA3PHONEWK 12
UA3TITLE 5
UA4ADD1 40
UA4ADD2 40
UA4ADD3 40
UA4BTTC 20
UA4CITY 30
UA4COUNTY 20
UA4DOB 8
UA4JB 25
UA4JBEMPST 15
UA4JBFTPT 10
UA4JBHRS 5
UA4JBINCAA 10
UA4JBINCAF 15
UA4JBINCAS 25
UA4JBINCFQ 15
UA4JBINCGR 10
UA4JBINCPF 20
UA4JBMTHS 2
UA4JBSEACQ 3
UA4JBSEACY 2
UA4JBSEIPF 20
UA4JBYRS 2
UA4JBYRSZ 2
UA4MAIDEN 15
UA4MARITAL 20
UA4NAME 40
UA4PCODE 10
UA4PHONEHM 12
UA4PHONEMB 12
UA4PHONEWK 12
UA4TITLE 5
UAGAPR 5
UAGBRKRCOM 8
UAGBRKRFEE 7
UAGBSERATE 4
UAGCHQPAY 50
UAGFISANO 10
UAGLGLCOST 7
UAGLNDRFEE 7
UAGLOANCOM 8
UAGLOANPLN 15
UAGMRGOVER 4
UAGMTHREPY 7
UAGMTHRTE 5
UAGNETLOAN 6
UAGNOMRATE 5
UAGPPPCOM 8
UAGPPPPREM 7
UAGPPPSWAP 3
UAGPPPTYPE 35
UAGSELLER 8
UAGTERM 3
UBK1 10
UBKAGECHEK 10
UBKAGETEST 10
UBKAPP1 10
UBKAPP2 10
UBKAPP2AGE 10
UBKARREARS 10
UBKCC 10
UBKDUPEAS 10
UBKDUPECK 10
UBKEMPLOY 10
UBKINCOME 10
UBKJBTYPE 10
UBKLM 10
UBKLOANAMT 10
UBKLTV 10
UBKLTV1 10
UBKPHONE1 10
UBKPRIVATE 3
UBKQ1 10
UBKQA1 3
UBKQA10 3
UBKQA10V 3
UBKQA11 3
UBKQA11V 3
UBKQA12 3
UBKQA12V 3
UBKQA13 3
UBKQA13V 3
UBKQA14 3
UBKQA14V 3
UBKQA15 10
UBKQA15P1 3
UBKQA15V 3
UBKQA16 10
UBKQA1V 3
UBKQA2 3
UBKQA2V 3
UBKQA3 3
UBKQA3V 3
UBKQA4 3
UBKQA4V 3
UBKQA5 3
UBKQA5V 3
UBKQA6 3
UBKQA6V 3
UBKQA7 3
UBKQA7V 3
UBKQA8 3
UBKQA8V 3
UBKQA9 3
UBKQA9V 3
UBKSSM 10
UBKTAA 10
UBKTIJ 10
UBKYESNO 10
UBLLLM 10
UBTTCQ 10
UCACCOUNTN 10
UCAPP 10
UCBALANCE 10
UCCOMPAN1 20
UCCOMPNAME 10
UCCONSUL 10
UCCREDIT1 6
UCCREDLIM 10
UCCURSTAT 10
UCHILDHOME 3
UCONCS1 3
UCPAYMENT 10
UCSETTEL 10
UCTERM 10
UCTOFCREDT 10
UCTYPEOFCR 20
UDATADATE 8
UDPAFUTURE 3
UDPAJOINT 3
UDPASINGLE 3
UDWQ16A 10
UDWQ31A 10
UDWQ36A 8
UDWQ42A 8
UDWTEST 10
UEMAIL2 10
UFOLPAYDAT 8
UHOMEOWNER 10
ULOANPURPS 20
UMARLABEL 10
UMEMA 10
UMEMQ 10
UMGARR24MT 8
UMGARREA24 3
UMGARREAA 8
UMGARREAAZ 8
UMGARREAY 3
UMGARRPRV 8
UMGARRPRVZ 8
UMGCOMPANY 40
UMGLST3PAY 3
UMGMTHREPY 7
UMGMTHREPZ 7
UMGMTHS 2
UMGOSBALNC 10
UMGOSBALNZ 10
UMGPREVCO 40
UMGSECCO 40
UMGSECOS 10
UMGSECOSZ 10
UMGSECREP 7
UMGSECREPZ 7
UMGSECY 3
UMGTYPE 15
UMGYRS 2
UMGYRSREM 2
UMGYRSREMZ 2
UMORTRENEW 10
UNBQ25D 40
UNBQ25D1 25
UNBQ25DA 8
UNBQ25E 20
UNBQ25F 20
UNBQ25F1 10
UNBQ25G 20
UNBQ25G1 10
UNBQ25G2 10
UNBQ25H 10
UNBQ25H1 10
UNBS10C 8
UNBSQ10C1 20
UNBSQ10D 20
UNBSQ10D1 10
UNBSQ10D2 8
UNBSQ10E 20
UNBSQ10F 20
UNBSQ10F1 8
UNBSQ10G 10
UNBSQ10G1 10
UNBSQ10G2 9
UNBSQ10H 20
UNBSQ10H1 10
UNBSQ17D 10
UNBSQ32D 10
UNBSQ36A 10
UNBSQ50B2A 10
UNBSQ56A2A 10
UNBSQ5A 10
UNBSQA5A 10
UNXTPAYDAT 8
UPENSIONQ 10
UPHONE4 10
UPRBEDROMS 2
UPRCNDISC 6
UPRCNDISCP 6
UPRCNDISCZ 6
UPRCNOWNED 3
UPRCNSITTN 3
UPRCNVAL 7
UPRCNVALZ 7
UPRCONSTCT 20
UPREVADD 10
UPREVARRE 10
UPRFLATFLR 2
UPRFLTBLD 13
UPRMTHATAD 2
UPROPJOINT 3
UPROPOWNRS 1
UPRPRVADD1 40
UPRPRVADD2 40
UPRPRVADD3 40
UPRPRVCITY 30
UPRPRVCNTY 20
UPRPRVPCDE 10
UPRPRVYRS 2
UPRPURCHDT 8
UPRPURCHPR 7
UPRPURCHPZ 7
UPRSECADD1 40
UPRSECADD2 40
UPRSECADD3 40
UPRSECCITY 30
UPRSECCNTY 20
UPRSECPCDE 10
UPRTITLENO 10
UPRTYPE 25
UPRVAL 7
UPRVALZ 7
UPRYRSATAD 2
UQ25CANS 10
UQ25TEXT 56
UQ32D 10
UQ42A 10
UQ5A1 10
UQ5AA1 10
UQ5AAAA 10
UQ5ANS 10
UQ5ANSA 10
USCORINGIT 10
USERDEF01 10
USERDEF02 10
USERDEF03 10
USERDEF04 10
USERDEF05 10
USERDEF06 10
USERDEF07 10
USERDEF08 10
USERDEF09 10
USERDEF10 10
UTIMEOD 20
UTOC1 10
UTOC10 10
UTOC11 10
UTOC12 10
UTOC14 10
UTOC15 20
UTOC16 10
UTOC17 10
UTOC18 10
UTOC19 10
UTOC1A 10
UTOC21 10
UTOC22 10
UTOC24 10
UTOC25 20
UTOC26 10
UTOC27 10
UTOC28 10
UTOC29 10
UTOC3 10
UTOC30 10
UTOC31 10
UTOC32 10
UTOC33 10
UTOC34 20
UTOC35 10
UTOC36 10
UTOC4 20
UTOC5 10
UTOC6 10
UTOC7 10
UTOC7A 10
UTOC8 10
UTOC8A 10
UTOC9 10
UUWA2MOB 10
UUWA2WORK 10
UWMORTXP 10
UWMORTXPA 8
ACCOUNTNO 20
ACTIONON 8
CALLBACKAT 8
CALLBACKON 8
CALLBKFREQ 3
CLOSEDATE 8
COMMENTS 65
LASTATMPAT 8
LASTATMPON 8
LASTCONTAT 8
LASTCONTON 8
MEETDATEON 8
MEETTIMEAT 8
NEXTACTION 65
PREVRESULT 65
U2NDINCLAB 10
U2NDLABEL 10
U5B 10
U5BANS 3
U5BSTRING 10
UA1BANKYRS 2
UA1BTTC 10
UA1DEPEND 10
UA1DOB 8
UA1JB 25
UA1JBEMPST 15
UA1JBHRS 5
UA1JBINCAA 10
UA1JBINCAF 15
UA1JBINCAS 25
UA1JBINCAY 3
UA1JBINCFQ 15
UA1JBINCGR 10
UA1JBINCPF 20
UA1JBMTHS 2
UA1JBSEACQ 3
UA1JBSEACY 2
UA1JBSEIPF 20
UA1JBYRS 2
UA1MAIDEN 15
UA1MARITAL 20
UA1MOTHERM 20
UA1ORA2 10
UA2BANKYRS 2
UA2BTTC 10
UA2DEPEND 10
UA2DOB 8
UA2JB 25
UA2JBEMPST 15
UA2JBFTPT 10
UA2JBHRS 5
UA2JBINCAA 10
UA2JBINCAF 15
UA2JBINCAS 25
UA2JBINCAY 3
UA2JBINCFQ 15
UA2JBINCGR 10
UA2JBINCPF 20
UA2JBMTHS 2
UA2JBSEACQ 3
UA2JBSEACY 2
UA2JBSEIPF 20
UA2JBYRS 2
UA2MAIDEN 15
UA2MARITAL 20
UA2MOBNUM 12
UA2MOTHERM 20
UA2WORKNUM 12
UA3ADD1 40
UA3ADD2 40
UA3ADD3 40
UA3BTTC 20
UA3CITY 30
UA3COUNTY 20
UA3DOB 8
UA3JB 25
UA3JBEMPST 15
UA3JBFTPT 10
UA3JBHRS 5
UA3JBINCAA 10
UA3JBINCAF 15
UA3JBINCAS 25
UA3JBINCFQ 15
UA3JBINCGR 10
UA3JBINCPF 20
UA3JBMTHS 2
UA3JBSEACQ 3
UA3JBSEACY 2
UA3JBSEIPF 20
UA3JBYRS 2
UA3MAIDEN 15
UA3MARITAL 20
UA3NAME 40
UA3PCODE 10
UA3PHONEHM 12
UA3PHONEMB 12
UA3PHONEWK 12
UA3TITLE 5
UA4ADD1 40
UA4ADD2 40
UA4ADD3 40
UA4BTTC 20
UA4CITY 30
UA4COUNTY 20
UA4DOB 8
UA4JB 25
UA4JBEMPST 15
UA4JBFTPT 10
UA4JBHRS 5
UA4JBINCAA 10
UA4JBINCAF 15
UA4JBINCAS 25
UA4JBINCFQ 15
UA4JBINCGR 10
UA4JBINCPF 20
UA4JBMTHS 2
UA4JBSEACQ 3
UA4JBSEACY 2
UA4JBSEIPF 20
UA4JBYRS 2
UA4JBYRSZ 2
UA4MAIDEN 15
UA4MARITAL 20
UA4NAME 40
UA4PCODE 10
UA4PHONEHM 12
UA4PHONEMB 12
UA4PHONEWK 12
UA4TITLE 5
UAGAPR 5
UAGBRKRCOM 8
UAGBRKRFEE 7
UAGBSERATE 4
UAGCHQPAY 50
UAGFISANO 10
UAGLGLCOST 7
UAGLNDRFEE 7
UAGLOANCOM 8
UAGLOANPLN 15
UAGMRGOVER 4
UAGMTHREPY 7
UAGMTHRTE 5
UAGNETLOAN 6
UAGNOMRATE 5
UAGPPPCOM 8
UAGPPPPREM 7
UAGPPPSWAP 3
UAGPPPTYPE 35
UAGSELLER 8
UAGTERM 3
UBK1 10
UBKAGECHEK 10
UBKAGETEST 10
UBKAPP1 10
UBKAPP2 10
UBKAPP2AGE 10
UBKARREARS 10
UBKCC 10
UBKDUPEAS 10
UBKDUPECK 10
UBKEMPLOY 10
UBKINCOME 10
UBKJBTYPE 10
UBKLM 10
UBKLOANAMT 10
UBKLTV 10
UBKLTV1 10
UBKPHONE1 10
UBKPRIVATE 3
UBKQ1 10
UBKQA1 3
UBKQA10 3
UBKQA10V 3
UBKQA11 3
UBKQA11V 3
UBKQA12 3
UBKQA12V 3
UBKQA13 3
UBKQA13V 3
UBKQA14 3
UBKQA14V 3
UBKQA15 10
UBKQA15P1 3
UBKQA15V 3
UBKQA16 10
UBKQA1V 3
UBKQA2 3
UBKQA2V 3
UBKQA3 3
UBKQA3V 3
UBKQA4 3
UBKQA4V 3
UBKQA5 3
UBKQA5V 3
UBKQA6 3
UBKQA6V 3
UBKQA7 3
UBKQA7V 3
UBKQA8 3
UBKQA8V 3
UBKQA9 3
UBKQA9V 3
UBKSSM 10
UBKTAA 10
UBKTIJ 10
UBKYESNO 10
UBLLLM 10
UBTTCQ 10
UCACCOUNTN 10
UCAPP 10
UCBALANCE 10
UCCOMPAN1 20
UCCOMPNAME 10
UCCONSUL 10
UCCREDIT1 6
UCCREDLIM 10
UCCURSTAT 10
UCHILDHOME 3
UCONCS1 3
UCPAYMENT 10
UCSETTEL 10
UCTERM 10
UCTOFCREDT 10
UCTYPEOFCR 20
UDATADATE 8
UDPAFUTURE 3
UDPAJOINT 3
UDPASINGLE 3
UDWQ16A 10
UDWQ31A 10
UDWQ36A 8
UDWQ42A 8
UDWTEST 10
UEMAIL2 10
UFOLPAYDAT 8
UHOMEOWNER 10
ULOANPURPS 20
UMARLABEL 10
UMEMA 10
UMEMQ 10
UMGARR24MT 8
UMGARREA24 3
UMGARREAA 8
UMGARREAAZ 8
UMGARREAY 3
UMGARRPRV 8
UMGARRPRVZ 8
UMGCOMPANY 40
UMGLST3PAY 3
UMGMTHREPY 7
UMGMTHREPZ 7
UMGMTHS 2
UMGOSBALNC 10
UMGOSBALNZ 10
UMGPREVCO 40
UMGSECCO 40
UMGSECOS 10
UMGSECOSZ 10
UMGSECREP 7
UMGSECREPZ 7
UMGSECY 3
UMGTYPE 15
UMGYRS 2
UMGYRSREM 2
UMGYRSREMZ 2
UMORTRENEW 10
UNBQ25D 40
UNBQ25D1 25
UNBQ25DA 8
UNBQ25E 20
UNBQ25F 20
UNBQ25F1 10
UNBQ25G 20
UNBQ25G1 10
UNBQ25G2 10
UNBQ25H 10
UNBQ25H1 10
UNBS10C 8
UNBSQ10C1 20
UNBSQ10D 20
UNBSQ10D1 10
UNBSQ10D2 8
UNBSQ10E 20
UNBSQ10F 20
UNBSQ10F1 8
UNBSQ10G 10
UNBSQ10G1 10
UNBSQ10G2 9
UNBSQ10H 20
UNBSQ10H1 10
UNBSQ17D 10
UNBSQ32D 10
UNBSQ36A 10
UNBSQ50B2A 10
UNBSQ56A2A 10
UNBSQ5A 10
UNBSQA5A 10
UNXTPAYDAT 8
UPENSIONQ 10
UPHONE4 10
UPRBEDROMS 2
UPRCNDISC 6
UPRCNDISCP 6
UPRCNDISCZ 6
UPRCNOWNED 3
UPRCNSITTN 3
UPRCNVAL 7
UPRCNVALZ 7
UPRCONSTCT 20
UPREVADD 10
UPREVARRE 10
UPRFLATFLR 2
UPRFLTBLD 13
UPRMTHATAD 2
UPROPJOINT 3
UPROPOWNRS 1
UPRPRVADD1 40
UPRPRVADD2 40
UPRPRVADD3 40
UPRPRVCITY 30
UPRPRVCNTY 20
UPRPRVPCDE 10
UPRPRVYRS 2
UPRPURCHDT 8
UPRPURCHPR 7
UPRPURCHPZ 7
UPRSECADD1 40
UPRSECADD2 40
UPRSECADD3 40
UPRSECCITY 30
UPRSECCNTY 20
UPRSECPCDE 10
UPRTITLENO 10
UPRTYPE 25
UPRVAL 7
UPRVALZ 7
UPRYRSATAD 2
UQ25CANS 10
UQ25TEXT 56
UQ32D 10
UQ42A 10
UQ5A1 10
UQ5AA1 10
UQ5AAAA 10
UQ5ANS 10
UQ5ANSA 10
USCORINGIT 10
USERDEF01 10
USERDEF02 10
USERDEF03 10
USERDEF04 10
USERDEF05 10
USERDEF06 10
USERDEF07 10
USERDEF08 10
USERDEF09 10
USERDEF10 10
UTIMEOD 20
UTOC1 10
UTOC10 10
UTOC11 10
UTOC12 10
UTOC14 10
UTOC15 20
UTOC16 10
UTOC17 10
UTOC18 10
UTOC19 10
UTOC1A 10
UTOC21 10
UTOC22 10
UTOC24 10
UTOC25 20
UTOC26 10
UTOC27 10
UTOC28 10
UTOC29 10
UTOC3 10
UTOC30 10
UTOC31 10
UTOC32 10
UTOC33 10
UTOC34 20
UTOC35 10
UTOC36 10
UTOC4 20
UTOC5 10
UTOC6 10
UTOC7 10
UTOC7A 10
UTOC8 10
UTOC8A 10
UTOC9 10
UUWA2MOB 10
UUWA2WORK 10
UWMORTXP 10
UWMORTXPA 8
what version of SQL?
your fields only come to 4742 in size so that shouldnt be a problem
I will do some further tests tonight when I am back home
your fields only come to 4742 in size so that shouldnt be a problem
I will do some further tests tonight when I am back home
ASKER
Im running SQL2005
I thought there was a cap on how many fields you could put on a single "screen."
I thought this also but also thought they had removed that in latest builds of 7 and PE
ASKER
@stevengraff - that what it appears to be, each time I add one field, another drop off the screen further up the screen.
I suspect you will need to split the questions across screens, its possible the limit was removed in PE but not 7
DJ reports in the Hacker's Guide (to Premium Edition) that you can have up to 250 fields per screen.
ASKER
Looks like my screen has 256 fields, time to trim it down I think.
If you have that many fields I would be considering why you need to work this way.
ASKER
@GMG
Its been an organic process which has gone on for over 10 yrs. The screen causing the problem is a New Business Questionnaire. Each time we get a new customer, our sales team run through this screen capture customer info into the fields. I guess we have finally found a limitation with this way of working, I think if they (my client) need any further questions added, we will have to build a 2nd Customer Screen to home the new question.
The real pain is, when I add new questions, they are never at the end of the questionnaire - they are always in the dam middle. So this means I have to manual move each field down to accommodate the new question/answer fields - its a hellish job!!
Its been an organic process which has gone on for over 10 yrs. The screen causing the problem is a New Business Questionnaire. Each time we get a new customer, our sales team run through this screen capture customer info into the fields. I guess we have finally found a limitation with this way of working, I think if they (my client) need any further questions added, we will have to build a 2nd Customer Screen to home the new question.
The real pain is, when I add new questions, they are never at the end of the questionnaire - they are always in the dam middle. So this means I have to manual move each field down to accommodate the new question/answer fields - its a hellish job!!
ASKER
Is there a easier way to count how many fields are in a particular custom screen?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Mmm, interesting. GMG and Steven first query brought up all the fields in the database but Stevens second script looks like its showing me the amount of fields in the various customer screens, here is the top 10 lines from the query. Would I be right in thinking the third line of these results is the customer screen Im working on and it has 289 fields?
D
000001 27
000002 13
100001 289
100002 75
100003 1
1CKEW7ZR)%Q;O W 100
1CKF968C*5%P5 W 88
1CKFTS5N%2/)I W 89
1CMRSMED%^AT> W 132
1CRNKAET%H+2*-? 27
D
000001 27
000002 13
100001 289
100002 75
100003 1
1CKEW7ZR)%Q;O W 100
1CKF968C*5%P5 W 88
1CKFTS5N%2/)I W 89
1CMRSMED%^AT> W 132
1CRNKAET%H+2*-? 27
Looks like a smoking gun to me.
ASKER
000001 27
000002 13
100001 247
100002 75
100003 1
Ive got it under 250 !! Hopefully I will now be able to set the tab order without fields disappearing.
000002 13
100001 247
100002 75
100003 1
Ive got it under 250 !! Hopefully I will now be able to set the tab order without fields disappearing.
ASKER
All sorted guys, happy to share the points?
fine with me
Sure!
ASKER
Thank you guys. Great job.
Please run this query
SELECT FIELD_NAME, FIELD_LEN
FROM CONTUDEF
WHERE DBFNAME = 'CONTACT2'
ORDER BY FIELD_NAME
and post your results
I suspect you have hit the maximum table width for SQL
Basically all the fields lengths in a table cannot exceed a certain size, I think this is about 8000 characters wide.
This query should show this