>Cetin,
>
>A remote view question again.
>
>Assume that my view has 3 fields, id(numeric),city(char), hire_date(date data type)
>
>Some times I want to retieve data just by city. Then I give city value and dont bother about other two
>parameters(id and hire_date). I don't want id and hire_date fields to be null or blanks.
>
>How can I set my id and hire_date params ??
>
>Thank You
Rod,
Already answered as I would. Define ranges for numeric, date, datetime. ie: if your ids is never negative and max 9999, lnIdstart = 0 lnIdEnd = 9999. For date ldStartDate = minpossibledate, ldEndDate = date() (or {1/1/9999}). For similar situation I use a range class that gets min and max values, swaps them and/or fills them with appropriate values. Then in your SQL instead of = you would use "myId between lnIdStart and lnIdEnd". Also think of stored procs as Ed suggested before if possible. ie: in your server database you could define wrapper stored procs as notempty(anyTypeField), empty(anyFieldType).
Cetin