• Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

World: r4wp

[Ann-Reply] Reply to Announce group

Robert
22-Dec-2012
[1040]
where is it? On our R3-GUI doc pages?
GrahamC
22-Dec-2012
[1041]
Downloads page
Robert
22-Dec-2012
[1042x2]
Ok, checking & changing.
Done.
Endo
24-Dec-2012
[1044]
That's cool Kaj! :) But I think when Doc start working on the optimizer, 
the difference will be smaller.
Kaj
24-Dec-2012
[1045]
Of course, but Red will always be a lot slower than Red/System
Henrik
24-Dec-2012
[1046x2]
function! -> routine! = nice and easy way to optimize things, when 
required.
or, encapsulate optimizations
Arnold
28-Dec-2012
[1048]
Kaj, still very important progress too!
Janko
29-Dec-2012
[1049]
Kaj, awesome!!
DocKimbel
29-Dec-2012
[1050]
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.
BrianH
29-Dec-2012
[1051x3]
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.
ChristianE
30-Dec-2012
[1054x2]
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)
DocKimbel
30-Dec-2012
[1056]
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.
ChristianE
30-Dec-2012
[1057]
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]
BrianH
30-Dec-2012
[1058]
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.
Gregg
30-Dec-2012
[1059]
Very cool Kaj.
Kaj
30-Dec-2012
[1060]
Thanks
GiuseppeC
1-Jan-2013
[1061]
Robert, Great. Documentation is really inportant to use your product.
Endo
2-Jan-2013
[1062]
Very nice updates Robert. Thanks for your effort.
MaxV
4-Jan-2013
[1063]
Where is published r3-view.exe ?
Andreas
4-Jan-2013
[1064]
http://development.saphirion.com/resources/r3-view.exe
Maxim
4-Jan-2013
[1065]
Robert, does the android port currently have GUI support?
Robert
4-Jan-2013
[1066x2]
No, console online at the moment.
Network will be next.
Luis
4-Jan-2013
[1068]
What version of Android is needed for R3droid.apk ?
Robert
4-Jan-2013
[1069]
Cyphre can tell, but IMO it should work on pretty most of them.
Bo
4-Jan-2013
[1070x5]
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)
Robert
5-Jan-2013
[1075]
Bo, you have to download the script and than run it. Network support 
is not yet running. That's next.
Cyphre
5-Jan-2013
[1076x6]
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)
So here is my result:

Samsung Galaxy Mini
CPU: Qualcomm MSM7227 600 MHz ARMv6

>>speed?/no-io
== [302 193 6 0]
Robert
5-Jan-2013
[1082]
galaxy S3: 961 495 20 0
NickA
5-Jan-2013
[1083x6]
Speed function crashed on my Huawei M865C:

Access error: cannot open %tmp-junk.txt   reason: -3
Where:  write unless do foreach speed? 

Near:  write file: %tmp-junk.txt  "" tmp: make string! 32000 * 5 
ins...
I'm gettting the same reason: -3 error for any simple file write.
Maybe permissions aren't set properly by the apk?
Oops - didn't see that it should be run with /no-io.  My results:

[368 218 5 0]
That device has a slow 600 MHz processor
So, along with files and network support, at least support for 'ask 
for interactive input, would make this fully useful.
Luis
5-Jan-2013
[1089]
[475 177 9 0] [332 182 9 0] [461 187 9 0] diferents runs on Motorola 
Milestone 1 CPU 600Mhz. FROYO 2.2.1