Join error - Join error when created Options  Email this topic  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

mdumenil		#1 Posted : Thursday, August 27, 2020 5:15:41 PM(UTC)
Rank: Newbie Groups: Registered Joined: 8/27/2020(UTC) Posts: 7		I am unable to create a join whatever the tables. I still get an error. I am using an odbc data source to a 4D database. Please help me ! ERROR 08004 Server rejected the connection : Failed to execute statement however I manage to see the contents of the two tables without problem. I use version 5.5.0.0 of Seal Report
User Profile View All Posts by User View Thanks

	Wanna join the discussion?! Login to your Seal Report Forum forum accountor Register a new forum account.

epf		#2 Posted : Friday, August 28, 2020 6:19:51 AM(UTC)
Rank: Administration Groups: Administrators Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)		Sorry, no experience with 4D database... Check the SQL generated and adjust your join.
User Profile View All Posts by User View Thanks

mdumenil		#3 Posted : Monday, August 31, 2020 7:47:24 AM(UTC)
Rank: Newbie Groups: Registered Joined: 8/27/2020(UTC) Posts: 7		sql command is as follows, I don't see anything abnormal in the command : SELECT * FROM Absences INNER JOIN Absences_Seances ON Absences.No_Fiche = Absences_Seances.No_Fiche WHERE 0=1
User Profile View All Posts by User View Thanks

epf		#4 Posted : Monday, August 31, 2020 12:35:33 PM(UTC)
Rank: Administration Groups: Administrators Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)		Yes it seems correct, can you just cut/past the query in a Query Tool for a 4D database ?
User Profile View All Posts by User View Thanks

mdumenil		#5 Posted : Thursday, September 3, 2020 8:54:51 AM(UTC)
Rank: Newbie Groups: Registered Joined: 8/27/2020(UTC) Posts: 7		apparently it's the "WHERE 0 = 1" clause that is causing the problem
User Profile View All Posts by User View Thanks

epf		#6 Posted : Thursday, September 3, 2020 2:35:48 PM(UTC)
Rank: Administration Groups: Administrators Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)		it should be specific to 4D database...
User Profile View All Posts by User View Thanks

mdumenil		#7 Posted : Thursday, September 3, 2020 2:41:28 PM(UTC)
Rank: Newbie Groups: Registered Joined: 8/27/2020(UTC) Posts: 7		can you make sure not to put automatically clause "where 0=1" in join sql command
User Profile View All Posts by User View Thanks

epf		#8 Posted : Thursday, September 3, 2020 4:20:57 PM(UTC)
Rank: Administration Groups: Administrators Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)		could be a feature request to add this as an option for the connection... the 1=0 is used for checking tables, columns and getting the metadata. for restrictions we used 1=1. is there something else that works in 4D (like 'a' = 'b') ?
User Profile View All Posts by User View Thanks

mdumenil		#9 Posted : Tuesday, September 8, 2020 9:38:46 AM(UTC)
Rank: Newbie Groups: Registered Joined: 8/27/2020(UTC) Posts: 7		yes, thank you for adding this option in the next version of seal report so that I can use your software with my 4D databases
User Profile View All Posts by User View Thanks

epf		#10 Posted : Tuesday, September 8, 2020 10:06:21 AM(UTC)
Rank: Administration Groups: Administrators Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)		yes but can you tell me what should work with 4D database ?
User Profile View All Posts by User View Thanks

mdumenil		#11 Posted : Wednesday, September 9, 2020 8:20:10 AM(UTC)
Rank: Newbie Groups: Registered Joined: 8/27/2020(UTC) Posts: 7		in the clause below, il faut retirer la ligne "WHERE 0=1" SELECT * FROM Absences INNER JOIN Absences_Seances ON Absences.No_Fiche = Absences_Seances.No_Fiche WHERE 0=1
User Profile View All Posts by User View Thanks

Users browsing this topic

Guest (2)