access new arrays within external

2009-01-02 Thread Thierry
Happy new year to all of you. Does someone know where I can find the API documentation to access the new arrays ( Rev 3.0 ) from within externals ? Thanks for any pointer or link. Regards, Thierry ___ use-revolution mailing list

Rev cgi mySQL (again)

2009-01-02 Thread jbv
Hi there I have a mySQL table with about 4 entries. I also have a Rev cgi 2.5 script that sends (very) complex SELECT requests; in which the WHERE part can feature as much as 50 nested booleans winth and, or, binary etc For quite some time I realized that requests to mySQL slow down my

Where to download beta versions?

2009-01-02 Thread David Bovill
Anyone point me to somewhere to download the latest beta versions manually? I've downloaded 3.5.0-dp-2, but I need to go back to 3.5.0-dp-2. The manage versions Rev interface does not let me do that as I wen from 3.0.0-gm-3 directy to the latest beta.

Re: Where to download beta versions?

2009-01-02 Thread Mark Schonewille
Hi David, You can download beta versions if you have an Enterprise license. Perhaps you should ask on the other list, if you have access to it. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Dutch forum:

Re: Where to download beta versions?

2009-01-02 Thread william humphrey
Hi Even with an Enterprise license it does not mean that you're on the Enterprise mailing list. I've tried and never got on it... On Fri, Jan 2, 2009 at 9:15 AM, Mark Schonewille m.schonewi...@economy-x-talk.com wrote: Hi David, You can download beta versions if you have an Enterprise

Re: Where to download beta versions?

2009-01-02 Thread David Bovill
Me neither! I've got an Enterprise License - Heather what's the low down on getting beta's subscribing to the Star Ship List? 2009/1/2 william humphrey shoreag...@gmail.com Hi Even with an Enterprise license it does not mean that you're on the Enterprise mailing list. I've tried and never got

set the text of line 4 of field id 123?

2009-01-02 Thread David Bovill
These work as expected: put newLine into line lineNum of field id fieldID set the htmltext of line lineNum of field id fieldID to newLine So why on earth does this not work? set the text of line lineNum of field id fieldID to newLine I've always found the properties (text and htmltext) of

Re: Rev cgi mySQL (again)

2009-01-02 Thread Bill Marriott
I'm curious to know if anyone already faced the need to (almost) completely drop SQL in favor of Transcript for DB data search... Without seeing the SELECT command and knowing how the database is set up, it's hard to know whether dropping MySQL is prudent or not. It's not too difficult for

Re: set the text of line 4 of field id 123?

2009-01-02 Thread Bill Marriott
David, Because the text of is a property of a field (button, image), not a line/chunk thereof. The HTMLText syntax specifically allows for chunks; Text does not. From the docs: set the HTMLText of [chunk of] field to htmlString set the text of {button | field | image} to string It would

Re: Rev cgi mySQL (again)

2009-01-02 Thread Ruslan Zasukhin
On 1/2/09 2:49 PM, jbv jbv.silen...@club-internet.fr wrote: Hi there I have a mySQL table with about 4 entries. I also have a Rev cgi 2.5 script that sends (very) complex SELECT requests; in which the WHERE part can feature as much as 50 nested booleans winth and, or, binary etc

Re: set the text of line 4 of field id 123?

2009-01-02 Thread David Bovill
OK - filed as an enhancement request. Vote for it herehttp://quality.runrev.com/qacenter/show_bug.cgi?id=7590- if you feel the same! I guess I could use set the htmltext of line 1 of field even if using plain text - but I think it is just plain counter intuitive as it is - good to see the docs

Re: Rev cgi mySQL (again)

2009-01-02 Thread jbv
Bill, Ruslan, Thanks for your answers. To answer some of your questions, I only need to read data from mySQL, and the nested booleans are of the ( ... OR ... OR ...) AND ( ... OR ...) type. I don't if anyone's interested, but here are examples of my code : --example 1 : using mySQL put

