LiveCode Forums

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...

Hi,

probably you have read this page already?

Have fun!

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...

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 ...

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...

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....

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...

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...

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"; "...

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...

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...

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!

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!

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...

Oooops,

missed the unicode thingie!

Doesn't matter, try this then:

Have fun!

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