U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » ODBC Assertion failed

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: ODBC Assertion failed [message #55815 is a reply to message #55812]

Thu, 17 December 2020 15:06

JeyCi is currently offline

JeyCi
Messages: 69
Registered: July 2020

Member

Giorgio wrote on Thu, 17 December 2020 11:01

Violation of PRIMARY KEY

In any case it is the problem that should be solved at Server-side & SQL-statement better... before insertion check for Uniqueness in some Join or take Distinct Group_By - to assure that rows to be inserted are really unique - as PKs ought to be...
If I had a chance to meet some duplication of PKs - I would first make Query for them (with a help of Self-Join), to understand what rows are really problematic & how to correct input data, then make necessary corrections either manually or in code - to have correct data, filtered from duplications, and then try again to insert into DB...
SQL language has pretty enough stuff to deal with such situations - e.g. Triggers...
An attempt to insert 2 identical PKs into DB should be filtered somehow in the Query itself, not in application language... though of course the last is also possible - to check duplications in C++ before Insert Into DB - but it is not very convenient...

Best regards.

[Updated on: Thu, 17 December 2020 15:11]

Report message to a moderator

Send a private message to this user

[Message index]

		ODBC Assertion failed By: Giorgio on Thu, 17 December 2020 11:01
		Re: ODBC Assertion failed By: JeyCi on Thu, 17 December 2020 14:09
		Re: ODBC Assertion failed By: Giorgio on Thu, 17 December 2020 14:22
		Re: ODBC Assertion failed By: JeyCi on Thu, 17 December 2020 15:06
		Re: ODBC Assertion failed By: Giorgio on Thu, 17 December 2020 16:27
		Re: ODBC Assertion failed By: JeyCi on Thu, 17 December 2020 17:44
		Re: ODBC Assertion failed By: JeyCi on Fri, 18 December 2020 06:26
		Re: ODBC Assertion failed By: Giorgio on Fri, 18 December 2020 08:32
		Re: ODBC Assertion failed By: mirek on Fri, 18 December 2020 10:22
		Re: ODBC Assertion failed By: Giorgio on Fri, 18 December 2020 08:26
		Re: ODBC Assertion failed By: mr_ped on Fri, 18 December 2020 14:02
		Re: ODBC Assertion failed By: Giorgio on Mon, 21 December 2020 09:54
		Re: ODBC Assertion failed By: Giorgio on Tue, 22 December 2020 11:44
		Re: ODBC Assertion failed By: mirek on Tue, 22 December 2020 18:22
		Re: ODBC Assertion failed By: mirek on Tue, 22 December 2020 18:49
		Re: ODBC Assertion failed By: JeyCi on Wed, 23 December 2020 06:08
		Re: ODBC Assertion failed By: Giorgio on Wed, 27 January 2021 16:44
		Re: ODBC Assertion failed By: mirek on Wed, 27 January 2021 17:08
		Re: ODBC Assertion failed By: Giorgio on Thu, 28 January 2021 09:26
		Re: ODBC Assertion failed By: mirek on Thu, 28 January 2021 09:38
		Re: ODBC Assertion failed By: Giorgio on Fri, 12 February 2021 18:15
		Re: ODBC Assertion failed By: Giorgio on Fri, 21 May 2021 11:04
		Re: ODBC Assertion failed By: Giorgio on Tue, 25 May 2021 17:16
		Re: ODBC Assertion failed By: mirek on Tue, 08 June 2021 10:08
		Re: ODBC Assertion failed By: Giorgio on Thu, 10 June 2021 17:00
		Re: ODBC Assertion failed By: JeyCi on Mon, 21 December 2020 15:33
		Re: ODBC Assertion failed By: Giorgio on Mon, 24 May 2021 14:54

Previous Topic:	OleDBSession in Archive
Next Topic:	sqlite3 Custom Function in SqlExp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Wed Jun 25 07:28:01 CEST 2025

Total time taken to generate the page: 0.04540 seconds