Re: Where to download beta versions?

2009-01-02 Thread Björnke von Gierke
It should mean it. If you're not, then mail support. The problem is (i think) that all changes to that list must be made manually, so if your request is not acted upon, pester them in increasing frequency, until they finally do it. But remember to let them also have fun Björnke On 2 Jan

Clone image trouble?

2009-01-02 Thread William de Smet
Hi there all, For my son I am starting to create an app in which he use 'stamps' to create his own drawing. So far I have some small icons (graphics) and a dummy graphic. I started with the following code: - on mouseup set text of img dummy to the text of the me clone img dummy end

Re: Clone image trouble?

2009-01-02 Thread Eric Chatonet
Bonjour William, When you delete the Dummy image you delete your template because the engine looks for the first image with this name (in layering order). So you have two solutions: 1. You rename the image when cloned: clone img dummy set the name of it to Copy of dummy And: delete

Re: Clone image trouble?

2009-01-02 Thread Jim Sims
On Jan 2, 2009, at 4:43 PM, William de Smet wrote: Hi there all, For my son I am starting to create an app in which he use 'stamps' to create his own drawing. So far I have some small icons (graphics) and a dummy graphic. I started with the following code: snip delete image dummy (I put

Re: set the text of line 4 of field id 123?

2009-01-02 Thread Bill Marriott
Rev doesn't have the betas available as a download ... that was available only during the open beta for 2.9. Now they're back to getting them from within the Enterprise software. But Heather might be able to help obtain it for you (or a new dp3 might do the trick). Heather's also the only

Re: set the text of line 4 of field id 123?

2009-01-02 Thread David Bovill
OK - thanks for the reply! 2009/1/2 Bill Marriott w...@wjm.org Rev doesn't have the betas available as a download ... that was available only during the open beta for 2.9. Now they're back to getting them from within the Enterprise software. But Heather might be able to help obtain it for

conditional formatting, how to do it

2009-01-02 Thread Peter Alcibiades
Must be doing something obvious wrong. As usual! I want to go through a field and format lines depending on what they start with. So to begin with I try the following, which works just fine, to make sure the lines are being found and picked up: set the itemDelimiter to repeat for each

Re: Where to download beta versions?

2009-01-02 Thread -= JB =-
Heather responded to the problems I was having and fixed it for me. She is very nice to work with so just ask her again if you need to. -=JB=- On Jan 2, 2009, at 7:06 AM, Björnke von Gierke wrote: It should mean it. If you're not, then mail support. The problem is (i think) that all

Re: conditional formatting, how to do it

2009-01-02 Thread Eric Chatonet
Bonsoir Peter, Don't know if it will help, but: Many times, it appears more efficient to set 'char 1 to -1 of line line number to style So, in your case: local tNum, tText - lock screen put 0 into tNum put field test of stack Calendar into tText repeat for each line tLine in tText if

Re: conditional formatting, how to do it

2009-01-02 Thread Rob Cozens
Happy New Year Peter, I change this so as to do the formatting as follows: set the itemDelimiter to repeat for each line theLine in field test of stack Calendar if item 1 of theLine is Sunday then set the textStyle of theLine to bold end if end repeat and get the error Message execution

Re: conditional formatting, how to do it

2009-01-02 Thread Mark Smith
Peter, in the repeat for each structure, the loop variable - theLine - is just that, a variable, so when you try to format it, nothing happens to the line in the field of which it's a copy (and you get an error, because you can't format text in a variable this way, and in any case, you

Re: conditional formatting, how to do it

2009-01-02 Thread Rob Cozens
Sorry Peter, Try: set the textStyle of line theLine of field test to bold I forgot this was a repeat for each :-[ Try set the itemDelimiter to put 0 into lineCount repeat for each line theLine in field test of stack Calendar add 1 to lineCount if item 1 of theLine is Sunday

Re: Rev cgi mySQL (again)

2009-01-02 Thread Bill Marriott
Hi jbv, I am less of an expert with SQL than many, but I think you can simplify your query a bit using the MATCH...AGAINST keywords: for example, the first part (b) of your query might look like: -- convert myList1 to a space-delimited items SELECT Col10, Col11, Col12, Col13, Col14, Col15

Re: conditional formatting, how to do it

2009-01-02 Thread Bill Marriott
When using repeat for each x in y you MUST consider each of the referenced items (x and y) to be read only. From the docs: --- Important! In any of the for each loops, you should not change the labelVariable or container in a statement inside the loop. Doing so will not cause a script error,

Re: conditional formatting, how to do it

2009-01-02 Thread Eric Chatonet
I did not notice that ;-) That's the main point. Of course! Le 2 janv. 09 à 18:40, Bill Marriott a écrit : Additionally, you are trying to set the style of a variable, which would have no effect. Best regards from Paris, Eric Chatonet.

Re: set the text of line 4 of field id 123?

2009-01-02 Thread J. Landman Gay
David Bovill wrote: I guess I could use set the htmltext of line 1 of field even if using plain text - but I think it is just plain counter intuitive as it is - good to see the docs are explicit though :) What I think you want is: put cr into line lineNum of field id fieldID Or you can

