Hi Naomi!
So, what is the hidden magic behind your success?
Scott
>>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
>>
>
>I was generating the SelectCmd dynamically in such situations. I have Search form working based on CA.