Re: Sending Email with attachment
Holá Bill, Google for BLAT262, download, read the docs, install and enjoy. Works perfect for me (under Windows) kind regards Horst BILL HUMPHREY wrote: Since *Syntax: revMail address[,ccAddress[,mailSubject[,messageBody]]]* does not allow for attaching a file how do you do that? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/Re%3A-Sending-Email-with-attachment-tp23117602p23120589.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: RevCopyFolder XP problem
Holá David, Why don't you use XCOPY? f.e. get shell(start xCopy /e /c /d /y /h /k /v D:\*.* H:\test\*.*) that works fine David Glasgow wrote: Way back in October, Eric, Ken and others helped out with identifying special folders in XP and Vista, in which I could save shared and non shared data. (Because the system I used in my app previously breaks under Vista). Having finally decided on appropriate locations and file structures, I have started to script a routine which checks on the platform, then checks in each location for the expected folders, and copies them there if they are not present. Debugging is a bit of a painful process on Windows, because I am using Studio on Mac and testing under Parallels (XP). However, as far as I can tell, RevCopyFolder doesn't work as advertised on XP. In the Rev 2.0 language reference it states: The revCopyFolder command makes a copy of the entire folder, including all files, subfolders, and their contents. The folder remains in its original location and the copy is placed in the new location. I only get the top level (i.e foldertocopy) folder created in the new location, with none of its contents, be they files or folders. I look at the result for each instance of RevCopyFolder after each partial successful copy, which gives me the numerical value '4'. I know that RevCopyFolder seems to be very erratic on the Mac, but is my problem on Win recognised by others? Is there an easy workaround? Thanks David Glasgow ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/RevCopyFolder-XP-problem-tp21235671p21240249.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
opening cd/Stack so slow
Hola a todo el mundo! opening a card or a substack takes up to 2 minutes(!!!) inside the Application Browser. I'm using Win XP/2k and RR2.9.0 thank you for answering, best regards and good luck for 2009 Horst -- View this message in context: http://www.nabble.com/opening-cd-Stack-so-slow-tp21233923p21233923.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: AW: Slow down of the 3.0 IDE
Hey Malte, That's the trick! Speeds up a lot! Nice to know, that there are some experts somewhere :) Hey Tiemo, now it's funny to work again. Thanks for opening that question again :) Steter Tropfen höhlt den Stein Horst Tiemo Hollmann TB wrote: Wow, Malte, you are a 3 star expert :) That was the clue, now everything runs like a canon ball :) Obviously the prefs wanted to do something with any old plugins I had bound sometimes in the past but deleted the wrong way... Many thanks - you saved my day! Tiemo -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:use-revolution- [EMAIL PROTECTED] Im Auftrag von Malte Brill Gesendet: Donnerstag, 2. Oktober 2008 10:05 An: use-revolution@lists.runrev.com Betreff: Re: Slow down of the 3.0 IDE Tiemo, it might be worth a try to delete revPreferences.rev (while rev is closed) In the messagebox type: put the filename of stack revPreferences to get the full path. Now close rev to delete that file and restart. But maybe you tried that already? All the best, Malte ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/Slow-down-of-the-3.0-IDE-tp19774666p19809843.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: GLX2 and Rev 3.0
Holá Tiemo, Just to make things clear: I'm working with W2k AND XP! Same reaktion on both systems. Best Regards Horst Tiemo Hollmann TB wrote: Hi, I've just installed Rev 3.0 and noticed two things 1. The reaction time on menu mouseclicks (I reported before) in Rev IDE 3.0 on Win XP (with and without stacks open) is still a crawl. Anybody else (beside of Horst) having performance problems with the IDE? 2. When trying to open a script with activated GLX2, nothing happens. After deactivating GLX2 the scripts are opened in the new Rev editor. I didn't found any deinstall procedure fro GLX2. What is the appropriate way to do it. Just remove the GLX2 plugins from the plugins folder and that's it? Thanks Tiemo ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/GLX2-and-Rev-3.0-tp19570535p19583924.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Stack opens behind Windows desktop
Holá Jacqueline, System settings??? Don't think so, cause there is/was never a problem with IDE-Version. Just Standalone makes this Problems. During next days I'll install some more Standalones on different PC's. Let's hope to get some more infos then. best regards Horst J. Landman Gay wrote: That's good info. It means the stack title bar doesn't matter, it is something else. Also, it is good to know that it only happens on one of your PCs (same as me) and not on all of them. Maybe the problem is a system setting? I have no idea which one it might be. Your English is very good, by the way. :) -- Jacqueline Landman Gay | [EMAIL PROTECTED] HyperActive Software | http://www.hyperactivesw.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/Stack-opens-behind-Windows-desktop-tp19354380p19408405.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: AW: slown down of IDE 2.9 under windows
Holá Tiemo, Yes, I also have that Phenomenal thing here. Yes, I also rum RR2.9.0 Build 610 and I use Win2k and XP. I also fond this problem on the Beta 3.0.0 But I'm working under 2.9.0 now. I find this slowdown on both, IDE and standalone. The good thing is now: I'm not alone with this (thought it is MY problem only), the bad thing: it should be fond :-( Best regards Horst Tiemo Hollmann TB wrote: Hi Bernhard, yes, 2.9.0 Build 610 :) Tiemo -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:use-revolution- [EMAIL PROTECTED] Im Auftrag von Bernard Devlin Gesendet: Mittwoch, 10. September 2008 09:21 An: How to use Revolution Betreff: Re: slown down of IDE 2.9 under windows This may sound like a stupid question (so apologies in advance), but are you sure this is on Rev 2.9 and not Rev 3.0? Bernard On Tue, Sep 9, 2008 at 2:57 PM, Tiemo Hollmann TB [EMAIL PROTECTED]wrote: Hi there, Win XP, SP2, Rev 2.9 ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/slown-down-of-IDE-2.9-under-windows-tp19393010p19408605.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: AW: AW: slown down of IDE 2.9 under windows
Holá Tiemo, I also installed on a brandnew Laptop under XP few weeks ago Salu2 Horst Tiemo Hollmann TB wrote: Holá Horst, did you already tried a fresh install of runrev? Tiemo -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:use-revolution- [EMAIL PROTECTED] Im Auftrag von Horst Gesendet: Mittwoch, 10. September 2008 10:00 An: use-revolution@lists.runrev.com Betreff: Re: AW: slown down of IDE 2.9 under windows Holá Tiemo, Yes, I also have that Phenomenal thing here. Yes, I also rum RR2.9.0 Build 610 and I use Win2k and XP. I also fond this problem on the Beta 3.0.0 But I'm working under 2.9.0 now. I find this slowdown on both, IDE and standalone. The good thing is now: I'm not alone with this (thought it is MY problem only), the bad thing: it should be fond :-( Best regards Horst Tiemo Hollmann TB wrote: Hi Bernhard, yes, 2.9.0 Build 610 :) Tiemo -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:use-revolution- [EMAIL PROTECTED] Im Auftrag von Bernard Devlin Gesendet: Mittwoch, 10. September 2008 09:21 An: How to use Revolution Betreff: Re: slown down of IDE 2.9 under windows This may sound like a stupid question (so apologies in advance), but are you sure this is on Rev 2.9 and not Rev 3.0? Bernard On Tue, Sep 9, 2008 at 2:57 PM, Tiemo Hollmann TB [EMAIL PROTECTED]wrote: Hi there, Win XP, SP2, Rev 2.9 ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/slown-down-of-IDE-2.9- under-windows-tp19393010p19408605.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/slown-down-of-IDE-2.9-under-windows-tp19393010p19411893.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: AW: AW: slown down of IDE 2.9 under windows
Holá Bernard, Same to me! Maybe the Stack(s) are to big with a total of +/- 25MB. So I'm thinking now to splitt the Mainstack and it's Substacks and Cards (+/- 120) into smaller parts. Do you think that makes sense? A wise man told me something about 6-7 MB (if I remember correct) Salu2 Horst Tiemo Hollmann TB wrote: Hi Bernard, noop, no front- or backscripts. Thanks Tiemo The reason why I asked was I identified a bug in R3 which slowed down all actions in fields (including the message box). That slow down was something to do with revMenuBar's menus being refreshed. The slow down DID NOT exist in 2.9, that's why I was making sure that you were not working on R3 and had forgotten :-) Now that there are two of you with this problem, I'm doubtful that the same solution will work! Anyway, have either of you introduced any frontscripts (or possibly backscripts - I've never used those), where you trap menuPick messages? Bernard On Wed, Sep 10, 2008 at 11:00 AM, Horst [EMAIL PROTECTED] wrote: volution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/slown-down-of-IDE-2.9-under-windows-tp19393010p19411973.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Stack opens behind Windows desktop
Holá Jacqueline, Thanks to try to be my personal hero and I would like to answer your question, but what do you mean with Are your stack's window decorations set to empty? Which decorations? Until now this problem occurs on one XP only. best regards Horst J. Landman Gay wrote: Horst wrote: Holá Jacqueline, Yes we have same problem here, no idea, why and thought, it would be a spanish problem :-) Working with Win 2000, Win XP and RR 2.9 I just compiled with Rev 3.0 and the problem is still there, but just for that one person. Are your stack's window decorations set to empty? I'm going to send this person a standalone with default decorations and see if that helps. Have you been able to find a consistent recipe? Is it always on only one machine or does it always happen to you? Ho finds a solution will be my hero! best regards Horst J. Landman Gay wrote: Odd Windows problem, that happens inconsistently: A standalone's mainstack has its decorations set to empty and is sized to the windowboundingrect. On launch, or sometimes when maximizing from the task bar, the stack window opens invisibly. One person described it as being behind the desktop. It can sometimes be brought back to view by pressing the Windows key on the keyboard, and when that key is released the stack pops back into view where it belongs. I've tried forcing it by specifically issuing the toplevel command and the show command on both openstack and uniconifystack. The client says it still sometimes fails to display. I've seen it happen only once, on launch, and couldn't reproduce it again. It never happens in the IDE. The stack is never made invisible or hidden; only its iconic is changed. This happens only on Windows, the Mac version goes to and from the dock without any problem. Has anyone seen this? -- Jacqueline Landman Gay | [EMAIL PROTECTED] HyperActive Software | http://www.hyperactivesw.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- Jacqueline Landman Gay | [EMAIL PROTECTED] HyperActive Software | http://www.hyperactivesw.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/Stack-opens-behind-Windows-desktop-tp19354380p19387566.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Stack opens behind Windows desktop
Holá Klaus, my mentor, Sometimes it is difficult enough to describe or understand a problem in my own language. But then in english? Puh... Of course, I didn't change the default settings. Thanks for the translation and your helpfull hand. Klaus Major wrote: Hola Horst, Holá Jacqueline, Thanks to try to be my personal hero and I would like to answer your question, but what do you mean with Are your stack's window decorations set to empty? Which decorations? The window decorations = titlebar, close button etc... I remember that all your windows decorations are just set to default, unless you have been experimenting in the last time :-) Until now this problem occurs on one XP only. best regards Horst Best Klaus Major [EMAIL PROTECTED] http://www.major-k.de ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/Stack-opens-behind-Windows-desktop-tp19354380p19389974.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Stack opens behind Windows desktop
Holá Jacqueline, Yes we have same problem here, no idea, why and thought, it would be a spanish problem :-) Working with Win 2000, Win XP and RR 2.9 Ho finds a solution will be my hero! best regards Horst J. Landman Gay wrote: Odd Windows problem, that happens inconsistently: A standalone's mainstack has its decorations set to empty and is sized to the windowboundingrect. On launch, or sometimes when maximizing from the task bar, the stack window opens invisibly. One person described it as being behind the desktop. It can sometimes be brought back to view by pressing the Windows key on the keyboard, and when that key is released the stack pops back into view where it belongs. I've tried forcing it by specifically issuing the toplevel command and the show command on both openstack and uniconifystack. The client says it still sometimes fails to display. I've seen it happen only once, on launch, and couldn't reproduce it again. It never happens in the IDE. The stack is never made invisible or hidden; only its iconic is changed. This happens only on Windows, the Mac version goes to and from the dock without any problem. Has anyone seen this? -- Jacqueline Landman Gay | [EMAIL PROTECTED] HyperActive Software | http://www.hyperactivesw.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/Stack-opens-behind-Windows-desktop-tp19354380p19367073.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Free Icons?
please look here http://www.famfamfam.com/lab/icons/silk/ best regards Inselfan -- View this message in context: http://www.nabble.com/Free-Icons--tp19243609p19243609.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: how to uniencode text for VCard v. 3.0? [2]
Hi Hugh, Yes, please sent also a copy to me best regards Horst Hugh Senior wrote: Hi Klaus, I just replied totally incorrectly to your UTF-8 query! Must be having a bad hair day... My apologies. To avoid converting the entire string to UTF8 (when it's only accented chars that need it), what I have done is store the decimal/UTF8/Hex character equivalents in a customproperty, then run each element value through this encoder... function UTF8.encode tStr put numtochar(13)numtochar(10) into tCRLF set the itemDel to TAB set the caseSensitive to TRUE repeat for each char L in tStr get chartonum(L) if it=160 then get lineOffset(CRitTAB, CRthe UTF8Table of this stack) --| Get the table line if it 0 then if VCVERS=2.1 then put toUpper(item 3 of line it of the UTF8Table of this stack) after stdout --| Use UTF8 else put toUpper(item 2 of line it of the UTF8Table of this stack) after stdout --| Use HEX end if else put L after stdout end repeat replace \ with \\ in stdout replace , with \, in stdout replace ; with \; in stdout replace CR with =0D=0A in stdout --| v2.1 WAB return stdout end UTF8.encode If the above looks of interest, let me know and I'll send you the look-up table of character equivalents . /H ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/Re%3A-how-to-uniencode-text-for-VCard-v.-3.0---2--tp17782967p17793506.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
printrotated ?? sometimes works sometimes not
Holá everybody, to print Landscape, I use the following in a button on the card: on mouseUp set the printmargins to 5,5,5,5 set the printrotated to true print card set the printrotated to false end mouseUp smiley ima That works sometimes and sometimes (same Card) not. What's wrong? Im working with 2.7.4 and w2k Thanks for your friendly help and best regards Horst -- View this message in context: http://www.nabble.com/printrotatedsometimes-works-sometimes-not-tp16081672p16081672.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: 2.9 dp-3 for linux has expired...!
Hi RunRev, why don´t all 2.9 testers get dp-4? Is there a selection or is it just a mistake? best regards Horst Peter Alcibiades wrote: OK, all good things come to an end. So where do I get the next one? Peter ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/2.9-dp-3-for-linux-has-expired...%21-tp15649708p15649932.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: UPDATE table and quote in a text
Hey Trevor, This works (of course) fine :-) Thanks a lot also to Mark and Viktoras Horst Trevor DeVore wrote: On Feb 17, 2008, at 5:23 PM, Horst wrote: I know, the easiest way would be to encode the data with base64encode. But there must also be a way to save a text f.e. like 1234'5'6öä'ioup# in a varchar or text type. With base64encode it will f.e. not be possible to use the fulltext indexing, which I will need. No, there must be another way. SQL is not that silly and I learned, that RR is a a powerfull tool, if you (or someone else) knows the tricks. Once again the question: How to save any text via RR to a SQL-Table as described before. Hi Horst, You can definitely insert any text into a database using Rev as long as you cleanse the input first. I've attached a modified handler from libDatabase that you can use to escape strings you want to use in an UPDATE clause. SQLite only requires for single quote to be escaped. MySQL has a slightly more complex escape sequence as does PostGreSQL. I haven't tested the postgresql code myself but I based the code off of some docs I found somewhere. Here is an example of how you could use it: ... put escapeStringForSQL(mysql, the text of field UserSuppliedData) into theData put format(UPDATE my_table SET user_data = '%s' WHERE ID = %u, theData, theID) into theSQL Regards, -- Trevor DeVore Blue Mango Learning Systems www.bluemangolearning.com-www.screensteps.com function escapeStringForSQL pDBType, pString switch pDBType case mysql replace numtochar(92) with numtochar(92) numtochar(92) in pString -- \ to \\ replace numtochar(39) with numtochar(92) numtochar(39) in pString -- ' to \' replace numtochar(34) with numtochar(92) numtochar(34) in pString -- to \ replace numtochar(0) with numtochar(92) numtochar(48) in pString -- NULL to \0 replace numtochar(26) with numtochar(92) numtochar(90) in pString -- Control-Z to \Z replace numtochar(10) with numtochar(92) numtochar(110) in pString -- newline to \n replace numtochar(13) with numtochar(92) numtochar(114) in pString -- carriage return to \r replace numtochar(9) with numtochar(92) numtochar(116) in pString -- tab to \t replace numtochar(8) with numtochar(92) numtochar(98) in pString -- backspace to \b break case postgresql replace numtochar(92) with numtochar(92) numtochar(92) in pString -- \ to \\ replace numtochar(39) with numtochar(39) numtochar(39) in pString -- ' to '' replace numtochar(12) with numtochar(92) numtochar(102) in pString -- formfeed to \f replace numtochar(10) with numtochar(92) numtochar(110) in pString -- newline to \n replace numtochar(13) with numtochar(92) numtochar(114) in pString -- carriage return to \r replace numtochar(9) with numtochar(92) numtochar(116) in pString -- tab to \t replace numtochar(8) with numtochar(92) numtochar(98) in pString -- backspace to \b break case sqlite default replace numtochar(39) with numtochar(39) numtochar(39) in pString -- ' to '' break end SWITCH end lib escapeStringForSQL___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15560555.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
UPDATE table and quote in a text
Hi there, A question to all SQL-Masters: To update a record in a SQL-Table and to store text which includes the sign in an SQL-Syntax I learnd, that it is necessary to use replace quote with \ quote in zText Well, that works fine, but what about The ' sign? replace ' with \' in zText seems NOT to work. Thanks a lot to all of you and best regards Horst -- View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15529083.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: UPDATE table and quote in a text
Holá Mark, The main question seems to be: How to include a textfile for example: .. put 1234'5'6öä'ioup# into mytext ## I know, this text is senseless, but never mind, it should be able to be saved replace quote with \ quote in mytext ## and then, how to replave the ' ??? put UPDATE table set textfile = ' mytext '... into sql_messqage revexecutesql (my_ID), sql_message put the result ## shows an SQL-Error message and mytext will not be saved .. best regards and, as usual, a big thank You for answering Horst Mark Schonewille-3 wrote: Dear Horst, Single quotes should be escaped the way you do and this should work fine. I have seen reports of commands starting with revdb being unable to escape single quotes, but this can be solved by using revExecuteSQL -- I don't know whether there really is a bug with escaping characters, I didn't encounter this problem myself. Make sure that you only replace single quotes that are part of the data and not the two single quotes that surround the string. Best regards, Mark Schonewille -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Convert colours between different colour spaces with Color Converter. Download at http://economy-x-talk.com/cc.html Op 17-feb-2008, om 13:24 heeft Horst het volgende geschreven: Hi there, A question to all SQL-Masters: To update a record in a SQL-Table and to store text which includes the sign in an SQL-Syntax I learnd, that it is necessary to use replace quote with \ quote in zText Well, that works fine, but what about The ' sign? replace ' with \' in zText seems NOT to work. Thanks a lot to all of you and best regards Horst -- View this message in context: http://www.nabble.com/UPDATE-table- and-quote-in-a-text-tp15529083p15529083.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15530593.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: UPDATE table and quote in a text
Holá Mark, ik wil u danken. I know, the easiest way would be to encode the data with base64encode. But there must also be a way to save a text f.e. like 1234'5'6öä'ioup# in a varchar or text type. With base64encode it will f.e. not be possible to use the fulltext indexing, which I will need. No, there must be another way. SQL is not that silly and I learned, that RR is a a powerfull tool, if you (or someone else) knows the tricks. Once again the question: How to save any text via RR to a SQL-Table as described before. best regards Horst Mark Schonewille-3 wrote: Hallo Horst, You could write a function to escape all special characters, but the easiest and most reliable way is to encode the data with base64encode () before storing it. Best regards, Mark Schonewille -- Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz Convert colours between different colour spaces with Color Converter. Download at http://economy-x-talk.com/cc.html Op 17-feb-2008, om 17:09 heeft Horst het volgende geschreven: Holá Mark, The main question seems to be: How to include a textfile for example: .. put 1234'5'6öä'ioup# into mytext ## I know, this text is senseless, but never mind, it should be able to be saved replace quote with \ quote in mytext ## and then, how to replave the ' ??? put UPDATE table set textfile = ' mytext '... into sql_messqage revexecutesql (my_ID), sql_message put the result ## shows an SQL-Error message and mytext will not be saved .. best regards and, as usual, a big thank You for answering Horst ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15535637.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: UPDATE table and quote in a text
Good morning Trevor, Thanks for that. I´ll try tomorrow and let you know here best regards Horst Trevor DeVore wrote: On Feb 17, 2008, at 5:23 PM, Horst wrote: I know, the easiest way would be to encode the data with base64encode. But there must also be a way to save a text f.e. like 1234'5'6öä'ioup# in a varchar or text type. With base64encode it will f.e. not be possible to use the fulltext indexing, which I will need. No, there must be another way. SQL is not that silly and I learned, that RR is a a powerfull tool, if you (or someone else) knows the tricks. Once again the question: How to save any text via RR to a SQL-Table as described before. Hi Horst, You can definitely insert any text into a database using Rev as long as you cleanse the input first. I've attached a modified handler from libDatabase that you can use to escape strings you want to use in an UPDATE clause. SQLite only requires for single quote to be escaped. MySQL has a slightly more complex escape sequence as does PostGreSQL. I haven't tested the postgresql code myself but I based the code off of some docs I found somewhere. Here is an example of how you could use it: ... put escapeStringForSQL(mysql, the text of field UserSuppliedData) into theData put format(UPDATE my_table SET user_data = '%s' WHERE ID = %u, theData, theID) into theSQL Regards, -- Trevor DeVore Blue Mango Learning Systems www.bluemangolearning.com-www.screensteps.com function escapeStringForSQL pDBType, pString switch pDBType case mysql replace numtochar(92) with numtochar(92) numtochar(92) in pString -- \ to \\ replace numtochar(39) with numtochar(92) numtochar(39) in pString -- ' to \' replace numtochar(34) with numtochar(92) numtochar(34) in pString -- to \ replace numtochar(0) with numtochar(92) numtochar(48) in pString -- NULL to \0 replace numtochar(26) with numtochar(92) numtochar(90) in pString -- Control-Z to \Z replace numtochar(10) with numtochar(92) numtochar(110) in pString -- newline to \n replace numtochar(13) with numtochar(92) numtochar(114) in pString -- carriage return to \r replace numtochar(9) with numtochar(92) numtochar(116) in pString -- tab to \t replace numtochar(8) with numtochar(92) numtochar(98) in pString -- backspace to \b break case postgresql replace numtochar(92) with numtochar(92) numtochar(92) in pString -- \ to \\ replace numtochar(39) with numtochar(39) numtochar(39) in pString -- ' to '' replace numtochar(12) with numtochar(92) numtochar(102) in pString -- formfeed to \f replace numtochar(10) with numtochar(92) numtochar(110) in pString -- newline to \n replace numtochar(13) with numtochar(92) numtochar(114) in pString -- carriage return to \r replace numtochar(9) with numtochar(92) numtochar(116) in pString -- tab to \t replace numtochar(8) with numtochar(92) numtochar(98) in pString -- backspace to \b break case sqlite default replace numtochar(39) with numtochar(39) numtochar(39) in pString -- ' to '' break end SWITCH end lib escapeStringForSQL___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15540022.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
How to show a picture from a MySQL Database
Holá everybody, working happy with mySQL since a few month now. But, I can´t figure out how to show a picture stored in the database. Don´t know if it´s base64 encoded or not. As usual, it will be easy, but please give me a hand best regards -- View this message in context: http://www.nabble.com/How-to-show-a-picture-from-a-MySQL--Database-tf4898240.html#a14029189 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: 2 slightly silly stacks
Hey Richmond, Can't find the stacks. Where did you put them? Best regards Horst Richmond Mathewson wrote: Just uploaded to RevOnline 2 stacks: 1. MachineDetails.rev ; illustration for the hardware info discussion 2. Finde.rev ; bl**dy silly really, but the by-product of some fairly infantile messing-around I was doing with FIND with a view to getting kids to make their own picture-dictionaries. sincerely, Richmond Mathewson A Thorn in the flesh is better than a failed Systems Development Life Cycle. ___ Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/2-slightly-silly-stacks-tf4436593.html#a12669460 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
QUARTAM Report
Hi there, Does anybody knows, when Version 1.1 will be out and, if the printout will be much better as now with all the printed pixels? A printout now looks like the needel-printer 20 years ago and this layout is out of discussion f.e. a professional invoice or other professional printouts. Does anybody has another idea? Best regards Horst -- View this message in context: http://www.nabble.com/QUARTAM-Report-tf3279004.html#a9119269 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
UPDATE SQL-DB maker Errors
Holá Erverybody, I´m Using RR 2.7.4 and MySQL 4.1 I try to update an existing record with put UPDATE post SET Mail_body = Mail_text ' where lfdnr = Mail_Number into SQL_Befehl revexecute DB_ID SQL_Befehl Sometimes it works, sometimes not. So I found out, if the Mail_Text includes one or ' the datas will not be Updated. OK, But, and that´s the question, How to solve the problem without changing the data to base64, because that seems to be a global problem an it makes no sense to convert all fields in my DB. I'm glad, if you have a helpfull hand thanks Horst -- View this message in context: http://www.nabble.com/UPDATE-SQL-DB-maker-Errors-tf3170373.html#a8794446 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: ejecting a disk after using the files funtion
Hi Richard, Could you please post the link to ³Listing and Sorting Files in Revolution²? That sounds interesting, but I can´t find the article. best regards Horst -- View this message in context: http://www.nabble.com/ejecting-a-disk-after-using-%22the-files%22-funtion-tf2937580.html#a8254294 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Variables in DB Query Builder
Hola Jan, thanks for answering! You wrote: For now the easiest way to achieve dynamic queries is to save a template query somewhere, and fill in the dynamic parts, then update the SQL of the query using the undocumented command 'revSetSQLOfQuery name of the query,sql statement. An example : ## on mouseUp put 123456 into tCustomerID # or some field data put SELECT * FROM orders WHERE customerid=' \ tCustomerID ' into tSQLStatement revSetSQLOfQuery orders,tSQLStatement end mouseUp ## - Well, but what does this do? I don´t understand that. What to do with revSetSQLOfQuery orders,tSQLStatement best regards Horst -- View this message in context: http://www.nabble.com/Variables-in-DB-Query-Builder-tf2832420.html#a7948998 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Commands out of sync, you can ´ t run t his command now
Good morning Ken, You wrote: I guess the only thing left to do is restart mySQL (either by restarting the server or at the command line) unless someone else has a better idea... Ok, But How? shut down the PC and start again? Yes, the PC that is actually running mySQL server (i.e. not a client PC that is simply *accessing* mySQL). Well, That´s (Shutdown the PC) what I did a few minutes ago. The message is still the same. Anybody with another idea? Thank you and best regards Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7904307 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Commands out of sync, you can ´ t run t his command now = FIXED NOW
Hello everybody, I´m happy that I found the reason for the message. I just changed revexecuteSQL DB_ID, SQL_Befehl to get revQueryDatabase (DB_ID, ... That´s it Thank you all for your help Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7904882 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Variables in DB Query Builder
Holá SQL-Professionals, I´m thinking, how to put a variable Part in the SQL-Message of the DB Query builder f.e. Select Landname, Landvorwahl from land_kz where Landname BETWEEN A% AND ¦ ORDER BY Landname ASC; How to put the variable instead of A% witch makes by the way, no sense. Thanks for many good ideas and don´t let me alone :-) Best regards Horst -- View this message in context: http://www.nabble.com/Variables-in-DB-Query-Builder-tf2832420.html#a7907686 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Commands out of sync, you can´t run this comman d now
Hi There, Do you know this message? And if so, what does it mean? best regards Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7894721 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Commands out of sync, you can ´ t run thi s command now
Hi Ken, Thanks for answering :-)) You wrote: The only thing you can do (AFAIK) is close your connection to the server and then reopen it and try again. Well, that´s what I have done by closing RunRev. Than, I tried again, same message. So I uninstalled RunRev, deleted all RunRev Folders, to be sure, that nothing is working som ewhere behind. Installed RunRev again and... ... YES, the same message :-( Must be something else I think best regards Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7896415 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Commands out of sync, you can ´ t run thi s command now
Hi friends, I do (as possible) what ever you want me to do! It happens here: on closefield GLOBAL kundennummer, DB_ID ### Land Aendern # put the text of me into temp3 put Select * from land_kz where Kfz_Kennz = ' temp3 ' into SQL_Befehl revexecuteSQL DB_ID, SQL_Befehl ## I hope, it helps. best regards Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7897154 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Commands out of sync, you can ´ t run th is command now
Hi Ken, You say: I guess the only thing left to do is restart mySQL (either by restarting the server or at the command line) unless someone else has a better idea... Ok, But How? shut down the PC and start again? Well, I´m happy, that mySQL is running and I never thought about restarting Thank you Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7899560 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
