World: r4wp

James, I bought Compute in the eighties whenever I could lay my hands 
on it in the Netherlands :-)

And spent hours typing in listings :(

I rigged up my C64 with the speech synth module so that it would 
read out each character as i typed in the machine code listings etc

Yeah, I think my biggest was 18KB, complete listings of the TurboBASIC 
interpreter and compiler. We haven't made any progress since then 
;-)

I've got my Compute! magazines in storage in my shed

For some mags I had to write my own entry programs to assist in using 
the checksums

Magazines were fun then .. now you have to do a random walk across 
the web

Thanks for putting Saphirion's efforts behind R3 Robert.

Robert, gray text on a black background is very hard to read ....

where is it? On our R3-GUI doc pages?

Downloads page

Ok, checking & changing.

Done.

That's cool Kaj! :) But I think when Doc start working on the optimizer, 
the difference will be smaller.

Of course, but Red will always be a lot slower than Red/System

function! -> routine! = nice and easy way to optimize things, when 
required.

or, encapsulate optimizations

Kaj, still very important progress too!

Kaj, awesome!!

ChristianE: nice work! 


How do you cope with multiple columns having the same name returned 
by INSERT? This can happen when you select from several tables, and 
may lead to nasty errors.

The headers (field names) aren't used for retrieval, they're just 
returned for documentation. As in R2, the columns are returned positionally.

The block of headers is not screened for dups and currently could 
use a little screening for unnamed columns (it would be better to 
return none rather than an empty word). Fortunately, they don't matter 
in your code unless you want them to.

If you're careful about your column naming, the returned block of 
header words can be handy though.

Hi Brian! In order to make the ODBC extension bootable, I've commented 
out the last lines in src/boot/odbc.r, because otherwise R3 chokes 
on the word EXTEND not being bound to a context on boot time. It's 
not available as SYS/EXTEND either, but of course, there must be 
some way to use EXTEND.

(sorry, wrong group)

BrianH: see the "Column names" section in the README, those column 
names returned by INSERT are specifically meant for mapping on the 
result set, hence my concern about duplicate names.

You're both right here. Usually, I avoid duplicate names on the SQL 
side already, frequently mapping sql result column names with "as 
<columnname>" to the words I want to use in Rebol.


SELECT Customer.ID AS CustomerId, Article.ID AS ArticleId, Order.Copies 
* Article.Price AS TotalPrice ...   --->  [customer-id article-id 
total-price]

Doc, those column names are meant for binding to the result set, 
but it is not necessary to access the result set that way. You usually 
just do the positional access. If you want to use the column names, 
you have to make sure the column names are unique and that all columns 
have names, same as you have to do with all SQL.

Very cool Kaj.

Thanks

Robert, Great. Documentation is really inportant to use your product.

Very nice updates Robert. Thanks for your effort.

Where is published r3-view.exe ?

http://development.saphirion.com/resources/r3-view.exe

Robert, does the android port currently have GUI support?

No, console online at the moment.

Network will be next.

What version of Android is needed for R3droid.apk ?

Cyphre can tell, but IMO it should work on pretty most of them.

Connected with WiFi on Android 4.0 on Motorola Electrify 2, trying 
to run the test script, I get the following:

>> do http://development.saphirion.com/experimental/oneliner-prime-numbers.r

** Access error: cannot open: tcp://development.saphirion.com:80 
reason: -12
** Where: open open unless sync-op either read
** Near: open conn port

But it is super exciting, anyway!

I got a slightly different message when I tried it with 3G instead 
of WiFi, for some reason:


>> do http://development.saphirion.com/experimental/oneliner-prime-numbers.r

** Access error: cannot open: tcp://development.saphirion.com:80 
reason: -12

** Where: open open unless sync-op either read either read-decode 
case load -apply-do
** Near: open conn port

(Just more detail in the "where" field on the second error)

Bo, you have to download the script and than run it. Network support 
is not yet running. That's next.

yes, networking is not done yet.

You just download a *.r script (or copy on your sdcard in the phone). 
Then you can just clik on the script file and file association requester 
should popup so you can run *.r scripts just by clicking on them 
instead of execution from console.

regarding version: this .apk should be compatible and run on Adroid 
v2.2.x (FROYO) and up

(I've tested it on Android 2.3 (GINGERBREAD) phone and it works well.)

BTW It would be interesting to see how R3 performs on multiple devices. 
The easier way is just open the R3 console and execute: SPEED?

(with /NO-IO refinement)