Record Not Available When Using Left Inner Join of files

bms1 · Jul 2, 2003

I have a browse on a parent file (Trips) using a left join on a child file
(Loads). I am using ABC template...I have the Trips as the primary file and
Loads as the secondary file. I also have the Trip file as part of the Other
Files. Randomly Clarion does not generate the correct SQL statement and I
receive Error(35) Record Not Available Errors. Is there a way to ensure that
Clarion generates the correct SQL at all times. I am using SQL 2000 as the
backened and 5.5h.

JShankar · Jul 2, 2003

Does both Tables have Primary (Unique) Keys and are the primary Key elements part of the browse display / Hot fields ? Since you have a Left Join does the Error appear only for those Trips without a Load? Have you traced the SQL generated using the SQL Profiler to see what is going wrong?

bms1 · Jul 3, 2003

Thank you...after tracing the SQL, the error does occur when a load is not assigned to a trip.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Record Not Available When Using Left Inner Join of files

bms1

Programmer

JShankar

Programmer

bms1

Programmer

Similar threads

Part and Inventory Search

Sponsor