> Le 3 août 2018 à 18:36, Chip Scheide via 4D_Tech <[email protected]> a > écrit : > > I am trying to insure that all of my intended primary key fields - are > primary keys. > [...] > > Am I missing something?
Yes ;-) I think it's better to use structure xml description instead of SQL: <http://doc.4d.com/4Dv17/4D/17/EXPORT-STRUCTURE.301-3729506.en.html> This xml embeds more informations than SQL (4D is more than SQL, or different at least) and you get it all at once (one request to server) Two examples based on that command: • <https://blog.4d.com/detailed-analysis-database-structure/> • on 4DBB, search for "flatStructure" (off today, I can't paste a link), it's a component that gets xml, converts it to object, then reads table, fields, relations and indexes from it. -- 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:[email protected] **********************************************************************
