>I've since gotten this to work the way I intended, but I wanted to update it to allow the user to search on two different fields if need be. How can I make it also look to another variable for the searching like the code below?
>
>
cmd = [exec InTransitRN ?']+fdBlNo+[']
>
>So basically I want them to be able use the above if they have that number, but also search on this one:
>
>
cmd = [exec InTransitRN ?']+fdRefNo+[']
>
>Is there a way to combine the two somehow or does it have to be done separately? Would a CASE statement work here? I was thinking of having it check to see which text box had data in it and use the associated code based on that. I don't know if that's a good way to do it though.
This is where using an SP is actually an obstacle, because you have only the parameters it has. If you were doing SPT, you could build the where clause on the fly... something like this:
lcWhere=""
if not empty(fdblno)
lcWhere=lcWhere+" blNo=?fdblno and "
endif
if not empty(fdRefNo)
lcWhere=lcWhere+" blRef=?fdRefNo and"
endif
lcWhere=lcWhere+" 1=1"
sqlexec(handle, lcSql+" where "+lcwhere, "youralias")
This is assuming that you already have the query in the lcSql variable.