What sets the initial nexfieldid for a given form? For example, if I create a new form and add a new field and manually set the ID to XXXXX (and it's not in the reserved range and higher than any other field on the form), will that plus one become the next field ID?
Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, September 02, 2009 12:31 PM To: arslist@ARSLIST.ORG Subject: AW: New fields added becomes Core fields ** Kali, with the following sql statement you can set nextfieldid to a safe number. UPDATE arschema SET nextfieldid = (SELECT MAX(fieldid) FROM field WHERE field.schemaid =arschema.schemaid) + 1 where name = '<Name of your form>' After that you must restart your arserver. Kind Regards Conny ________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Kali Obsum Gesendet: Mittwoch, 2. September 2009 03:05 An: arslist@ARSLIST.ORG Betreff: Re: New fields added becomes Core fields ** Hi, The nextfieldid for that form is set to 23 (don't know how it happened). Is it safe to just manually set it to a certain id? How do i know what number is safe? Thanks! Regards, Kali ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Tuesday, 1 September 2009 2:49 PM To: arslist@ARSLIST.ORG Subject: AW: New fields added becomes Core fields ** Kali, check the field nextfieldid in arschema with the following sql statement. select name, nextfieldid from arschema In normal case the nextfieldid contains something like 5368709xx HTH Kind Regards Conny ________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Kali Obsum Gesendet: Dienstag, 1. September 2009 08:16 An: arslist@ARSLIST.ORG Betreff: New fields added becomes Core fields ** Hi, Everytime I add a new field in an existing form, the field is created as a Core field (DB id is set to 16,17,18 etc). Any ideas why this is happening? Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"