Hey! Long time since I've been around. I am back w...

[Ken Langendock]

Welcome back.

I am not sure exactly what you are trying to achieve, but I have a screen
were the user can change the way in which records are retrieved. I use a
UNION ALL with a temporary variable to make this work.

Maybe this would work in your case.

Ken

@if ORACLE
SQL &
   DECLARE TransferLocationsCursor CURSOR FOR &
    SELECT TransferLocations.TransferLocation, &
           TransferLocations.Description, &
           TransferLocations.TransferLocation AS SortField &
      FROM TransferLocations &
     WHERE 'C' = :T-LookupOption &
    UNION ALL &
    SELECT TransferLocations.TransferLocation, &
           TransferLocations.Description, &
           TransferLocations.Description AS SortField &
      FROM TransferLocations &
     WHERE 'C' <> :T-LookupOption &
  ORDER BY SortField

CURSOR TransferLocationsCursor PRIMARY &
       ALIAS TransferLocations &
       OCCURS 17
  ACCESS SEQUENTIAL
@else
FILE TransferLocations PRIMARY &
     OCCURS 17
  ACCESS VIA TransferLocation &
         SEQUENTIAL
@endif


-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Karen Barrett
Sent: February 5, 2009 12:20 AM
To: PowerhouseList Post
Subject: [Bulk] Hey! Long time since I've been around. I am back w...


Hey! Long time since I've been around. I am back with an old employer doing
PH again. Some of you may remember Darren Reely at Lattice in Oregon, I'm
his replacement. I found a posting of his from the 2005 archives on
something like a dynamic where clause for an SQL cursor.  Has this thread
continued elsewhere? 
I'm working up a search screen with 8 criteria OR one of 3 ranges. Is there
a simple way to load a variable with the where values and then open the
cursor using the value? I see the code that Darren refers to for the 2005
post and I can MAKE it work but it won't be pretty.

It's good to be back!

Karen Barrett

(The long and winding road...)
Lattice Semiconductor 2007-
Willamette Dental 2001-07
Triquest Plastics 1997-99
Lattice Semiconductor 1995-97

_________________________________________________________________
Get more out of the Web. Learn 10 hidden secrets of Windows Live.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!55
0F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008
-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.552 / Virus Database: 270.10.18/1935 - Release Date: 04/02/2009
4:35 PM
 

No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.552 / Virus Database: 270.10.18/1935 - Release Date: 04/02/2009
4:35 PM