Re: Embedded SQL problem

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

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