> 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
--
To unsubscribe from the list, just send an email to
lists at rebol.com with unsubscribe as the subject.
