Re: NEWERA -- lookups

Mike Ripley wrote: > > I am using QBE to retrieve records from a master table onto my window. > Works fine! > However I have 8 lookup fields on this window (business class, status, > agent address, area name, cost centre name etc). After retrieving the > master record I do 8 separate lookups in the beforerow event for each of > these fields as I traverse the dataset. > I am told that this is inefficient and should do the lookups in one > large initial SQL statement. However I still need to preserve the where > clause set up by the QBE. > Any comments and how best to go about it using the wif. > Thanks > > -- > Mike Ripley Hi Mike If I understand you correctly you need a JOIN or an OUTER JOIN. If you dont understand joins or outer joins yet consult a SQL manual. In NewEra you can set these in the JoinPart (or something like that) property of the supertable. The only bad, bad thing is that NewEra limits the length of the String in that property. But for your purpose I guess its enough. Make sure the updataTable property of your supertable is set correctly if your ST deals with more than one table. Regards Dirk -- -- Dipl.-Math. Dirk Gunsthoevel phone: +49 (0)251 624947 -- Hoeftestr.49 fax: +49 (0)251 624177 -- 48167 Muenster 2*3*3*37 - the prime factorization of the beast -- Germany http://members.aol.com/Plabit/welcome.html