I think this bit looks dodgy..
"Get_Address" ('PST','C',cln."Ref_Number") adr
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Rohit Gupta
Sent: Thursday, 12 June 2003 4:10 p.m.
To: Multiple recipients of list delphi
Subject: [DUG]: SQL foolishness
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/
---------------------------------------------------------------------------
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/
