| FRM-30187 [message #248647] |
Fri, 29 June 2007 19:35  |
asterisk
Messages: 4
Registered: June 2007
|
Junior Member |
|
|
Hi,
I am getting this error when I tried to compile a standard form:
FRM-30187: Size of CHAR column in record group must be between 1 and 2000.
Record Group QF_TAXPAYER_ID
Form: ARXCUDCI
FRM-30085: Unable to adjust form for output.
Form not created
I changed a column in the record group QF_TAXPAYER_ID but the character is not more than 9 bytes.
Here is the original query:
select distinct c.cust_account_id,
party.jgzz_fiscal_code ,
substrb(party.party_name,1,50) party_name,
c.account_number,
party.tax_reference,
party.party_number,
party.party_id,
party.person_first_name,
party.person_last_name ,
c.account_name account_description
from hz_cust_accounts c,
hz_parties party
where c.party_id = party.party_id
and party.party_type = :ctrlcustomer_type
order by c.account_number
and here is the changed query:
select distinct c.cust_account_id,
trim(LPAD(substr(party.JGZZ_FISCAL_CODE,
length(party.JGZZ_FISCAL_CODE)-3,4),
length(party.JGZZ_FISCAL_CODE),'X')) jgzz_fiscal_code,
substrb(party.party_name,1,50) party_name,
c.account_number,
party.tax_reference,
party.party_number,
party.party_id,
party.person_first_name,
party.person_last_name ,
c.account_name account_description
from hz_cust_accounts c,
hz_parties party
where c.party_id = party.party_id
and party.party_type = :ctrl.customer_type
order by c.account_number
Can you please suggest what is wrong?
|
|
|
|
| Re: FRM-30187 [message #248889 is a reply to message #248647] |
Mon, 02 July 2007 10:29  |
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
|
Senior Member |
|
|
|
If the length(party.JGZZ_FISCAL_CODE) is <=3 you will get into trouble.
|
|
|
|
|
|
| Re: FRM-30187 [message #248898 is a reply to message #248889] |
Mon, 02 July 2007 10:53 |
asterisk
Messages: 4
Registered: June 2007
|
Junior Member |
|
|
I have a question?.......is it right to modify the standard form?....or shud i make changes in the custom.pll? or is it possible to change it from forms personlization?
|
|
|
|
| Re: FRM-30187 [message #249141 is a reply to message #248897] |
Tue, 03 July 2007 08:40 |
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
|
Senior Member |
|
|
| asterisk wrote on Mon, 02 July 2007 10:50 | why?.......
|
If you really cannot figure out why, then maybe you should not be touching production code.
|
|
|
|
|
|
| Re: FRM-30187 [message #252933 is a reply to message #252738] |
Fri, 20 July 2007 14:01 |
asterisk
Messages: 4
Registered: June 2007
|
Junior Member |
|
|
the form error does not show again as I realized i can't cant change the record query of the standard form, nor is the option available in forms personalization anymore. I know I have to change it in Custom.pll but dont know how?
Can you help me with that?
|
|
|
|
| Re: FRM-30187 [message #253187 is a reply to message #252933] |
Mon, 23 July 2007 01:32 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I have moved your query to the 'Applications' forum.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
