Hi Chip, Well, the message did say the index is invalid or missing, and it was in fact missing. I think it would be clearer if it told you which field though - too bad v13 is no longer being updated.
FWIW: In v14+ the index is automatically created for you once you re-launch the database: http://kb.4d.com/assetid=77432 And in v15: http://kb.4d.com/assetid=77335 But for v13, when it was released we tried to notify everyone about this change via multiple channels: http://kb.4d.com/resources/inug?msgid=GmailId14596165817e9cb5 http://forums.4d.fr/Post/EN/14523766/1/14523767#14523767 We specifically suggested that people run some code that would solve this issue: " either create an index (http://kb.4d.com/assetid=77023) or remove the unique attribute (http://kb.4d.com/assetid=77024). " Moving forward, I don't think you will run in to the problem once you get to the currently supported version of 4D (v14 or v15). I hope this helps. -Tim -----Original Message----- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide Sent: Wednesday, August 17, 2016 10:20 AM To: 4D iNug Technical Subject: [Error message] RE: v13 - Can not add record & Maintenance issues As a suggestion... a clearer error message might be in order... something like: Hey stupid! you forgot to index your unique field(s) <field name(s)>. Can not save the record until either there is an index, or the unique property has been removed. Alternatively (and maybe v15 does this) if the unique property is set, an index is automatically added. Chip ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************