Re: 7.0.0 dp 5
When I opened a couple of large stacks I use every day in the stable version of 7.0 CE, both stacks got corrupted on the first save. This happened twice in a row, so I've now gone back to 6.5.2. -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: repeat with each
On Mon, Sep 22, 2014 at 6:13 AM, Mark Schonewille m.schonewi...@economy-x-talk.com wrote: repeat for each word myWord in field Just One put thisWord comma after myNewdata end repeat sort items of myNewData put char 1 to -2 of myNewData into field Just One This loop generates a string that (1) starts with an empty item and (2) repeats the word thisWord, deleting the last d. (1) The last item after the loop finishes is empty -- the comma at the end. After the sort, however, that comma is at the front of the variable. A simple solution would be to replace the last line with put char 2 to -1 of myNewData into fld Just One (2) Instead of put thisWord, it should be put myWord. Or, repeat for each word thisWord -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Windows 7 and the plugin
We have a client with a brand new Windows 7 installation and freshly downloaded Firefox, reporting: Upon following the mailed task link or the link to install the plugin I am prompted to allow access. Regardless of what I do at this point, I subsequently receive a notification There was an error loading the revlet - error processing revlet and firefox hangs. I have not been able to proceed further or in any other direction. Task Manager is required to shut down Firefox. We'll do a screen sharing session next week so we can see it happen, but I thought I'd ask if anyone's had similar issues and could offer pointers. -- Paul -- White Feather Software www.whitefeather.com Cell: 408-391-1480 Skype: pwforaker ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
[OT] 13 essential programming tools for the mobile Web | Mobile Technology - InfoWorld
http://www.infoworld.com/d/mobile-technology/13-essential-programming-tools-the-mobile-web-246 *When it comes to programming for mobile devices, choice quickly becomes dilemma. Do you target the lucrative iPhone market at the expense of Android's rising tide? Do you go native or write code to the mobile Web? And while a single stack of code that performs optimally on an increasingly wide array of platforms, form factors, and devices would be the dream, the reality is a fragmented trial in which rudimentary tasks can often be a challenge. *I'm thinking maybe the author missed something. -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Apostrophe and UPDATE
While building a LiveCode front end to a MySQL database, I ran into the apostrophe-in-the-data problem. My friend O'Byrne cannot get updated. For INSERTs, the variable substitution method works great -- I can post O'Byrne's name as a new record. But, what should I do about UPDATE ? Here's my test code: code on testUpdate global gCRMdbID put last_name,notes into tFields put fld contact_id into tID put fld last_name into tLastName put fld notes into tNotes put UPDATE contact SET ( tFields ) VALUES (:1, :2) WHERE id= tID into tSQL revExecuteSQL gCRMdbID, tSQL, tLastName, tNotes if the result is NOT a number then answer error There was a problem adding the record to the database: cr the result as sheet exit to top end if end testUpdate /code ERROR MESSAGE in the result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(last_name,notes) VALUES (O\'Byrne, betting this won\'t work!) WHERE id=599' at line 1 Any suggestions? Thanks, -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Apostrophe and UPDATE
Stephen, escaping the single quote with another quote causes the same error, with the result showing \'\' instead of \'. I tried it with and without variable substitution. Monte, my UPDATE syntax was incorrect. Thanks! In case anyone else needs something like this, here's the code that worked: code on testWrap put the fldNames of this cd into tFldNames delete item 1 of tFldNames -- contact_id put getSQLWrappers(contact,tFldNames) into temp answer temp end testWrap function getSQLwrappers pTableName, pFldNames -- takes a list of field names and returns them wrapped for SQL -- removes _ in fld names, prepends t and uses CamelCase -- so last_name becomes tLastName put UPDATE pTableName SET into tSQL repeat for each item thisOne in pFldNames put thisOne = ' varNameFromFldName(thisOne) ', after tSQL end repeat delete last char of tSQL -- remove last chars delete last char of tSQL put WHERE id = ' tID ' after tSQL return tSQL end getSQLwrappers function varNameFromFldName pFldName set itemDelimiter to _ put t into varName repeat for each item thisOne in pFldName put toUpper(char 1 of thisOne) into char 1 of thisOne put thisOne after varName end repeat return varName end varNameFromFldName /code -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Apostrophe and UPDATE
On Wed, Oct 9, 2013 at 1:32 AM, stephen barncard stephenrevoluti...@barncard.com wrote: Stephen, escaping the single quote with another quote causes the same error, with the result showing \'\' instead of \'. I tried it with and without variable substitution. thanks, Paul. This goes in my Script Scrapbook. Turns out I wasn't thinking clearly last night. My test for wrapping the variable names seemed to work but the error checking was flawed. The SQL that got executed included the variable name tID instead of the value, so MySQL returned a 0 -- no rows updated. The error checking didn't acount for that. When I replaced the variable name with the actual ID, the row got updated with all the variable names. So, that little script is broken. -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Apostrophe and UPDATE
On Wed, Oct 9, 2013 at 7:02 AM, Dr. Hawkins doch...@gmail.com wrote: You're using the wrong escape. Inside a string, you need a double single quote, not a backslash. It's worth keeping a preSql() function around, like: function preSQL pSQL replace ' with '' in pSQL if pSQL is empty then return NULL else return ' pSQL ' end if end preSQL Thank you, Dr Hawkins. Problem solved. Now if I can just get my brain to do an UPDATE. -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Counting Lines
I have a WordPress form on my website that sends me an email when someone fills it out. I've written a stack that parses that email into tab-delimited lines for pasting into a spreadsheet. On the Mac (iMac, 10.7.5), but not on the PC (Vista), LiveCode is discarding a blank line in the data. Here is the raw Data as copied from Firefox in Gmail and pasted into BBEdit (which, curiously, discards the bullets in the list): == Wait List On: Jan 9, 2014 @ 12:28 PM IP: 98.207.89.163 First Name: That Last Name: Guy Address 1: 5427 Streetname Address 2: City: Newark State/Province: CA ZIP/Postal Code: 94560 Country: US Phone Number: 408-555-1212 Email Address: someb...@yahoo.com == Counting the blank line, there are 14 lines in that data. When I copy it from Firefox to the Clipboard and then ask LC how many lines there are in the data, it comes back with 13 on my Mac. When I put it into a fld, the line count is 13. On my customer's PC, the line count = 14. Here is the data after processing on the Mac in LiveCode to prepend line numbers. Note the missing empty line (and the bullets, curiously, are preserved). === 1 Wait List 2 On: Jan 9, 2014 @ 12:28 PM 3 IP: 98.207.89.163 4 • First Name: That 5 • Last Name: Guy 6 • Address 1: 5427 Streetname 7 • Address 2: 8 • City: Newark 9 • State/Province: CA 10 • ZIP/Postal Code: 94560 11 • Country: US 12 • Phone Number: 408-555-1212 13 • Email Address: someb...@yahoo.com === Here is the script that appends the line numbers: on testLines put getClip() into theLines repeat with i = 1 to the number of lines in theLines put i tab before line i of theLines end repeat setClip theLines end testLines -- getClip() and setClip are clipboardData[text] handlers in use. So: On the PC, LiveCode counts 14 lines. On the Mac, it discards the blank line and counts 13 lines. Apparently, I need to write different parsing functions for the platforms. Is this a bug, or am I missing something? Or both. :) -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Problem with iRev refresh
I'm working on a registration page for a training ( www.blueskytrainings.com/register.irev ). I'm having a problem with Safari and Chrome improperly refreshing to a PayPal page. I'm on a Mac. The following code works perfectly in Firefox and Camino. It fails to go to PayPal in Safari and Chrome. When I copy the URL and paste it into Safari, it works. But, from the irev page, I get a blank page and no PayPal URL (keeps the original URL). Any suggestions? put https://www.paypal.com/cgi-bin/webscr; into tURL if getsDiscount then put Discounted into tuitionValue else put Full+Tuition into tuitionValue put ?cmd=_s-xclickhosted_button_id=D88XBUTK3GS2Aon0=Training+Fee into tPost put os0= tuitionValue after tPost put currency_code=USD after tPost put tPost after tURL put format(meta http-equiv=\refresh\ content=\0;URL= tURL ) into thePlaceToGo put thePlaceToGo -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Problem with iRev refresh
Thank you, Sarah, but that didn't work. Safari and Chrome still fail to reach the PayPal site. Testing some more, I found an odd error using IE on Windows NT. IE also fails to go to PayPal, but instead it puts the following URL onto a blank page: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclickhosted_button_id=D88XBUTK3GS2Aon0=Training+Feeos0=Full+Tuition ¤cy_code=USD Note in the last dozen characters, the string currency_code=USD has been replaced with ¤cy_code=USD (whatever that character is; can't get its charToNum). Is there some special meaning to curren? Firefox on Windows works fine. A standard PayPal button works fine with Safari. Maybe I have to give up and move the PayPal functionality outside of the LiveCode handlers again. That would be unfortunate as it means the user has to fill out and submit a form, and then click another button to go to PayPal. Hmm... On Mon, Mar 7, 2011 at 5:19 PM, Sarah Reichelt sarah.reich...@gmail.comwrote: My only suggestion would be to try using lower case url in the meta tag. All the examples I have seen are lower case e.g. content=0;url=http://whatever.com Maybe some browsers are more picky than others about such things. Cheers, Sarah ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Problem with iRev refresh
Problem solved (thank you, Cristophe!). Instead of put format(meta http-equiv=\refresh\ content=\0;url= tURL ) into thePlaceToGo put thePlaceToGo which fails on Safari, Chrome and IE. This works perfectly on all tested browsers: -- put format(meta http-equiv=\refresh\ content=\0;url= tURL ) into thePlaceToGo put new header Location: tURL put test -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Problem with iRev refresh
Thanks, Alex, yeah, that's obviously an error. Since I got it working the other way, I won't mess with the code now, but I'll know to look more intensely next time. On Tue, Mar 8, 2011 at 5:20 AM, Alex Tweedly a...@tweedly.net wrote: I think the quotes are strangely placed in the 'format' statement below (assuming it was copied/pasted). put format(meta http-equiv=\refresh\ content=\0;URL=tURL ) into would produce meta http-equiv=refresh content=0;URL=https.. There should be another \ after the 0 for content. Might be that some browsers can figure out what was intended and some can't. -- Alex. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Problem with iRev refresh
On Tue, Mar 8, 2011 at 3:51 AM, Jan Schenkel janschen...@yahoo.com wrote: Aren't you missing a quote after tURL to close the content attribute? Or is that a typo when you wrote the email? ## put format(meta http-equiv=\refresh\ content=\0;url= tURL \) into thePlaceToGo put thePlaceToGo ## There is a missing quote, but as Alex pointed out, it's after the zero. Some source ssuggest that you should use both a redirect, and a meta refresh tag to make sure everything works on all browsers. Interesting... thanks. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Can't close windows
As of a few weeks ago, I can no longer close stacks by clicking their red close button (Mac OS 10.6.6, LC 4.0.0). I have to use File / Close (Cmd W). Any ideas what might be happening with that? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Incredibly slow revlet in Win 7
I'm having an ongoing issue with a Win 7 user for whom our otherwise snappy revlet runs incredibly slowly. Three to 5 minutes to load the revlet is not uncommon. Once he opened the web page, left his desk, came back 20 minutes later and the revlet just then finished loading. He's running a brand new installation of Win 7 on a fairly new computer. No other web or desktop apps are behaving like this. Any suggestions on what we might try? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Incredibly slow revlet in Win 7
Here's some more information from my user: My system is generally superfast, being a fast quad processor, with 8GB of RAM and an SSD drive. I updated the video drivers yesterday and as mentioned, refreshed the operating system last week. I am running 64 bit Windows 7. I have not yet updated to Service Pack 1. Just ran another test while watching performance indicators on my system. Everything remained quite quiet. There was networking activity of about 35K bytes/second. But speedtest.net just reported my overall speed of 22Mbps downstream and 4Mbps upstream, so 35K isn't pushing any limits on my network. The big time chunk is before the revlet loading page even shows up. Once the revlet starts loading it is only a few seconds until I am ready to login. On Tue, Mar 29, 2011 at 9:49 PM, paul foraker p...@whitefeather.com wrote: I'm having an ongoing issue with a Win 7 user for whom our otherwise snappy revlet runs incredibly slowly. Three to 5 minutes to load the revlet is not uncommon. Once he opened the web page, left his desk, came back 20 minutes later and the revlet just then finished loading. He's running a brand new installation of Win 7 on a fairly new computer. No other web or desktop apps are behaving like this. Any suggestions on what we might try? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Incredibly slow revlet in Win 7
Thanks, Jacque. On Wed, Mar 30, 2011 at 8:49 AM, J. Landman Gay jac...@hyperactivesw.comwrote: If he's stalling out before your page even loads, it isn't a revlet issue. Sounds more like a DNS issue. What happens if you give him the IP numbers of the URL instead of using the standard named URL? That would bypass DNS. When I use Network Utility to ping the page, the IP address I get back refers to a generic Apache page. How do I find the IP address of the subdomain? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Error in Windows standalone
I've built a little app that is generating a script error on Windows 7, but not on XP or Mac. On Win 7, the app generates this error message: Executing at 2:58:29 PM Type Object card id 1002 Lineput 'Object' tab the short name of tObject cr after tErrorString HintpreOpenCard I don't have access to the Win 7 machine to run the stack in LiveCode, so I'm relying on my user to run the standalone and let me know how it goes. So far, not so good. The stack is a one-card stack with a data grid and the revExternalLibrary for MySQL support. All three stacks have a card id 1002, but none of them have scripts. There is no preOpenCard handler in any object in the stack files. There is no such command as in the line above in use in any script that I can find. On preOpenStack, the main stack opens a file on the user's hard drive, using this code: function actionFile pFname if the platform contains Mac then put specialFolderPath(Preferences) into tPath else -- windows put 0x000C into myDocs put specialFolderPath(myDocs) into tPath end if put /4Spires after tPath if there is no folder tPath then create folder tPath put / pFname .txt after tPath return tPath end actionFile I'm passing this function the string ActionHistoryURLs which is the name of a file containing a return-delimited list of urls the user has entered. If there are none yet, I use a default url instead. I use the first one in the list (or the default one) to open a file on the server containing encrypted database configuration information. I decrypt the config info and execute a query to get the action history from the database, and then populate the datagrid. Works fine on Mac and XP. Chokes on Win 7 in two ways. First, it never gets the data from the default url; second, when the user clicks that default url in a list, it should go get the data. That's when the interrupt occurs, and he sends me the error message. I'm wondering if this error is occurring in some part of the engine code instead of mine, and what's up with the single quotes in the command? Any ideas? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Error in Windows standalone
Seems like if it were the case that the datagrid library did not get included, it would also fail on Win XP, no? It works fine there and on Mac. On Mon, Apr 11, 2011 at 6:11 PM, Andrew Kluthe and...@rjdfarm.com wrote: I had this happen on windows 7 when it opened cards with datagrids. The datagrid library was not being included in the stand alone. -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Error-in-Windows-standalone-tp3443299p3443496.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Error in Windows standalone
So, if the error is in the error script, and the error is the single quotes around Object when they should be double quotes, how do I fix that? And, why would it work on Mac XP, but not Win 7? I'm so foncused. However, maybe I'm doing something wrong in the specification of the place to save the preferences file. I tried using the CSIDL, which is supposedly still included in Win 7 for backward compatibility. So, I switched to Documents. That again works on XP, but didn't work on Win 7, same error, and [new clue] no file written to the user's hard drive. Here's the possibly offending code: function actionFile pFname if the platform contains Mac then put specialFolderPath(Preferences) into tPath else -- windows -- put 0x000C into myDocs put Documents into myDocs put specialFolderPath(myDocs) into tPath end if put /4Spires after tPath if there is no folder tPath then create folder tPath put / pFname .txt after tPath return tPath end actionFile -- Paul On Mon, Apr 11, 2011 at 10:06 PM, J. Landman Gay jac...@hyperactivesw.comwrote: On 4/11/11 5:27 PM, Paul Foraker wrote: I've built a little app that is generating a script error on Windows 7, but not on XP or Mac. On Win 7, the app generates this error message: Executing at 2:58:29 PM Type Object card id 1002 Lineput 'Object' tab the short name of tObject cr after tErrorString HintpreOpenCard Ignore what I just said. The error references the script that's creating the error dialog. Talk about recursion. The error script can't create itself because there's an error in the error script. Not sure why it's triggering on preOpenCard, but maybe it's refering to one of LiveCode's front or backscripts. I'm not sure it helps much to know that. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Error in Windows standalone
On Wed, Apr 13, 2011 at 3:28 PM, J. Landman Gay jac...@hyperactivesw.comwrote: I'm still thinking there's a permissions problem somewhere, and that's why the script is causing an error. It also looks like a bug in LiveCode's error reporting for some reason. My user ran a search for the file name and got no hits. I asked him to look in My Documents for the folder and it was there, and the file was inside it. Expletive. So, it's not a permissions problem. I'm writing to that file just fine. So, now I'm thinking it must be in the code accessing the MySQL database. Again, works fine on Mac and XP, just not on his Win 7. Since launching the little app is taking up to a minute, I'd guess that the code accessing the database is choking. I'll add a log handler to see what's coming back. I suppose there's also the possibility that there's a problem with his network or firewall. I'll see if I can borrow a Win 7 machine. Thanks for thinking about this, -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Apps stop launching
Over the past several days, I've noticed that my standalone apps will no longer launch. They try to launch and then quit before getting to the first card. These are simple apps that aren't doing anything interesting on launch. I have to go back to the original stack and build a new standalone. Anyone know what's up with that? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Cannot use Message Box
Ever since I installed version 4.6.1, the Message Box no longer responds to Return or Enter. I can type in it (both single and multi-line) but cannot execute anything. Weirdly, this also happens now with previous versions. I have made no changes to a utility stack I keep in the back, and this occurs with any stack I open. I tried searching for returnKey in all stacks. Nada. Anyone got a suggestion as to what to try next? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Cannot use Message Box
Thanks, Craig, but unfortunately that didn't fix it. It's very odd being completely without command line! On Sat, May 7, 2011 at 8:14 AM, dunb...@aol.com wrote: This happened to me a few months ago, though it went away. It resolves itself if, when you first open the msg box, you click in the lower field and hit return. From then on all is well. A thread I started at that time was inconclusive, some not knowing what I was talking about, some having seen the behavior now and then. I saw this in v.4.0 through 4.5. Never in 3.x. I thought it was something in the 4x build. That it went away is odd, but gratifying. Craig Newman -Original Message- From: Thomas McGrath III mcgra...@mac.com To: How to use LiveCode use-livecode@lists.runrev.com Sent: Sat, May 7, 2011 8:41 am Subject: Re: Cannot use Message Box This might not help, but the multi line message box uses the enter key and not the return key. Try turning on Livecode UI elements in Lists and then search through those stacks. -- Tom McGrath III http://lazyriver.on-rev.com 3mcgr...@comcast.net On May 7, 2011, at 4:59 AM, paul foraker wrote: Ever since I installed version 4.6.1, the Message Box no longer responds to Return or Enter. I can type in it (both single and multi-line) but cannot execute anything. Weirdly, this also happens now with previous versions. I have made no changes to a utility stack I keep in the back, and this occurs with any stack I open. I tried searching for returnKey in all stacks. Nada. Anyone got a suggestion as to what to try next? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode -- White Feather Software www.whitefeather.com Cell: 408-391-1480 Skype: pwforaker ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Cannot use Message Box
On Sat, May 7, 2011 at 5:41 AM, Thomas McGrath III mcgra...@mac.com wrote: This might not help, but the multi line message box uses the enter key and not the return key. Yeah, the Enter key in the multiline box doesn't work either. Try turning on Livecode UI elements in Lists and then search through those stacks. Thanks, I just now tried that. The only stack with returnKey is revRotate and it's in a card script. -- White Feather Software www.whitefeather.com Cell: 408-391-1480 Skype: pwforaker ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Cannot use Message Box
On Sat, May 7, 2011 at 1:47 PM, paul foraker p...@whitefeather.com wrote: Thanks, I just now tried that. The only stack with returnKey is revRotate and it's in a card script. Turns out that the Find interface does not find all occurrences in the rev stacks. I searched for rawKeyDown and it did not find the rawKeyDown in the messagebox.rev stack. So, I'm stumped. Something is trapping return and enter in my Message Box. I can type Return and Enter in the Message Box results field, but not in the command line. In the multiline Message Box, I can type Return in the command lines field to enter more than one line of code, but Enter does nothing. The modifier keys don't help. This problem is happening on my iMac, 10.6.7, with all versions of Rev and LiveCode on my drive. None of them has a functioning Message Box. I can type in it, but cannot execute. I have no stacks in use, and no plugins loaded. This is not happening on my laptop, also 10.6.7. I can drag out a button and execute one-liners from that, but that's not really an acceptable workaround. I'll send a request to support. -- Paul -- White Feather Software www.whitefeather.com Cell: 408-391-1480 Skype: pwforaker ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Cannot use Message Box
In my case, I continue to have the problem (cannot execute from Message Box) after restarting the computer, and launching LiveCode without having launched Chrome. (I wonder if Chrome is doing something without having been launched.) So, I used fast user switching, switched to another user and launched LiveCode for the first time, registered, and it works! The Message Box is functional. I'll try the deleting bad globals idea in the original user space. Much gratitude for the support here. This is a terrific community. -- Paul On Sun, May 8, 2011 at 7:52 AM, Mark Talluto use...@canelasoftware.comwrote: There is a bug in LC that is revealed when Google Chrome gets an update. It make a $variable dirty. If you restart your computer the issue will go away. Mark Waddingham is aware of the issue. -Mark Canela Software On May 7, 2011, at 4:45 PM, Pete p...@mollysrevenge.com wrote: Hi Phil, I'm thinking my problem was the same as yours. If I right-clicked a control then selected the Edit Script option, the cursor changed to a watch and no script editor window was displayed. Repeated the same thing and I got a script editor window. I could edit scripts OK but if I clicked the Variables tab, the variables displayed briefly then disappeared again. I use Google Chrome as my main browser so I'll bet it was the same problem. Out of interest, do you know what the variable name was? Pete Molly's Revenge http://www.mollysrevenge.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode -- White Feather Software www.whitefeather.com Cell: 408-391-1480 Skype: pwforaker ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Cannot use Message Box
I too am thinking this Message Box problem is somehow related to problems with the Script Editor. When I open a script, I cannot display the variables. When I click on the Variables tab, I get $Apple_PubSub_Socket_Render displaying for a brief moment and then whichever tab was selected previously gets reselected. -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Incredibly slow revlet in Win 7
All my domains hosted at RunRev return the same IP address: 74.54.153.71, which makes it impossible to enter the IP address instead of, say, beta.4spires.com On Wed, Mar 30, 2011 at 1:23 PM, J. Landman Gay jac...@hyperactivesw.comwrote: There are several web resources, here's one I just found: http://www.hcidata.info/host2ip.htm ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Incredibly slow revlet in Win 7
On Fri, May 13, 2011 at 10:14 AM, J. Landman Gay jac...@hyperactivesw.comwrote: I think it will be something like: http://74.54.153.71/beta/default.html Put in the actual landing page html or php or whatever for the last item. Nope... Apache doesn't find the page, even with the full path for my account and the subsequent directories. I think it's his firewall. -- White Feather Software www.whitefeather.com Cell: 408-391-1480 Skype: pwforaker ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Cannot use Message Box
Build 1392 fixed the Chrome variable problem for LC 4.6.1, but no previous version of LC works on my machine in the current user. By not working I mean that I cannot type in the Message Box, and I cannot check the variables in the Script Editor. The workaround for me at the moment is to switch users. For some reason, another user on this computer does not have that problem, even with Chrome running. -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Checkbox with dash?
The Mac interface guidelines indicate that a checkbox has two states, checked and unchecked. Except when it has a third state, dashed, indicating that not all the conditions are met for checking or unchecking. I have a field states containing a list of the states of the U.S. and a set of checkboxes for the regions: Northeast, East, West, etc. If the user clicks Northeast, the checkbox gets checked, and the associated states get hilited in the field. If the user then clicks in the states field to unhilite New York, the state of the Northeast checkbox should change to dashed. I tried converting the checkboxes to a list in a field and setting char 1 of each line to an image of a checkbox checked, unchecked, or dashed. That doesn't work because the baseline of the name of the region appears at the baseline of the image; that is, too low. The label (Northeast) needs to appear at the midline of the image. I don't see a way to move the image down on the line. Another approach would be to put a transparent field containing a dash over the checkbox, in its unchecked state. Handling the location and multiple ways the state can change started to get awkward and unwieldy. Is there a better way to do this? Thanks -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Windows App Can't Find File Menu
A standalone I built on my Mac for both Mac and Windows can't find the custom menus when I run it in Windows. The error message I get on launch: Executing at 10:49:05 AM on Friday, January 25, 2013 Type: Chunk: no such object Object: stack //psf/Home/Desktop/Send AricaNews.exe Line: enable menu File Line Num: 7 Hint: true Works fine on the Mac. The referenced code is: on openStack if the number of this cd 1 then go cd 1 set the visible of grp editors to the platform = MacOS if fld input is empty then retrieveAcopy if the environment development then enable menu File enable menu Edit enable menu Organization end if end openStack In the Standalone Application Settings, I have General: Search for required inclusions..., Remove all profiles... LiveCode 4.6.1, Windows XP Any ideas what I'm doing wrong? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Windows App Can't Find File Menu
Thanks, Bob. I'm not sure I understand. I'm not trying to open a file. It's a button in the stack that can't be found (by the stack itself). On Fri, Jan 25, 2013 at 12:29 PM, Robert Sneidar slylab...@me.com wrote: Hmmm... Parallels Shared Folder is what that file is. I wonder, is it mapped to a drive letter? If so, use that path instead. Bob ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Google OAuth2 For Native Apps
I see that in 2011 there were some conversations about building a library or two for Google OAuth2. Is there anything available now? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
What's with the spaces?
A couple of days ago, I noticed that when I copied a cell from Excel and pasted it into a field in LiveCode (4.6 and 6.0.2), the data got padded with spaces. Not having time to debug it, I passed the data through a trim() function. Today, a script I use to parse text copied from an email into a database stack, broke. Looking in the Variables panel, I see all the variables are padded with spaces. The first thing I do in that script is put the Clipboard into a variable and convert it to an array. The keys of the array are fine. The elements are padded with 12 spaces before, none after. Going back to the Excel spreadsheet... when I copy a cell and paste it into BBEdit, no spaces. When I paste it into a LiveCode field, it gets padded (12 spaces before and after). My normal state of low grade bewilderment and befuddlement is seriously tweaked. Anyone have an idea of what's happening? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: What's with the spaces?
Correction, they're not spaces, but are non-breaking spaces (#160) coming from the email (Gmail account open in Chrome). They are spaces (#32) coming from Excel. On Tue, Jun 25, 2013 at 1:02 PM, Paul Foraker p...@whitefeather.com wrote: A couple of days ago, I noticed that when I copied a cell from Excel and pasted it into a field in LiveCode (4.6 and 6.0.2), the data got padded with spaces. Not having time to debug it, I passed the data through a trim() function. Today, a script I use to parse text copied from an email into a database stack, broke. Looking in the Variables panel, I see all the variables are padded with spaces. The first thing I do in that script is put the Clipboard into a variable and convert it to an array. The keys of the array are fine. The elements are padded with 12 spaces before, none after. Going back to the Excel spreadsheet... when I copy a cell and paste it into BBEdit, no spaces. When I paste it into a LiveCode field, it gets padded (12 spaces before and after). My normal state of low grade bewilderment and befuddlement is seriously tweaked. Anyone have an idea of what's happening? -- White Feather Software www.whitefeather.com Cell: 408-391-1480 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
[OT] Problem with MySQL Insert
In a table in a MySQL database, I need a field displaying a time period
corresponding to the half hour period during which a record was posted. The
period is in the form HH:MM-HH:MM AM|PM. I have set the field type to
VARCHAR(10) and LiveCode is passing the string to the query handler. MySQL
is interpreting the incoming text as a date and converting it to my local
offset from server time.
In the Variable Watcher, before the revExecuteSQL, the pPeriod has the
correct time period; e.g., 11:00-11:30 PM. In the database, Sequel Pro
shows the period field with a value of 6:00-6:30 PM when Jacque in
Minnesota posts the record at 11:00 PM Minnesota time, and 4:00-4:30 PM
when I do it in California.
I'm surprised that MySQL is doing this interpretation of a character string
to a time value. How do I prevent that from happening?
In Sequel Pro, I entered this command:
INSERT INTO report
(`shortdate`,`period`,`dsp_id`, `dsp_name`, `client_id`,`client_name`,
`behavior_label`, `behavior_desc`, `observed`)
VALUES (3/15/2014,12:30-1:00
PM,22,fred,22,lucy,jumping,high,1)
and the period field correctly displayed 12:30-1:00 PM.
Here's the LiveCode handler:
on sendReport pShortDate,pPeriod,pDSPid,pDSPname,pClientID,pClientName,pRows
getConnected ## establishes the database connection
set the itemDel to tab
put INSERT INTO report (`shortdate`,`period`,`dsp_id`, `dsp_name`,
`client_id`,`client_name`, `behavior_label`, `behavior_desc`, `observed`)
\
VALUES into tSQL
repeat for each line thisRow in pRows
put (' pShortDate ', ' pPeriod ', ' pDSPid ', '
pDSPname ', ' pClientID ', ' pClientName ', ' \
item 1 of thisRow ', ' item 2 of thisRow ', ' item 3
of thisRow '), after tSQL
end repeat
put ; into last char of tSQL
revExecuteSQL gBTdbID,tSQL
...
Any ideas how to do this?
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Re: [OT] Problem with MySQL Insert
Now that I think about this, is this a 'feature' of revExecuteSQL ? A
string that looks like a time gets coerced by the command into a time and
adjusted for time zone without regard to the field type of the destination
database field. Can that be what's happening?
On Tue, Mar 24, 2015 at 9:48 PM, Paul Foraker p...@whitefeather.com wrote:
In a table in a MySQL database, I need a field displaying a time period
corresponding to the half hour period during which a record was posted. The
period is in the form HH:MM-HH:MM AM|PM. I have set the field type to
VARCHAR(10) and LiveCode is passing the string to the query handler. MySQL
is interpreting the incoming text as a date and converting it to my local
offset from server time.
In the Variable Watcher, before the revExecuteSQL, the pPeriod has the
correct time period; e.g., 11:00-11:30 PM. In the database, Sequel Pro
shows the period field with a value of 6:00-6:30 PM when Jacque in
Minnesota posts the record at 11:00 PM Minnesota time, and 4:00-4:30 PM
when I do it in California.
I'm surprised that MySQL is doing this interpretation of a character
string to a time value. How do I prevent that from happening?
In Sequel Pro, I entered this command:
INSERT INTO report
(`shortdate`,`period`,`dsp_id`, `dsp_name`, `client_id`,`client_name`,
`behavior_label`, `behavior_desc`, `observed`)
VALUES (3/15/2014,12:30-1:00
PM,22,fred,22,lucy,jumping,high,1)
and the period field correctly displayed 12:30-1:00 PM.
Here's the LiveCode handler:
on sendReport
pShortDate,pPeriod,pDSPid,pDSPname,pClientID,pClientName,pRows
getConnected ## establishes the database connection
set the itemDel to tab
put INSERT INTO report (`shortdate`,`period`,`dsp_id`, `dsp_name`,
`client_id`,`client_name`, `behavior_label`, `behavior_desc`, `observed`)
\
VALUES into tSQL
repeat for each line thisRow in pRows
put (' pShortDate ', ' pPeriod ', ' pDSPid ', '
pDSPname ', ' pClientID ', ' pClientName ', ' \
item 1 of thisRow ', ' item 2 of thisRow ', ' item 3
of thisRow '), after tSQL
end repeat
put ; into last char of tSQL
revExecuteSQL gBTdbID,tSQL
...
Any ideas how to do this?
--
White Feather Software
www.whitefeather.com
Cell: 408-391-1480
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Re: [OT] Problem with MySQL Insert
Thanks, Mark. On Wed, Mar 25, 2015 at 1:27 AM, Mark Schonewille m.schonewi...@economy-x-talk.com wrote: Can you confirm that the MySQL syntax you see in the message box is the same as what you entered in Sequel Pro? In Sequel Pro, I wrapped the time period in double quotes. When we tried that in LiveCode, it posted the quotes to the field, and the times were still adjusted. (I mistyped the 10... it's set at 20). What are the collations of the database and the time field? Sequel Pro is displaying 'latin1_swedish_ci' as the default for the VARCHAR fields. -- White Feather Software www.whitefeather.com Cell: 408-391-1480 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: [OT] Problem with MySQL Insert
On Wed, Mar 25, 2015 at 8:08 AM, Peter Haworth p...@lcsql.com wrote: Have you tried selecting the data with Livecode (revDataFromQuery)? Well, thank you very much. When I checked with revDataFromQuery, I saw the same problem we're seeing in Sequel Pro. That was a clue! Sure enough, our function for determining which half-hour period to report was working perfectly, but we forgot to pass it the current time. All better now. Gack. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
[OT] Network load analysis
One of my clients needs someone to dig around in his network and find out why he's getting load spikes. Does anyone here know how to do that stuff, or can recommend someone who does? Thanks -- Paul -- White Feather Software www.whitefeather.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
LiveCode and Alexa
I have a potential client who wants a Mac desktop app for viewing Alexa results. I see that Alexa has several APIs ( https://aws.amazon.com/tools/?nc1=f_dr) but I can't think of a way for LiveCode to hook into one of those solutions. Anyone have any experience with this? -- Paul ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Clipboard pastes into single spreadsheet cell
On a Mac with LC 8.6.1 (Community) Tabs coming from LiveCode are converted to spaces when pasted to a Google spreadsheet, but are not converted when pasting from BBEdit. I'm collecting data into a tab-delimited row (line) and putting it on the Clipboard, then pasting the row into a Google spreadsheet. For example: *put theData["Date"] & theData["First name"] \* *& theData["Surname"] into theRow* *set the ClipboardData["text"] to theRow* When I go to a Google Spreadsheet, click in an empty cell and paste, the tabs are ignored (converted to spaces) and the entire row gets pasted into the single cell as space-delimited. I have discovered a workaround. If I first paste from LiveCode to BBEdit (the tabs are recognized) and then copy and paste from BBEdit to the spreadsheet, the tabs are OK and the data populates into separate cells. I've tried this with Safari, Firefox, and Chrome, so the problem isn't browser-specific. I don't want to ask my end-user to paste into another application before pasting into the spreadsheet. Anyone know of a fix for this? -- Paul -- White Feather Software www.whitefeather.com Cell: 408-391-1480 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Clipboard pastes into single spreadsheet cell
Results after copying data from LiveCode (string starts with a tab) 1hooIO16dbbNtjCvISrTzQ== 45539 TEST -- SEND TO PAUL IPST Results after pasting in BBEdit 1hooIO16dbbNtjCvISrTzQ== 45539 TEST -- SEND TO PAUL IPST After copying from BBEdit 1hooIO16dbbNtjCvISrTzQ== 45539 TEST -- SEND TO PAUL IPST On Wed, Oct 18, 2017 at 8:22 AM, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > That has been my suspicion all along since this began. Still, I think it > is incumbent upon the other software developers to properly interpret the > clipboard and respond accordingly. That of course, is a pipe dream, so I > suppose it's now up to us the end developers to do the conversion. Is there > an event we can trap for when text is copied in the script editor? Maybe we > can put something in a frontscript that "cleans" the clipboarddata. > > Bob S > > > > On Oct 18, 2017, at 08:12 , Alejandro Tejada via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > > I suspect that Unicode is working behind the scenes > > to produce the result that Paul is getting in his own > > MacOSX setup. > > > > Al > > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- White Feather Software www.whitefeather.com Cell: 408-391-1480 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Clipboard pastes into single spreadsheet cell
I just checked this in LC 7.1.1, running in High Sierra. It works as expected; the tabs survive into the spreadsheet. -- Paul On Thu, Oct 19, 2017 at 6:18 AM, Paul Foraker <p...@whitefeather.com> wrote: > G.W., glad to hear it works OK on a PC. My end user will be using one. > Thanks, > -- Paul > > On Wed, Oct 18, 2017 at 7:52 AM, G.W.Gaich via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> I made a test: >> >> set the clipboarddata to 1 & tab & 2 & tab & 3 >> >> pasted into a google spreadsheet cell and three cells were filled as >> expected. >> >> Livecode 8.1.6 >> windows 7 >> firefox 56 >> >> perhaps it's a mac or browser thing >> >> >> Am 18.10.2017 um 10:27 schrieb Paul Foraker via use-livecode: >> >>> On a Mac with LC 8.6.1 (Community) >>> >>> Tabs coming from LiveCode are converted to spaces when pasted to a Google >>> spreadsheet, but are not converted when pasting from BBEdit. >>> >>> I'm collecting data into a tab-delimited row (line) and putting it on the >>> Clipboard, then pasting the row into a Google spreadsheet. For example: >>> >>> *put theData["Date"] & theData["First name"] \* >>> *& theData["Surname"] into theRow* >>> >>> *set the ClipboardData["text"] to theRow* >>> >>> >>> When I go to a Google Spreadsheet, click in an empty cell and paste, the >>> tabs are ignored (converted to spaces) and the entire row gets pasted >>> into >>> the single cell as space-delimited. >>> >>> I have discovered a workaround. If I first paste from LiveCode to BBEdit >>> (the tabs are recognized) and then copy and paste from BBEdit to the >>> spreadsheet, the tabs are OK and the data populates into separate cells. >>> >>> I've tried this with Safari, Firefox, and Chrome, so the problem isn't >>> browser-specific. >>> >>> >>> I don't want to ask my end-user to paste into another application before >>> pasting into the spreadsheet. >>> >>> Anyone know of a fix for this? >>> >>> -- Paul >>> >>> >> >> ___ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> > > > > -- > > White Feather Software > www.whitefeather.com > Cell: 408-391-1480 <(408)%20391-1480> > > -- White Feather Software www.whitefeather.com Cell: 408-391-1480 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Clipboard pastes into single spreadsheet cell
G.W., glad to hear it works OK on a PC. My end user will be using one. Thanks, -- Paul On Wed, Oct 18, 2017 at 7:52 AM, G.W.Gaich via use-livecode < use-livecode@lists.runrev.com> wrote: > I made a test: > > set the clipboarddata to 1 & tab & 2 & tab & 3 > > pasted into a google spreadsheet cell and three cells were filled as > expected. > > Livecode 8.1.6 > windows 7 > firefox 56 > > perhaps it's a mac or browser thing > > > Am 18.10.2017 um 10:27 schrieb Paul Foraker via use-livecode: > >> On a Mac with LC 8.6.1 (Community) >> >> Tabs coming from LiveCode are converted to spaces when pasted to a Google >> spreadsheet, but are not converted when pasting from BBEdit. >> >> I'm collecting data into a tab-delimited row (line) and putting it on the >> Clipboard, then pasting the row into a Google spreadsheet. For example: >> >> *put theData["Date"] & theData["First name"] \* >> *& theData["Surname"] into theRow* >> >> *set the ClipboardData["text"] to theRow* >> >> >> When I go to a Google Spreadsheet, click in an empty cell and paste, the >> tabs are ignored (converted to spaces) and the entire row gets pasted into >> the single cell as space-delimited. >> >> I have discovered a workaround. If I first paste from LiveCode to BBEdit >> (the tabs are recognized) and then copy and paste from BBEdit to the >> spreadsheet, the tabs are OK and the data populates into separate cells. >> >> I've tried this with Safari, Firefox, and Chrome, so the problem isn't >> browser-specific. >> >> >> I don't want to ask my end-user to paste into another application before >> pasting into the spreadsheet. >> >> Anyone know of a fix for this? >> >> -- Paul >> >> > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- White Feather Software www.whitefeather.com Cell: 408-391-1480 ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
