Search found 369 matches
- Fri Dec 06, 2019 11:19 am
- Forum: Databases
- Topic: LC and transactions in MySQL
- Replies: 2
- Views: 314
Re: LC and transactions in MySQL
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 ...
- Sun Oct 13, 2019 11:45 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: How to stop Answer Dialog from displaying "answer dialog" ?
- Replies: 21
- Views: 1155
Re: How to stop Answer Dialog from displaying "answer dialog" ?
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!
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!
- Fri Oct 11, 2019 10:32 am
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: Various ways of matching a line
- Replies: 7
- Views: 634
Re: Various ways of matching a line
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...
- Fri Oct 04, 2019 12:44 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: Here are ways to improve performance for processing large strings
- Replies: 7
- Views: 577
Re: Here are ways to improve performance for processing large strings
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...
- Fri Oct 04, 2019 11:43 am
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: Here are ways to improve performance for processing large strings
- Replies: 7
- Views: 577
Re: Here are ways to improve performance for processing large strings
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...
- Thu Sep 26, 2019 8:44 am
- Forum: Android Deployment
- Topic: How to save data on android from different fields into a text file with different data?
- Replies: 13
- Views: 662
Re: How to save data on android from different fields into a text file with different data?
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: --...
- Wed Sep 25, 2019 11:41 am
- Forum: Databases
- Topic: Path to database
- Replies: 18
- Views: 1238
Re: Path to database
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...
- Sun Sep 01, 2019 2:11 pm
- Forum: Feature Requests
- Topic: Extension of systemVersion
- Replies: 77
- Views: 3758
Re: Extension of systemVersion
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...
- Sat Aug 17, 2019 10:21 am
- Forum: Talking LiveCode
- Topic: Importing data from Google Sheets (problem with returns in cells) [wrong attachment, now updated]
- Replies: 10
- Views: 885
- 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: 901
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...
- Mon Aug 12, 2019 1:19 pm
- Forum: Talking LiveCode
- Topic: itemdelimiter?
- Replies: 17
- Views: 1185
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...
- Sun Aug 11, 2019 6:01 pm
- Forum: Talking LiveCode
- Topic: itemdelimiter?
- Replies: 17
- Views: 1185
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!
is there a special reason to use itemdel at all?
Why not just grab "char 12 to 17 of twhatEver"?
Have fun!
- Fri Aug 09, 2019 12:43 pm
- Forum: Android Deployment
- Topic: Path to document folder
- Replies: 7
- Views: 684
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...
- 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: 1085
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 ...
- 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: 1085
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 ...