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

Wed Feb 4 23:20:23 CST 2009

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!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008