LiveCode Forums

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

Hi, When I ran your solution with my database (over 11,000 entries, but over 33,000 lines when imported!!), it wasn’t happy and I needed to stop the import after more than 10 minutes. Ooops. Wanted to do some timing, and created a file like this: "zero¬one",two,three,four,five,six,seven,eight,nine z...

Hi, AxWald, I liked your approach, but couldn't get your script to work. Am I missing something? It may be that your Excel writes different .csv's. My demo was this: spreaddemo.png Saved as .csv it looks like this: a;"This is a text.";c 1;2;3 When I paste my code into a button & run it, msg contains...

Hi, abusing a spreadsheet for layout or database tasks is the first step toward the swamps of sorrow ... Additionally, Excel (at least my 2003 here) has poor support for .csv (Character Separated Values). Still you're not lost: When saving as .csv (comma/semicolon separated) or .txt (tab separated) ...

Hi, So far my efforts are not successful. What doesn't work? Hard to determine w/o recreating the whole stuff ... What I see: Save yourself the hassle with setDatabaseID/ getDatabaseID. Instead, once you have the dbID, put it into a global variable or in a custom property (the dbID of this stack ?) ...

Hi, LC9 doesn't need the SDK platforms for Android 2.1/ API 7 anymore? Or was it the 2.2/ API 8? I don't remember exactly why, only that checking both these (besides the required 4.0.3/ API 15 & the real target one) saved my mental sanity some years ago ;-) Maybe it's worth a try - good luck! Have f...

Hi, a rather crude way is demonstrated in the attached stack. Idea is to send a keystroke periodically that prevents the screen saver from kicking in. NUMLOCK came to mind - twice in quick succession. Actually this idea came from VBS forums. Anyway, I couldn't get it running via the usual do myVBS a...

Hi, So the part that I want to store as a Custom Property is "field A = 90 and field B > 0". cCondition of fld "A" in my previous example: ([[me]] = 90) AND ([[fld "B"]] > 0) WHOW!, I completely missed the usefulness of this for general input validation. I learn a lot here, actually ;-) Whereas I'm ...

Hi, [...] what is the advantage of storing an expression, and then building another expression that incorporates the first one? I just recently (while refactoring) moved all my SQL strings into custom properties. And use them now with a system similar to the one described. Reason: Too often I had to...