Search found 478 matches
- Fri Jun 03, 2016 11:48 am
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: Converting Date and time for import
- Replies: 4
- Views: 1698
Re: Converting Date and time for import
Hi, A.) If you have to work with date fields & databases it is a good idea to have a set of predefined functions to handle it. These are mine for European date & time stuff: function DI2Sys DI -- DateItems -> 23.03.2016 12:44 set the itemdelimiter to "," return format("%02s", item 3 of DI) & "." & f...
- Sat May 28, 2016 6:52 pm
- Forum: Windows
- Topic: Windows app store
- Replies: 5
- Views: 2681
- Tue May 24, 2016 10:43 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Performance badly degrading with growing string variable
- Replies: 20
- Views: 6552
Re: Performance badly degrading with growing string variable
Hi, First, comment your "put myCounter" and *THIS* will speed up your loop. OMG - I had that in initially for the long runs, when 10min waiting time was to expect for the big file. And left it in, for comparability. Missing that I'd not need it anymore, after all the time got cut down from 813392 ms...
- Tue May 24, 2016 5:37 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Performance badly degrading with growing string variable
- Replies: 20
- Views: 6552
Re: Performance badly degrading with growing string variable
Hi, I knew it. Thinking helps sometimes. New code: answer file "Which file to process?" put it into MyFile open file myFile read from file myFile until eof put it into myVar close file MyFile ask file "Where to save?" put it into MyOutput open file myOutput for append put 0*1 into myCounter put the ...
- Tue May 24, 2016 3:38 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Performance badly degrading with growing string variable
- Replies: 20
- Views: 6552
Re: Performance badly degrading with growing string variable
Hi, Jacques remark about speed gave me headaches, so I had to test. At first I exported a table from a database, using a predefined format in HeidiSQL named "Excel CSV": Semicolon as field delimiter, Return as record delimiter, Quotes around all fields. That's what every spreadsheet can read. The da...
- Mon May 23, 2016 6:28 pm
- Forum: HTML5
- Topic: Trying out Livecode 8.0.1
- Replies: 10
- Views: 5281
Re: Trying out Livecode 8.0.1
Hi, tried what I have here: (all & everything fully updated) Win 10 pro (64-bit) ------------------------------------------------------- Edge 25.10586.0.0: still waiting on run dependencies: ANGRY.html (177,13) dependency: memory initializer ANGRY.html (177,13) dependency: al standalone-community-8....
- Sat May 21, 2016 6:27 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Performance badly degrading with growing string variable
- Replies: 20
- Views: 6552
Re: Performance badly degrading with growing string variable
Hi, How were you able to discern that the data being worked on uses semi-colons as its field delimiter? Because Havanna said so (I quoted it), and from experience. ;-) To be honest, I've never seen a CSV actually separated with commata, and it's quite some aeons ago that I saw my first. I assume tha...
- Fri May 20, 2016 1:59 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Performance badly degrading with growing string variable
- Replies: 20
- Views: 6552
Re: Performance badly degrading with growing string variable
Hmmm. Normally I put the file into an input variable, repeat with each Line some conversion, put the changed line after an output variable, finally write this output variable back to the file. This looks very slow. Why don't you just replace in the input variable and use this then for output? Why do...
- Thu May 12, 2016 8:10 pm
- Forum: Databases
- Topic: Optimizing SQLite Insert Statements
- Replies: 4
- Views: 2767
Re: Optimizing SQLite Insert Statements
Hi, Would that look like: loop BEGIN TRANSACTION; INSERT; END TRANSACTION; end loop or BEGIN TRANSACTION; loop INSERT; end loop END TRANSACTION; The second should be much faster. Read this . I'd do it in another way, without any looping. Provided I have data like this: ANum: AChar: AStr: 321; "A"; "...
- Tue May 10, 2016 7:15 pm
- Forum: Databases
- Topic: Strftime() Function
- Replies: 1
- Views: 1357
Re: Strftime() Function
Hi, "SELECT strftime('%W', 'Week'), Week, Sum(CRED) FROM Temp_Table GROUP BY Week;" Have you tried already: "SELECT strftime('%W', Week) ..." or "SELECT strftime('%W', Temp_Table.Week) ..."? The second notation is what I use - "SELECT strftime('%Y,%m,%d,%H,%M,%S,%w', MyTable.MyField) ..." to get the...
- Sun May 01, 2016 1:02 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: Repeat with a list
- Replies: 6
- Views: 1948
Re: Repeat with a list
Hi, try false instead of "false" , it's a constant and not a string! And to have it better readable, try: put "Black10Record,High10Record,Low10Record," & \ "Odd10Record,Even10Record,Red10Record,Black20Record," & \ "High20Record,Low20Record,Odd20Record,Even20Record" into MyVar repeat for each item tI...
- Sun May 01, 2016 12:49 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: Android app first field already has focus but no onscreen kb
- Replies: 9
- Views: 3356
Re: Android app first field already has focus but no onscree
Hi,
quick & dirty:
Make another field (may be 1x1 pixel) that gets the focus when going to this card?
Before the one you want to type in?
Have fun!
quick & dirty:
Make another field (may be 1x1 pixel) that gets the focus when going to this card?
Before the one you want to type in?
Have fun!
- Wed Apr 20, 2016 12:58 pm
- Forum: Databases
- Topic: revdberr,Lost connection to MySQL server during query
- Replies: 11
- Views: 5836
Re: revdberr,Lost connection to MySQL server during query
Hi,
just hope your tables are not MyISAM - no support for transactions ...
just hope your tables are not MyISAM - no support for transactions ...
Have fun!The major deficiency of MyISAM is the absence of transactions support. Also, foreign keys are not supported.
- Mon Apr 18, 2016 3:51 pm
- Forum: Internet
- Topic: Getting real IP of mobile device not working but...
- Replies: 17
- Views: 9568
Re: Getting real IP of mobile device not working but...
Hi, [...] I could be wrong but it appears that the "open socket" command does some sort of magic and is actually retrieving the real IP address of the client before it is sent [...] Nope, it doesn't. The server sees where the packet comes from - and this hasn't to be your phone! There may as well be...
- Thu Apr 14, 2016 2:12 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: Copy a string to a specific line in a fld (UTF8 safe)[Solved
- Replies: 7
- Views: 1465
Re: Copy a string to a specific line in a fld (UTF8 safe)
Oooops,
missed the unicode thingie!
Doesn't matter, try this then:
Have fun!
PS: Didn't get any method working with using the clipboard ...
missed the unicode thingie!
Doesn't matter, try this then:
Code: Select all
set the unicodetext of line 1 of fld "b" to the unicodetext of line 1 of fld "a"

Have fun!
PS: Didn't get any method working with using the clipboard ...