Recent content by Ken Pawluk

I just re-read my message, and it doesn't make sense to me either. Sorry for the confusion. Let me try to clarify. I have a TOracleDataSet with SQL as follows: ----------------------- select um_item_desc.*, um_item_desc.rowid from UM_ITEM_DESC where (item_desc = :s_item_desc and item_code_char...

I'm new to Oracle and SQL so bear with me... I have a function that uses 3 variables (string1, string2, integer1). I use this function in one portion of code using all 3 variables. Great. Now, what if I wanted to use it from somewhere else, but only give it 2 parameters and ignore the 3rd...

thx, works great. Knew it couldn't be complicated. Just started with SQL so... Ken

I need to have a query such as: select * from WHATEVERTABLE where column1 = :variable1 and column2 = :variable2 except that either (not both) column can be null. ie: Column1 = 'Hello' Column2 = NULL When I setvariable(variable2,''), it fails (probably needs to be 'variable2 is null' according...