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 = ?nssnYou 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?
>this.SelectCmd = [SELECT * FROM YourTable WHERE SomeField = ?lePar1 AND OtherField = ?lePar2] > >*** Then: >lePar1 = 1000 >lePar2 = [BlahBlah] >oCA.CursorFill() >BROWSE NORMAL >lePar1 = 2000 >lePar2 = [BlahBlah 800] >oCA.CursorRefresh() >