[REBOL] Re: Speed required
From: kpeters:otaksoft at: 29-Nov-2007 11:24
> 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
Or - to hopefully make it even more clear:
Here's what I have been using:
cursor: [
[ 100 "Kai" 49 #764-0929]
[ 101 "Zu" 52 #764-0915]
[ 102 "Dewi" 16 #312-1772]
]
cols: [ 1 2 4 ]
remove-columns: function [ cursor [block!] columns [block!]] [ tmp result ] [
result: copy []
foreach record cursor [
tmp: copy []
foreach column columns [
append tmp pick record column
]
append/only result tmp
]
result
]
probe remove-columns cursor cols
