🚀 go-pugleaf

What version of JBuilder...??

Also this has been previously reported in this newsgroup, don't remember 
the answer since I have never experienced the problem.

Do a search on this newsgroup..

John..


Ben wrote:
> I set up a masterlink between two queries.  The form has two tables with the top one containing the master query and the bottom one the details.  What happens is that everytime I click on a row, move to another one and come back the previous row, it suddenly shows twice the amount of data. When I move two rows down and back it has three times the amount. I tried taking the tick off "Delay fetch ...", but it didn't solve the problem. (By the way, I'm using the driver recommended by Lori which solved some of the other issues I had)  
> 
> Query1: 
> 
> SELECT DISTINCT eqnum, jpnum, (SELECT DISTINCT description FROM equipment WHERE eqnum = PM.eqnum) as Description, (SELECT DISTINCT description FROM jobplan WHERE jpnum = PM.jpnum AND orgid = PM.orgid AND siteid = PM.siteid) as 'JP Description', orgid, siteid  FROM PM WHERE PM.eqnum in (SELECT DISTINCT eqnum FROM msoEquipFMEA)
> 
> Query 2: 
> 
> SELECT DISTINCT m.eqnum, m.jpnum, m.siteid, m.orgid, c.fmcid, c.fmea_ref,(SELECT DISTINCT fmea_desc FROM dbo.msoFMEA WHERE fmea_ref = c.fmea_ref) as 'FMEA Desc', c.fm_ref, (SELECT DISTINCT fm_desc FROM dbo.msoFM WHERE fm_ref = c.fm_ref AND FMEA_REF = c.FMEA_REF) as 'Fm Desc',c.ff_ref,(SELECT DISTINCT ff_desc FROM dbo.msoFF WHERE ff_ref = c.ff_ref AND FMEA_REF = c.FMEA_REF) as 'FF Desc',FMPctInspCost FROM msoJP_FM m INNER JOIN msoCFM c ON m.fmcID = c.fmcID
> 
> Masterlink:
> 
> qdsJP_CFM.setMasterLink(new com.borland.dx.dataset.MasterLinkDescriptor(
>         qdsPM, new String[] {"jpnum", "eqnum", "siteid", "orgid"},
>         new String[] {"jpnum", "eqnum", "siteid", "orgid"}, true, false, false));


-- 
=============================================
TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
====================================================