Search found 478 matches

by AxWald
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...
by AxWald
Sat May 28, 2016 6:52 pm
Forum: Windows
Topic: Windows app store
Replies: 5
Views: 2681

Re: Windows app store

Hi,

probably you have read this page already?

Have fun!
by AxWald
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...
by AxWald
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 ...
by AxWald
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...
by AxWald
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....
by AxWald
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...
by AxWald
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...
by AxWald
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"; "...
by AxWald
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...
by AxWald
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...
by AxWald
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!
by AxWald
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 ...
The major deficiency of MyISAM is the absence of transactions support. Also, foreign keys are not supported.
Have fun!
by AxWald
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...
by AxWald
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:

Code: Select all

set the unicodetext of line 1 of fld "b" to the unicodetext of line 1 of fld "a"
:D

Have fun!

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

Go to advanced search