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 >> > > > >
