PDA

View Full Version : Active Link with join on MS SQL with sql::arguments


ABC123

stecenko
08-11-2014, 01:30 PM
This is my active link table...
SELECT Trans.dTrnCancelled, Trans.dTrnInvPrinted, Trans.iTrnClientInv, Trans.dTrnDate, peo.cPeoFirstName
FROM Trans Trans
INNER JOIN People Peo
ON Trans.cTrnFkPeoClient = Peo.cPeoPk
WHERE dTrnCancelled IS NULL AND ( dTrnInvPrinted = :notPrintedYet OR dTrnInvPrinted BETWEEN :beginDate AND :endDate OR iTrnClientInv = :oneInvoiceNumber )
ORDER BY Trans.dTrnClientInv, Trans.dTrnDate

When I'm in design mode and click on Preview Data, I get a prompt to Specify Argument Values. Like this...
38632

and when Click OK, I get the correct 4 records. Like this...
38633

When I go to Tables/Sets, select this active link, and click on view, default browse, I get the Specify Argument Values prompt. I fill it in just like I did previously, but I get this....
38634

and I can scroll down forever, looking at blank rows.


Am I doing anything wrong? Why is the same active link behave differently in Alpha's Design and View?