> Le 18 sept. 2019 à 18:43, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > ID is a reserved word in sql so if that’s the name of your field you need to > escape it (I use brackets in 4D).
I don't like having to use brackets, I always change reserved names in tables and fields - I run code like this until none found: <https://forums.4d.com/Post/FR/14532263/1/14536260#14536260> I use "PK" for primary key and "FK_[tableOneName]" for foreign key. I have a friend whose initials are PK, he found that awesome. To query with array, another solution: <https://forums.4d.com/Post/FR/13701036/1/13701037#13705082> -- Arnaud de Montard ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************