Search found 361 matches

by AxWald
Tue Aug 13, 2019 9:15 am
Forum: Talking LiveCode
Topic: Using a remote stack instead of a database to share data
Replies: 12
Views: 302

Re: Using a remote stack instead of a database to share data

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...
by AxWald
Mon Aug 12, 2019 1:19 pm
Forum: Talking LiveCode
Topic: itemdelimiter?
Replies: 17
Views: 436

Re: itemdelimiter?

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...
by AxWald
Sun Aug 11, 2019 6:01 pm
Forum: Talking LiveCode
Topic: itemdelimiter?
Replies: 17
Views: 436

Re: itemdelimiter?

Hi,

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

Have fun!
by AxWald
Fri Aug 09, 2019 12:43 pm
Forum: Android Deployment
Topic: Path to document folder
Replies: 7
Views: 246

Re: Path to document folder

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...
by AxWald
Sat Jul 20, 2019 4:57 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Array add column with 'days until due'
Replies: 13
Views: 801

Re: Array add column with 'days until due'

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 ...
by AxWald
Sat Jul 20, 2019 10:37 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Array add column with 'days until due'
Replies: 13
Views: 801

Re: Array add column with 'days until due'

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 ...
by AxWald
Thu Jul 18, 2019 3:52 pm
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 1319

Re: Returns in a column

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...
by AxWald
Wed Jul 17, 2019 11:26 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 1319

Re: Returns in a column

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...
by AxWald
Sun Jul 14, 2019 1:39 pm
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 1319

Re: Returns in a column

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) ...
by AxWald
Tue Apr 23, 2019 9:02 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Using sqlite
Replies: 1
Views: 219

Re: Using sqlite

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 ?) ...
by AxWald
Mon Apr 22, 2019 7:46 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: CreateProcess failed:The system cannot find the path specified
Replies: 15
Views: 794

Re: CreateProcess failed:The system cannot find the path specified

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...
by AxWald
Fri Apr 19, 2019 1:39 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: How to prevent Windows from Screensaver while program running
Replies: 4
Views: 414

Re: How to prevent Windows from Screensaver while program running

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...
by AxWald
Thu Apr 18, 2019 1:34 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Merge & Storing input validation logic as a custom property
Replies: 18
Views: 892

Re: Merge & Storing input validation logic as a custom property

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 ...
by AxWald
Wed Apr 17, 2019 5:43 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Merge & Storing input validation logic as a custom property
Replies: 18
Views: 892

Re: Merge & Storing input validation logic as a custom property

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

Go to advanced search