Page 1 of 1
LEFT JOIN MS SQL
Posted: Sun Sep 07, 2003 1:30 pm
by Guy
Hello,__I have a problem with LEFT join on a report with r&r sql edition. __A error say that ms sql can^t join a externe because it^s use in intern. Why ? i don^t understand, i just want records in fileA who exist or not in fileB. I have a relationship many to one. This report work fine in xbase edition. What^s happens ?__sorry for my english so poor ?__Thanks
=> RE: LEFT JOIN MS SQL
Posted: Mon Sep 08, 2003 3:00 pm
by kfleming
If your report has just two tables, this should work. However with more than one join in the report you may indeed run into problems.____Kathleen__R&R Support
==> RE: LEFT JOIN MS SQL
Posted: Wed Sep 10, 2003 1:08 am
by Guy
Kathleen, with two tables it^s ok. But how can i do with my report with 4 relations ? It^s very strange because with rsw.exe (designer) when i preview the report it^s ok, but when i integrate my report with my application and i use rswrun.exe (runtime) i have a report of jointure. The same report with only 2 tables all is ok designer and runtime !__What^s happens with runtime ?__Guy
===> RE: LEFT JOIN MS SQL
Posted: Wed Sep 10, 2003 1:13 am
by Guy
Kathleen, with two tables it^s ok. But how can i do with my report with 4 relations ? It^s very strange because with rsw.exe (designer) when i preview the report it^s ok, but when i integrate my report with my application and i use rswrun.exe (runtime) i have a ERROR of jointure. The same report with only 2 tables all is ok designer and runtime !__What^s happens with runtime ?__Guy__sorry 2 msg because there had a error
====> RE: LEFT JOIN MS SQL
Posted: Wed Sep 10, 2003 7:17 am
by kfleming
Are you running runtime from a different directory than the designer? If so copy the file RSWSQL.INI from the designer directory to the runtime directory.____Kathleen__R&R Support
=====> RE: LEFT JOIN MS SQL
Posted: Sat Sep 13, 2003 9:18 am
by Guy
rswsql.ini is in runtime directory.__In fact when i use a relation A==>B and B=>C i have a error but if i use a relation A=>B and A=>C it^s ok __it doen^t like the 2 relations indeep in designer mode and runtime mode. How can i do this ? I need it ? I have a lot of reports with this configuration !__thanks Guy__
======> RE: LEFT JOIN MS SQL
Posted: Sat Sep 13, 2003 4:07 pm
by kfleming
You could create a view table in the database and then have R&R report against that view.__Or you could create a User SQL report in R&R where you would write the SELECT statement.____Kathleen__R&R Support
=======> RE: LEFT JOIN MS SQL
Posted: Sun Sep 14, 2003 11:21 am
by Guy
hummm the solution is not very engaging !