Unique Constraint Failed, Why?
it at plastipol.com
Mon Sep 20 06:46:14 UTC 2021
Run the SQL code from "SQL Browser". Select the session and open an "Interactive Sql” window.
> El 18 sept 2021, a las 21:08, Das Goravani <goravanis at gmail.com> escribió:
>> On Sep 18, 2021, at 2:19 PM, Rob Mostyn <mostyn at platformis.net> wrote:
>> select primarykeycolumn, count(*)
>> from table
>> group by primarykeycolumn
>> having count(*) > 1
> I’m not familiar with doing SQL like that. I get that you want me to put in that SQL statement.. little details I don’t get exist..
> Like do you include that comma in the first line?
> And what would this do?
> And is “having” a SQL command word, usually capitalized?
> Do I fetch into a list?
> What should I expect to see?
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en