Mike I cant answer the question you have, but I can answer my practice:
>From the SATTCHED table I always project a temp Table, that I use in forms and reports, there I never experience a performance Issue, when I need to push back some updates to the foreign DB , I do in an eep (mostly in a form (requires 7.6)). Having said that I might add using clause is for identifying the primary Key, so I guess that the best is have a using clause for field()s) that uniquely identifies a row in the foreign DB-table. After that you can use the alias to name each field. This is only TTBOMK and I am still learning. Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 S-131 30 NACKA SWEDEN +46 070 545 50 38 [EMAIL PROTECTED] -----Ursprungligt meddelande----- Från: [email protected] [mailto:[EMAIL PROTECTED] För Ramsour Mike Skickat: den 12 augusti 2008 17:24 Till: RBASE-L Mailing List Ämne: [RBASE-L] - SATTACH performance question Good morning: Is there a difference in the speed of accessing data in foreign tables from an SATTACHed table depending on whether the "USING ALL" vs. "USING <collist>" is used? i.e. Is it better to use the "USING ALL" syntax vs. specifying exact columns vs. not specifying any columns? Thanks for any insight. Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340
