I am trying to get multiple joins to return data (in HTML). So far I have three joins which seem to be fine, until I try to print a couple of fields from the last table joined. That's when I get the error "No query information to decode" in IE8.
I had it working before, but then I tried to add a fourth join (which gave me the same error) and now I can't get back to the working version with 3 joins.
Below is the current version of the procedure with the three joins (sorry for the length):

  -* File newfextest.fex
SET EMPTYREPORT = ON
SET BYDISPLAY = OFF
-SET &ECHO=ALL;
SET TRACEOFF=ALL
SET TRACEON=SQLTRANS
SET TRACEON=STMTRACE//CLIENT
SET TRACEON=SQLAGGR//CLIENT
SET TRACEUSER=ON
-* XRETRIEVAL OFF DOES NOT RETURN DATA
SET XRETRIEVAL=ON
SET LINES=9999

JOIN
 RPT_INCIDENT.RPT_INCIDENT.INCIDENT_ID IN RPT_INCIDENT TO MULTIPLE
 RPT_CONTRA.RPT_CONTRA.INCIDENT_ID IN RPT_CONTRA AS J0
 END
JOIN
 RPT_CONTRA.RPT_CONTRA.CONTRA_ID IN RPT_INCIDENT TO MULTIPLE
 RPT_CONC.RPT_CONC.CONTRA_ID IN RPT_CONC AS J1
 END
JOIN
 RPT_INCIDENT.RPT_INCIDENT.INCIDENT_ID IN RPT_INCIDENT TO MULTIPLE
 RPT_VEHICLE.RPT_VEHICLE.INCIDENT_ID IN RPT_VEHICLE AS J2
END
-*  VEHICLE_MAKE AS 'VEHICLE MAKE'  ** If I try and print these, I get the No query error
-*  VEHICLE_MODEL AS 'VEHICLE MODEL'
TABLE FILE RPT_INCIDENT
PRINT
  METHOD_CONC AS 'METHOD CONC'
  CONC_TYPE AS 'CONC TYPE'
  CONTRA_TYPE AS 'CONTRA TYPE'
BY REMARKS
BY INCIDENT_ID
HEADING
"Join Test"
FOOTING
""
ON TABLE SET PAGE-NUM ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=DATA,
     SIZE=8,
     BACKCOLOR=( RGB(234 234 255) 'WHITE' ),
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     SIZE=9,
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=HEADING,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     SIZE=14,
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=FOOTING,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     SIZE=9,
     COLOR='WHITE',
     BACKCOLOR=RGB(147 172 219),
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=ACROSSTITLE,
     SIZE=8,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     SIZE=9,
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N1,
     WRAP=3.000000,
$
ENDSTYLE
END

This message has been edited. Last edited by: Kerry,

The first thing that I would do is check the contents of the 3rd table. Check to see if a single value of the join field in the incident table occurs in the vehicle table. If there isn't a match, that may be one problem

Also when you get the error message, do a view source on the browser to see if there are any hidden error messages.

Also because you have a multipath join, one parent and two siblings, try only joining the first and third file with the extra fields to see if you can get them.

Where is the REMARKS field located in the join structure, in the parent or one of the kids?

Lots of things to consider, huh?

I tried the suggestions, but they didn't help me. However, once I added the following lines, I started getting data back:

WHERE READLIMIT EQ 5000
WHERE RECORDLIMIT EQ 5000  

Thanks!
Theresa

Have you tried turning SQL traces on? This helps enormously when joining multiple DBMS tables. Please search for SQL TRACING in this forum.