On Thursday 29 November 2007, Kai Peters wrote: > I need to transform SQL cursors with up to 10,000 records and it needs to > be= fast: > > Example cursor: > > [ > [ 100 "Joe Browne" "Chicago" 55 445-5689 ] > [ 101 "Joe Browne" "Chicago" 55 223-2221 ] > [ 102 "Joe Browne" "Chicago" 55 489-5555 ] > [ 103 "Joe Browne" "Chicago" 55 235-2245 ] > ] > > I need a copy of this cursor, but only containing certain fields from each= > record; > the desired fields should be specified in a block like: > > [ 1 2 5 ] if I wanted record #, name & phone from each record in the > example above. Hi Kai: I'm not sure if I fully understand your need, but if you are looking for column values 1, 2 & 5, why not compose your SQL query to those specific columns in that order? as in "select col1,col2,col5 from MyTable"? If I've missed the boat here - sorry! Oh, and what do you mean by 'transform'? regards tim
-- To unsubscribe from the list, just send an email to lists at rebol.com with unsubscribe as the subject.
