logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
mdumenil  
#1 Posted : Thursday, August 27, 2020 5:15:41 PM(UTC)
mdumenil

Rank: Newbie

Groups: Registered
Joined: 8/27/2020(UTC)
Posts: 7
France, Metropolitan

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
epf  
#2 Posted : Friday, August 28, 2020 6:19:51 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 955
Switzerland

Thanks: 14 times
Was thanked: 160 time(s) in 154 post(s)
Sorry, no experience with 4D database...
Check the SQL generated and adjust your join.
mdumenil  
#3 Posted : Monday, August 31, 2020 7:47:24 AM(UTC)
mdumenil

Rank: Newbie

Groups: Registered
Joined: 8/27/2020(UTC)
Posts: 7
France, Metropolitan

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
epf  
#4 Posted : Monday, August 31, 2020 12:35:33 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 955
Switzerland

Thanks: 14 times
Was thanked: 160 time(s) in 154 post(s)
Yes it seems correct, can you just cut/past the query in a Query Tool for a 4D database ?
mdumenil  
#5 Posted : Thursday, September 3, 2020 8:54:51 AM(UTC)
mdumenil

Rank: Newbie

Groups: Registered
Joined: 8/27/2020(UTC)
Posts: 7
France, Metropolitan

apparently it's the "WHERE 0 = 1" clause that is causing the problem
epf  
#6 Posted : Thursday, September 3, 2020 2:35:48 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 955
Switzerland

Thanks: 14 times
Was thanked: 160 time(s) in 154 post(s)
it should be specific to 4D database...
mdumenil  
#7 Posted : Thursday, September 3, 2020 2:41:28 PM(UTC)
mdumenil

Rank: Newbie

Groups: Registered
Joined: 8/27/2020(UTC)
Posts: 7
France, Metropolitan

can you make sure not to put automatically clause "where 0=1" in join sql command
epf  
#8 Posted : Thursday, September 3, 2020 4:20:57 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 955
Switzerland

Thanks: 14 times
Was thanked: 160 time(s) in 154 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') ?

mdumenil  
#9 Posted : Tuesday, September 8, 2020 9:38:46 AM(UTC)
mdumenil

Rank: Newbie

Groups: Registered
Joined: 8/27/2020(UTC)
Posts: 7
France, Metropolitan

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
epf  
#10 Posted : Tuesday, September 8, 2020 10:06:21 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 955
Switzerland

Thanks: 14 times
Was thanked: 160 time(s) in 154 post(s)
yes but can you tell me what should work with 4D database ?
mdumenil  
#11 Posted : Wednesday, September 9, 2020 8:20:10 AM(UTC)
mdumenil

Rank: Newbie

Groups: Registered
Joined: 8/27/2020(UTC)
Posts: 7
France, Metropolitan

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
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.