But there is not a note id field in the trunk version. Case Torres [EMAIL PROTECTED]
> -----Original Message----- > From: BJ Freeman [mailto:[EMAIL PROTECTED] > Sent: Friday, January 11, 2008 3:16 PM > To: [email protected] > Subject: Re: Creating party_note, note_id error > > no, > if it is null it will autosign a ID > but leave the ability to assign an ID. > I would put a jira in for the 25 char display on the widget > but 20 char for the ID not sure where the bug is. > > > Case Torres sent the following on 1/11/2008 2:46 PM: > > I guess I'll just comment out the note_id field in the form. > > But this field should be eliminated from the from in the Release 4 > > version, no? > > > > Thanks, Case > > > > Case Torres > > [EMAIL PROTECTED] > > > > > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > >> Sent: Friday, January 11, 2008 11:49 AM > >> To: [email protected]; [EMAIL PROTECTED] > >> Subject: RE: Creating party_note, note_id error > >> > >> Case > >> > >> I looked at this a while ago and as I recall, the noteid > is created > >> for you if you pass null. I seem to remember submitting a > jira which > >> removed the notid field from the UI so this happens. > >> > >> Skip > >> > >> -----Original Message----- > >> From: Case Torres [mailto:[EMAIL PROTECTED] > >> Sent: Friday, January 11, 2008 9:08 AM > >> To: [email protected] > >> Subject: Creating party_note, note_id error > >> > >> > >> 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))))". > >> > >> --- > >> > >> > >> No virus found in this incoming message. > >> Checked by AVG Free Edition. > >> Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release > >> Date: 1/5/2008 > >> 11:46 AM > >> > >> No virus found in this outgoing message. > >> Checked by AVG Free Edition. > >> Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release > >> Date: 1/5/2008 > >> 11:46 AM > >> > > > > > > > > >
