sorry did not have my coffe
figure it is beyond my knowledge at this point.
:)
BJ Freeman sent the following on 1/11/2008 9:48 AM:
> this looks like a field type definition is messed up.
> which DB are you using.
>
> Case Torres sent the following on 1/11/2008 9:08 AM:
>> Hi,
>>
>> Release 4, version: 602199
>>
>> I was trying to create a note for a party in party manager and received the
>> error below.
>> The two fields to be filled in are "Note Id" and "Note".
>> The Note Id form field is 25 chars long, with no max set but the database
>> field is set at 20 chars so the user gets an ugly sql error message.
>> It seems the easiest fix is to make the form field max 20 chars but I'm not
>> sure how to do this given the following form code.
>>
>> Any suggestions??? Thanks, Case
>>
>> <form name="AddPartyNote" type="single" target="createPartyNote"
>> focus-field-name="noteId">
>> <auto-fields-service service-name="createPartyNote"/>
>> <field name="partyId"><hidden/></field>
>> <field name="note"><textarea cols="70" rows="10"/></field>
>> <field name="submitButton" title="${uiLabelMap.CommonSave}"
>> widget-style="smallSubmit"><submit button-type="text-link"/></field>
>> <field name="cancelLink" title=""
>> widget-style="smallSubmit"><hyperlink
>> target="${donePage}?partyId=${partyId}" also-hidden="false"
>> description="${uiLabelMap.CommonCancelDone}"/></field>
>> </form>
>>
>>
>>
>> ------
>> SQL ERROR:
>>
>> Problem associating note with party "Exception while inserting the following
>> entity: [GenericEntity:PartyNote][createdStamp,2008-01-10
>> 13:07:25.774(java.sql.Timestamp)][createdTxStamp,2008-01-10
>> 13:07:25.773(java.sql.Timestamp)][lastUpdatedStamp,2008-01-10
>> 13:07:25.774(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-10
>> 13:07:25.773(java.sql.Timestamp)][noteId,New product
>> discussion(java.lang.String)][partyId,12692(java.lang.String)] (while
>> inserting: [GenericEntity:PartyNote][createdStamp,2008-01-10
>> 13:07:25.774(java.sql.Timestamp)][createdTxStamp,2008-01-10
>> 13:07:25.773(java.sql.Timestamp)][lastUpdatedStamp,2008-01-10
>> 13:07:25.774(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-10
>> 13:07:25.773(java.sql.Timestamp)][noteId,New product
>> discussion(java.lang.String)][partyId,12692(java.lang.String)] (SQL
>> Exception while executing the following:INSERT INTO public.PARTY_NOTE
>> (PARTY_ID, NOTE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
>> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (ERROR: value too
>> long for type character varying(20))))".
>>
>> ---
>>
>>
>
>
>
>
