Re: Embedded SQL problem

[dslessman@xxxxxxxxxxxxxxxxxxxxxx]

Bruce,

Nothing.  The search will still not yield the proper results.

Dwight


                                                                                
                                  
                    "R. Bruce                                                   
                                  
                    Hoffman, Jr."            To:     <RPG400-L@midrange.com>    
                                  
                    <rbruceh@attgloba        cc:                                
                                  
                    l.net>                   Subject:     Re: Embedded SQL 
problem                                
                    Sent by:                                                    
                                  
                    owner-rpg400-l@mi                                           
                                  
                    drange.com                                                  
                                  
                                                                                
                                  
                                                                                
                                  
                    03/05/2001 06:11                                            
                                  
                    PM                                                          
                                  
                    Please respond to                                           
                                  
                    RPG400-L                                                    
                                  
                                                                                
                                  
                                                                                
                                  



-----Original Message-----
From: dslessman@nationalelectrical.com <dslessman@nationalelectrical.com>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Monday, March 05, 2001 5:40 PM
Subject: Embedded SQL problem


>Obviously I do not want to hardcode the search criteria.  When I add the
>following, the application should return the same information as above but
>it does not.
>C                   Eval      SearchValue = '10-1015%'
>C                   Eval      SearchValueH = SearchValue
>C                   Eval      SearchValue = '''' + %Trim(SearchValueH)+
>C                             ''''
>Does someone see the mistake I am making?
>


   what happens if you don't wrap the string with quotes?  ;-)


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"Those who would give up essential Liberty,
  to purchase a little temporary Safety,
  deserve neither Liberty nor Safety."

     - The Papers of Ben Franklin



+---
| 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
+---




+---
| 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
+---