World: r3wp

I think you should normalise your files using TO-REBOL-FILE.

ntfs. And yes, I normalise now, just wanted to know, why it's different 
and if it's correct. (because I've spent some time to figure out 
this exists?/delete difference).

in other words.. I was expecting, that when I join something to rebol 
file, it will normalise it for me.

But maybe it's more related how join behaves:
>> join %test as-binary "test"
== %testtest
>> join %test ["test"]
== %testtest
>> join %test [as-binary "test"]
== %test#%7B74657374%7D
>> rejoin [%test as-binary "test"]
== %test#%7B74657374%7D
but you ar right, it's my fault that I was lazy.

There is another way to put a directory together with a file than 
'join, and it handles more cases with the forward/back-slash on its 
own:
>> Dir: %foo/bar
== %foo/bar
>> File: %test  
== %test
>> Dir/:File    
== %foo/bar/test
>> Dir: %foo/bar/
== %foo/bar/
>> Dir/:File     
== %foo/bar/test
>> File: %\test  
== %/test
>> Dir/:File   
== %foo/bar/test

I know, but that does not solve my case where I had to build path 
from external sources, which could contain the backslash. Like:
>> dir: %test/
== %test/
>> file: ".\LIBRARY\something"
== ".\LIBRARY\something"
>> dir/:file
== %test/.\LIBRARY\something

But to-rebol-file makes it valid for sure:
>> to-rebol-file dir/:file
== %test/./LIBRARY/something

To read the content of a shared folder on a machine, it's :
	read %/machinename/sharename/


But how (if its possible) can I read the list of the shared folders 
?

	read %/machine/		...does not work !!

I believe the share has to be a mapped drive to show up that way. 
I don't recall every enumerating shares this way, but maybe someone 
else has.

I think I remember seeing something of the sort with:
read%//

But I'm not on Windows right now, so I can't check

Do you think that this is correct?
>> integer? round 232.2
== true
I was somehow expecting that the number is still decimal = 232.0

Ah.. now I see that R3 works as I expect.

ROUND under R2 was a mezzanine, and was designed so the result would 
be an integer when possible, for use as a loop counter. It's no longer 
a mezzanine under R3. I don't remember if it was mentioned that it 
was an intentional change.

And we don't need to use integers for loop counters anymore.

we can use real numbers?

In R3, yes. There is an implicit to-integer.

Is it possible to change file-modes of directory? This doe not work:
>> get-modes %/f/dir/ 'creation-date
== 26-Oct-2010/16:55:30+1:00
>> set-modes %/f/dir/ compose [creation-date: (now)]
** Access Error: Cannot open /f/dir/
** Near: set-modes %/f/dir/ compose [creation-date: (now)]

What is the best way to form decimal and avoid the E notation?
>> form .02
== "2E-2"

form-decimal ... Gabriele has a version around

Nice challenge. To find the smallest mezz to do so

Is there a sql like dialect ( selects ) for rebol blocks in memory 
( not disc based )

I am thinking of coverting a simple read only database to ram based 
for speed ...

I thought I read of one once .. but maybe I am wrong.

I know a good one, it's called PARSE IIRC

so I can just change the scheme from odbc to ram or whatever

EXTRACT works well for that, and maybe MAP-EACH too if you do nested 
blocks.

No joins involved

There are some databases that are RAM-based already and have SQL.

For that matter, RebDB is SQL-like and RAM-based, iirc.

Ah.. I can look at rebdb then

my queries are currently taking 2 seconds and I need subsecond performance

You might look at EXTRACT or MAP-EACH then. For simple queries with 
no joins, SQL is overrated.

If you give us your actual script we can find some improvment rooms. 
Despite beeing lazy, we are not bad at such game.

(if it's not a bloated one)

I'm hacking into FreeDiams .. a free French drug interaction database 
:)

Don't trust French commercials

It's a GPL app to do drug prescribing and drug interactions .. I 
am just using their database

Once the database is in memory you don't necessarily need to do set 
operations (SQL select). You can do iterative operations much more 
quickly.

source is here https://fd.cloud-ehr.net/drugreactions.txt

huge !

/me dazzled !

It looks like you are using the iterative approach anyways, on the 
results of the SQL queries. If you cache the data in RAM you can 
do iterative stuff with FIND and loops, or even maps in R3 if you 
want real speed.

This is a RSP app .. we've already had the discussion why Cheyenne 
is not ported to R3 :)

Hashes then :)

huge?  Only 250 lines where a line is 2-3 rebol words :)

It's late here, and if see more than a dozen of lines, I could die

there is probably a better method than the one I use to generate 
the permutations

sorry , combinations

we have something like this

drug1 [ id1 id2 id3 .. ] drug2 [ id1 id5 id6 .. ] drug3 [ id4 id7 
.. ]

I have to generate all the possible combinations of each drug id 
with all the others but not with those in the same set