[Ann-Reply] Reply to Announce group
where is it? On our R3-GUI doc pages?
Ok, checking & changing.
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!
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.
Robert, Great. Documentation is really inportant to use your product.
Very nice updates Robert. Thanks for your effort.
Where is published 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)
So here is my result: Samsung Galaxy Mini CPU: Qualcomm MSM7227 600 MHz ARMv6 >>speed?/no-io == [302 193 6 0]
galaxy S3: 961 495 20 0
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.
[475 177 9 0] [332 182 9 0] [461 187 9 0] diferents runs on Motorola Milestone 1 CPU 600Mhz. FROYO 2.2.1