Re: [sqr-users] (SQR 5528) Error

[<bmrazek@sympatico.ca>]

I believe you need to move your DISTINCT up next to your SELECT

BEGIN-SELECT DISTINCT

bs.sample_type                   
 
bs.schedule_seq                  
 
etc...


Good Luck

Barb

> 
> From: "Happersberger. Rich (MSA)" <happersbergerr@SacCounty.NET>
> Date: 2004/05/05 Wed AM 11:45:02 EST
> To: <sqr-users@sqrug.org>
> Subject: [sqr-users] (SQR 5528) Error
> 
> 
> Hello -
> 
> I'm new to SQR, so hope to ask the correct questions -
> 
> Curious about the entries in the message below when it says
> "sc.queue=:1", etc.
> Does this indicate a collision of variables?
> 
> This query is part of a local procedure.
> 
> If the variables are hardcoded, this query will return stuff via
> SQLPlus.
> 
> 
> From the following Select I get the following error;
> 
> (SQR 5528) ORACLE OCIStmtExecute error 936 in cursor 5:
>    ORA-00936: missing expression
> SQL:  SELECT DISTINCT, bs.sample_type, bs.schedule_seq  FROM
> batch_schedules
>       bs, schedules sc, project_samples ps WHERE sc.schedule_id=ps.hsn
> and
>       sc.queue=:1 and sc.queue=bs.queue and bs.batch_number=:2 and
>       ps.project_seq=:3 and bs.sample_type IN (select sample_type from
>       hv$sample_type where sample_type_flag NOT IN ('0','9') )
> 
> 
> Error on line 227:
>    (SQR 3716) Error in SQL statement.
> 
> begin-select
> 
> DISTINCT
> 
> bs.sample_type                   
> 
> bs.schedule_seq                  
> 
> 
> FROM
> batch_schedules bs,
> schedules sc,
> project_samples ps
> 
> WHERE
> sc.schedule_id=ps.hsn
> and sc.queue=$_bs.Queue
> and sc.queue=bs.queue                            !LACH for test purposes
> and bs.batch_number=$_bs.BatchNumber               !1963 for test
> purposes
> and ps.project_seq=#_ProjectSeq                 !14666 for test purposes
> and bs.sample_type IN
> (select sample_type
> from hv$sample_type
> where sample_type_flag NOT IN ('0','9')
> )
> 
> end-select
> 
> Thanks to all -
> 
> Rich Happersberger
> Asst. Systems Administrator
> SRCSD Laboratory (MSA)
> 
> 
> 
> 
>___________________________________________________________________________________________________________
> This email and any attachments thereto may contain private, confidential, and 
>privileged material for the
> sole use of the intended recipient. Any review, copying, or distribution of 
>this email (or any attachments
> thereto) by other than the County of Sacramento or the intended recipient is 
>strictly prohibited.
> 
> If you are not the intended recipient, please contact the sender immediately 
>and permanently
> delete the original and any copies of this email and any attachments thereto.
> 
>___________________________________________________________________________________________________________
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users