Re: set the text of line 4 of field id 123?

2009-01-02 Thread David Bovill
Lost in translation :) newLine here is just a (probably bad choice for a variable name. The issue is not how to do it - it's just that it is naturla syntax to try to set the text of line x of field... and I think you should be able to use it. 2009/1/2 J. Landman Gay jac...@hyperactivesw.com

Updating a stack

2009-01-02 Thread Philip Usher
How might one go about updating a stack created in Revolution 1.1.1 in Mac OS 9 to the current version of Revolution on a Mac Intel? thanks, Philip Usher ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to

Re: Updating a stack

2009-01-02 Thread Mark Schonewille
Hi Philip, Just open it. Choose Save As... from the File menu and make sure to save the stack in the new format. You might want to check whether file format preservation is turned on or off in the preferences. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software

Re: Where to download beta versions?

2009-01-02 Thread stephen barncard
Are you sure the version isn't in your Studio or Enterprise folder? It doesn't appear that it writes over the old one. It just changes the alias. On Fri, Jan 2, 2009 at 4:59 AM, David Bovill da...@architex.tv wrote: Anyone point me to somewhere to download the latest beta versions manually?

Re: Clone image trouble?

2009-01-02 Thread William de Smet
Hi Eric and Jim, It is so obvious it has to do with the name and of course your suggestion works. After playing with it I got the idea of resizing the 'stamp'. I got a scrollbar to do this but it only works if I limit it to just one stamp. So I grouped the whole thing (stamp and scrollbar) and

Re: Where to download beta versions?

2009-01-02 Thread Bill Marriott
He skipped dp-1, or it would show up in manage versions Are you sure the version isn't in your Studio or Enterprise folder? It doesn't appear that it writes over the old one. It just changes the alias. ___ use-revolution mailing list

Losing data when quitting

2009-01-02 Thread Timothy Miller
Maybe I've remembered wrong. As I recall, if I alter any field in a stack, or add a new card, or make other relatively minor changes, I will be prompted to save before the stack closes. On the other hand, occasionally, something goes mysteriously missing. By the time it's gone, it's too

Re: Rev cgi mySQL (again)

2009-01-02 Thread jbv
Bill, Hi jbv, I am less of an expert with SQL than many, but I think you can simplify your query a bit using the MATCH...AGAINST keywords: for example, the first part (b) of your query might look like: -- convert myList1 to a space-delimited items SELECT Col10, Col11, Col12, Col13,

Re: Rev cgi mySQL (again)

2009-01-02 Thread Jan Schenkel
--- jbv jbv.silen...@club-internet.fr wrote: Last but not least, in my examples, I don't think the performance difference is in the data transfer. Actually, the fact that the boolean part of the query can feature up to 50 elements doesn't imply that the amount of data returned will be

Re: Losing data when quitting

2009-01-02 Thread Bill Marriott
Timothy, Today, I'm working with a single small stack I don't use very often. I just realized that if I make changes and Quit Revolution from the Revolution menu, to the left of the File menu, I don't get a save prompt, and none of my changes are saved. If you can consistently reproduce

Re: Losing data when quitting

2009-01-02 Thread Timothy Miller
It's more likely my brainlessness. If not, I'd be happy to report it. I can consistently reproduce it. If a bug, it's a rather serious matter. Data, and more, will be lost. I checked the stack script. Not much to it. OpenStack CloseStack and OpenCard do get intercepted (I can't remember

Re: Rev cgi mySQL (again)

2009-01-02 Thread jbv
Jan, Thanks for the comment. If you guys are interested, here is a clue on how my table is structured : there are 2 columns (varchar type) Col1 and Col2 containing single words. The additional part (with the / construct) happens very seldom, so I guess it can be ignored in the performance

Re: Losing data when quitting

2009-01-02 Thread Paul Looney
Timothy, Bill, I created a new main stack. Named it Throw Away. Added a field. Saved the stack. Typed Hello World into the new field. Quit Rev. Reopened Throw Away - no Hello World. Then I retyped Hello World, saved the stack, and quit Rev. Reopened Throw Away - Hello World was there. (OS X

Re: Losing data when quitting

2009-01-02 Thread Timothy Miller
Damn! I replicated it several times this morning, with care. Now I can't replicate it. I haven't changed anything. I'll wait and watch, to see if it occurs again. Tim On Jan 2, 2009, at 12:11 PM, Timothy Miller wrote: It's more likely my brainlessness. If not, I'd be happy to report it.

Re: Losing data when quitting

2009-01-02 Thread Paul Looney
Tim, I doubt it is your imagination - and I thank you for raising this issue again. If you create a new stack and put two fields on it, you'll observe the following: When you open the stack the focus is on the first field you created. If you edit that field and quit Rev your changes will not

Re: conditional formatting, how to do it

2009-01-02 Thread Alex Tweedly
Ignoring all the other serious issues, I noticed : Rob Cozens wrote: I change this so as to do the formatting as follows: set the itemDelimiter to repeat for each line theLine in field test of stack Calendar if item 1 of theLine is Sunday then set the textStyle of theLine to bold end if

Re: Losing data when quitting

2009-01-02 Thread william humphrey
In a similar vein I sometimes see ghost stacks. I can open a stack and then look in the application browser and see another main stack that I had opened in the past. When this happens if I quit RunRev and try again it doesn't re-occur so it is not something that can be reported as a bug. I think

Re: Rev cgi mySQL (again)

2009-01-02 Thread Bob Sneidar
Hi JB. I have always toyed with the idea of writing a paging query system which paged through a large SQL database. The idea would be that you only have one live cursor but 2 or 3 pages (cursors) forward and back. As the user scrolls past the current page you silently swap the pointer to

Re: Rev cgi mySQL (again)

2009-01-02 Thread william humphrey
I'm interested in what Bill said: notice that I use single quotes to enclose strings; you shouldn't need your q business cluttering things up I'm constantly doing that because I build the SQL in RunRev and then send it. I'd like to see an example of a SQL built in RunRev put select table q

Re: Rev cgi mySQL (again

2009-01-02 Thread william humphrey
It's interesting hearing you guys talk some about SQL. I've noticed too how much better RunRev is at processing big blocks of text and how that works so nicely with having a fully normalized SQL database in conjunction. I used to notice some slow SQL processes in SQLite but now I'm doing almost

Re: Rev cgi mySQL (again)

2009-01-02 Thread Bob Sneidar
This brings up an interesting point. Given the constraints of Revolution Cursors (being loaded into memory) has anyone figured out what the maximum data block size is for Revolution? If one knew that, they could deduce from the structure of their SQL database approximately how many records

Re: Losing data when quitting

2009-01-02 Thread J. Landman Gay
william humphrey wrote: In a similar vein I sometimes see ghost stacks. I can open a stack and then look in the application browser and see another main stack that I had opened in the past. When this happens if I quit RunRev and try again it doesn't re-occur so it is not something that can be

Re: Losing data when quitting

2009-01-02 Thread J. Landman Gay
Paul Looney wrote: There may be other recipes as well, but the stack saving problem seems to be related to the lack of a closeField - which is not sent if the focus is still in the edited field when the stack is closed. This is a really old bug, I remember working around it years ago. I've

Re: Losing data when quitting

2009-01-02 Thread Paul Looney
JLG, Do you recall the bug number? Maybe we could get some new votes. Paul Looney On Jan 2, 2009, at 5:44 PM, J. Landman Gay wrote: Paul Looney wrote: There may be other recipes as well, but the stack saving problem seems to be related to the lack of a closeField - which is not sent if the

Re: Rev cgi mySQL (again)

2009-01-02 Thread Dave Cragg
On 2 Jan 2009, at 20:38, jbv wrote: So the query is quite straightforward, for instance : SELECT Col1, Col2, Col3, Col4 FROM myTable WHERE Col1 = toto OR Col2 = toto OR Col1 = tata OR Col2 = tata OR Col1 = titi OR Col2 = titi... up to possibly 50 elements. I think all those OR conditions

Re: Rev cgi mySQL (again)

2009-01-02 Thread Dave Cragg
Sorry, syntax error in my last post: Should be: ( SELECT Col1, Col2, Col3, Col4 FROM myTable WHERE Col1 IN ('toto','tiki','tata','etc.') ) UNION DISTINCT ( SELECT Col1, Col2, Col3, Col4 FROM myTable WHERE Col2 IN ('toto','tiki','tata','etc.') )

Re: Rev cgi mySQL (again)

2009-01-02 Thread Sarah Reichelt
finally, I tried the following : I dumped the content of myTable as a text file, opened it in the Rev script, and did the selection of records inside a repeat for each line loop. And to my surprise, the speed of the script improved to almost 40% (which is a lot for a script that used to

Cross-tab report: from list

2009-01-02 Thread mfstuart
Hi all, How do I manipulate the following data list into a spreadsheet (cross-tab report) format? I'm assuming arrays are in the works for this to build the spreadsheet data set, but since I haven't worked with them, I'm not sure about that. As you can see, the list contains repeating years

Application Browser problem?

2009-01-02 Thread Kurt Kaufman
I'm helping my 12-year-old daughter learn to program with RunRev, and I couldn't really figure this one out: Could someone point me to a reference on how to move cards reliably between stacks in the Application Browser? I find I can't predict exactly how it will work, between selecting the

Large databases kaput?

2009-01-02 Thread dunbarx
What? Say it ain't so. Do I understand that there is some practical limit to the number of cards in a stack, that a speed hit is reached at a mere 5000? Where was the warning on the label??? Before I make a stack and test thisanyone? Craig Newman

Re: Losing data when quitting

2009-01-02 Thread Timothy Miller
Hi Paul, On Jan 2, 2009, at 1:51 PM, Paul Looney wrote: Tim, I doubt it is your imagination - and I thank you for raising this issue again. If you create a new stack and put two fields on it, you'll observe the following: When you open the stack the focus is on the first field you

Re: conditional formatting, how to do it

2009-01-02 Thread Peter Alcibiades
Thanks so much for your help everyone! And Happy New Year to all. And thanks not just for this, but for your continued willingness to help not just me but other enquirers. Peter -- View this message in context: