LiveCode Forums

Hi, just an idea: Youre table is not MyISAM, right? Because there's no transactions there ... And in InnoDB, the behaviour of the db depends of the setting of " autocommit " (default: on). I rarely use transactions, but when I do, I don't send them as a block ("START TRANSACTION; UPDATE t_table SET ...

Hi,

another Win 10-64, LC 9.5 test:
"Answer dialog" is shown in the title, very shortly, maybe 1/2 secs. Then it's replaced with the proper dialog title. So confirming.

Have fun!

Hi, put line lineoffset(5, tData) into theLine -- returns 5 Nope. Not at all. Didn't you test this? ;-)) First, "put line [aNumber] into theLine" will throw "compilation error (Chunk: missing chunk)" - line x of what? Second, "line lineoffset(5, tData) of tData" would return "5 bob accountant" - not...

Hi, right, leaving the original data "as-is" & building a new output variable usually is much faster. Only, at a certain point (= VERY big variables) you'll hit a wall - when appending to the output variable takes more & more time each iteration! Should this happen you'll be faster writing your outp...

Hi, most important here: If you go for large data, avoid "repeat with ..."! Instead use "repeat for each ..." Example: I dumped a table from an SQL database, 67247 records, 77 fields each, 18 MB. I'll count how often "899" occurs in the 3rd field. 1st try: on mouseUp put URL "file:C:\Users\user\Desk...

Hi, "answer files" is a command, maybe this is mixing up the call? You might try: put tData into url("file:" & tFile) put the result into tResult put files(specialfolderpath("documents")) into tTheFiles answer "Result:" && tResult & CR & tTheFiles I'd try it in the oldfashioned way: -- we assume: --...

Hi, While I haven't explored Windows past 7, I am pretty sure that you can indeed write to the applications folder if it were in any of the default locations. Of course, that may have changed from 8 -> 10, because Ms really started playing with that UAC stuff pretty heavily. At least the current Win...

Hi, Now I can spare myself a lot of time and aggro if I have a small standalone for, say, Windows, which a potential customer can run on his/her system and it can tell me what sort of Windows they are using and whether their computer is a 32-bit or a 64-bit machine. This is particularly useful as mo...

Hi,

look here.

Have fun!

Hi, if you open a remote stack you're actually creating a snapshot of this stack in your local RAM. As soon as you have done this, someone other can change or even delete this stack, without you noticing. To change data in this remote stack, you must save your local copy to it, actually replacing it...

Hi, this should work for most cases: on mouseUp ask "Gimmi a date string:" with "2019-08-11T20:17+0000" if it is empty then exit mouseUp else put it into myStrg end if get getTimeFromString(myStrg) -- see function below if it begins with "error" then answer error quote & myStrg & quote & " isn't a s...

Hi,

is there a special reason to use itemdel at all?
Why not just grab "char 12 to 17 of twhatEver"?

Have fun!

Hi, -> specialfolderpath("documents") points to a folder inside of your HOME directory on DESKTOP machines! But on "mobile" this is a folder inside of the APP package, due to security reasons (Sandboxing), which may not be accessible to the users. guess you got this mixed up - "documents" is suppose...

Hi, strange. The SQLite Documentation says: The round(X,Y) function returns a floating-point value X rounded to Y digits to the right of the decimal point. If the Y argument is omitted, it is assumed to be 0. And using SQLite Manager I get proper whole numbers ... SQL can be strange, and SQLite can ...

Hi, [...] this data is held within a SQLIte database, each time I pull this data from the database I wish to add a column to it which will display the number of days until the event [...] Naming a field in a database 'Date' isn't a very good idea. For now I'll use 'f_event' and 'f_date' ... . Don't ...