Alaska Software Inc. - select into inefficient
Username: Password:
AuthorTopic: select into inefficient
Sander Eliasselect 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)