RE: Dynamic SQL Cursor Problem

["Wills, Mike N. (TC)" <MNWills@xxxxxxxxxxxxxx>]

Doh....I should of thought of that....thanks...

Mike Wills
IT Corporate Support
MNWills@taylorcorp.com
 


-----Original Message-----
From: Buck Calabro [mailto:Buck.Calabro@commsoft.net] 
Sent: Friday, June 15, 2001 9:54 AM
To: RPG400-L@midrange.com
Subject: RE: Dynamic SQL Cursor Problem


>C                   If        Vendor <> *Blanks                    
>C                   Eval      VendorSel = %TRIM(VendorSel) +       
>C                             ' WHERE VENDOR = :Vendor'        
>C                   EndIf                                          
>
>C/EXEC SQL                                                          
>C+ PREPARE S1 FROM :VendorSel           <<<<< SQLCOD = -312 
>C/END-EXEC                                                          

When you build your host variable :VendorSel you are creating the WHERE
clause like this: WHERE VENDOR equals ":Vendor" (the literal colon V e n d o
r.  I'm pretty sure this is the problem.  You should use the actual value of
Vendor instead of treating it like a host variable.  Only use host variables
in SQL statements, not in EVAL.

Buck Calabro
Commsoft; Albany, NY
Visit the Midrange archives and FAQ at http://www.midrange.com "...the
humourous man shall end his part in peace..."
  -- Hamlet Act II, scene ii

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---