>Borislav,
>
>Thank you for the insight into cursor adapter select command issues. This post was EXTREMELY helpful for me in understanding how this all works. I appreciate it!
>
>Now, I have another issue that I am posting to you since you seem to understand a lot about this topic.
>
>What if I have a search form that is used for selecting data based on several optional parameters? THis would require a dynamic, changing select statement that can vary a lot between CursorFill() executions.
>
>Here's some examples of the queries that I need to be able to run on a single cursor adapter:
>
>1. Base command:
>Select lastname from People ;
> INNER JOIN statushistory on people.peostcfk = statushistory.sthid ;
> where people.peoschfk = ?nschfk
>
>2. Command with multiple paramaters added:
>Select lastname from People ;
> INNER JOIN statushistory on people.peostcfk = statushistory.sthid ;
> where people.peoschfk = ?nschfk ;
> and poeple.peolastname >= ?cStartLast ;
> amd people.peolastname <= ?cEndLast
>
>3. Command with different parameters added:
>Select lastname from People ;
> INNER JOIN statushistory on people.peostcfk = statushistory.sthid ;
> where people.peoschfk = ?nschfk ;
> and people.peossn = ?nssn
>
>You can see that the select statement varies significantly from one execution to another. Do you have any suggestions or tips for me on how to manage this in my application?
>
>Thanks in advance!
>
>Scott
You have tw differen options.
1. What Naomi already suggested - rebuild SelectCMD and use CursorFill() instead of CursorRefresh() method.
2. Built such SelectCmd that accept multiple parameters.
In your case I'm with Naoimi. Build new SelectCmd and Fill the cursor again.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.