Le 28/03/2015 18:58, Lewis Balentine a écrit : > I have over three decades of dealing with SQL and I can still not > understand how this myth got propagated. > > There is NO valid SQL reason why a table should be required to have a > unique primary key or any predefined key for that matter. One can always > use the row number (record number) if such a key is required for one's > application. >
The row number does not exist in all database systems (more precisely, it is not accessible to the outside), so I can't rely on that feature to identify a row uniquely. Maybe the row id is not standard SQL, if "standard SQL" has any meaning. Consequently, I need a unique index, usually the primary key. If you can tell me how to get the row id of a row in MySQL, PostgreSQL and SQLite (mabe it has changed since the last time I looked at it), I will reconsider my position. :-) Regards, -- Benoît Minisini ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user