Author | Topic: select into inefficient | |
---|---|---|
Sander Elias | select into inefficient on Fri, 27 Mar 2015 06:41:11 +0100 Hi all, Can someone explain to me why I have to do this: select from customers into tmp via oSession select from tmp into objects aRes close tmp in stead of: select * from customers into objects aRes via oSession It seems highly inefficient to me. the first sample has to create an workarea, then traverse the data a second time, and then destroy the workarea. This is all unneeded if the second sample would work. And that's another thing, The second example fails silently. It will just (seemingly) do nothing. the array just stayed empty? If that syntax is not supported, it should at least throw an error! Regards Sander Elias -------------------------------------------- also a member off the XXP (http://www.xxp.nl) |