Hello All,
In one of my Application,there is a form that contains more than 2000+ fields on it.Till now it was working fine but now I am experiencing some serious error :
(a) when I replicate the Db to the server copy ,I can’t replicate and a error comes stating field size exceeds 32k limit or view selection formula is too large .
(b) I can’t check in the form in the CIAO and get a error message that too many fields on a form.
This form already ahve many subforms with each containing huge number of fields.
I think splitting the form into multiple forms might help me resolving the issue ,but don’t know about the exact approach .
Please let me know the detail procedure to do the same or somebody if have better idea it would be highly appreciated.
Thanks in advance
Nitin
Subject: Split a form into Multiple forms
Hey Nitin… I presume you are my old colleage in Prestige Towers.
Better extract the data size of the all the fields and check whether any issue with the data(exceeding 32KB).
Then split the data across 2 fields…
Let me know. this works
Subject: RE: Split a form into Multiple forms
Hey Mahesh…you got it right…I am same Nitin Jain…Great to see that like before you are again standing in my front to help me out solving the issue…
I had thought the same what you have suggested,but was searching for the smarticon which you once had used to extract all the fields from a form and it’s size…Do you have it still…
wha’s your email id by the way ,I can contact you directly then,
Thanks . 
Subject: RE: Split a form into Multiple forms
I had the smarticon , but not now.I presume the EMEA Scorecard is moved to oracle Database.
To get the collection of the fields in the doccument.
you can see the designer help for
@DocFields and DocFields in LS