Does anyone know why the first sql gives the error "No current record for fetch
operation" and the second one works (basically as long as I have a loj with anything
it
works)
select count (cln."Ref_Number") from
"Client_Main" cln
, "Get_Address" ('PST','C',cln."Ref_Number") adr
where cln."Status" = 'A'
order by cln."First_Name"
select count (cln."Ref_Number") from
"Client_Main" cln
left outer join "Client_Main" cl2 on cl2."Ref_Number" = cln."Ref_Number"
, "Get_Address" ('PST','C',cln."Ref_Number") adr
where cln."Status" = 'A'
order by cln."First_Name"
P.S. it looks wierd only because this is the smallest fragment that produces the
problem.
Regards
Rohit
=================================================================
=====
CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
PH (649) 489-2280
FX (649) 489-2290
email [EMAIL PROTECTED] or [EMAIL PROTECTED]
=================================================================
=====
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
