>>CREATE CURSOR curNames (ID i, firstname c(10), lastname c(10)) >>INSERT INTO curNames values ( 1, "Koen", "Piller") >>INSERT INTO curNames VALUES ( 2, "John", "Brown") >>INSERT INTO curNames VALUES ( 3, "Karl", "Johnson") >>INSERT INTO curNames VALUES ( 4, "Donald", "Sutterland") >>INSERT INTO curNames VALUES ( 5, "Bill", "Gates") >> >>CREATE CURSOR curGroupmember (ID i, iName i, iGroup i) >>INSERT INTO curGroupmember VALUES (1, 2,1) >>INSERT INTO curGroupmember VALUES (2, 3,1) >>INSERT INTO curGroupmember VALUES (3, 3,2) >>INSERT INTO curGroupmember VALUES (4, 1,2) >> >>CREATE CURSOR curGroup (ID i, Name c(10) >>INSERT INTO curGroup VALUES (1, "Groupa") >>INSERT INTO curGroup VALUES (2, "Groupb") >> >>- not working SQL statement: >> >>TEXT TO m.lcSql pretext 1+2+4+8 >>SELECT T1.firstname, T1.Id >>FROM curnames T1 >>where UPPER(T1.Firstname) like ? m.lcLetter + '%' >>and >>curnames.id in >>(SELECT distinct(curNAMES.Id ) FROM curNAMES >>INNER JOIN curGROUPMEMBER T3 ON T3.iName = T1.ID >>INNER JOIN curGROUP T4 on T4.Id = T3.iGroup where T4.Id = ? m.liGroup ) >>INTO CURSOR junk READWRITE NOFILTER >> ENDTEXT >>&lcSql >> >>lcLetter = "K" >>liGroup = 2 >> >>TEXT TO lcSQL PRETEXT 1+2+4+8 >>I would like to have: >> >>fullname ID >>Karl 3 >>Koen 1 >>ENDTEXT >>>>
>lcLetter = "K" >liGroup = 2 > >Select T1.firstname, T1.Id ; > FROM curNames T1 ; > INNER Join curGroupmember T3 On T3.iName = T1.Id ; > where Upper(T1.firstname) Like ?m.lcLetter + '%' ; > and T3.iGroup = ?m.liGroup ; > INTO Cursor junk ; > READWRITE > >browse >Cetin,