LiveCode Forums

@MaxV In a multiuser environment I would still have to randomly generate a unique table name, create it and drop it for each user in order to avoid conflicts though, right? It is cool that I can just create a database file within using livecode and then populate it with whatever tables I need on dem...

@sritcp Just tested it with a field that contains item 1 item 2 item 3 item 4 item 4 item 4 item 5 And you are right, it comes back with a single line, containing "item 5", so it is only working when the first word is unique. I knew there had to be a catch - that is what I get for playing with array...

Oh, agreed - all experimentation is good. I was just saying why the DB solution was not a good fit for what I was doing. Also, there should be a section in the docs talking about using SQLite - the only reference I could find in the docs is a paragraph saying there is a driver for it. Since I didn't...

That requires having an SQLite database running outside of Livecode though, right? I am trying to avoid external dependencies. I had thought about using a database to accomplish this, but that opens up a set of external requirements for the code to function that I would like to avoid. Also, in a mul...

Hmmm...does this mean the examples in the lessons are wrong?

Found a bug - it adds a space on to the end of each line. I have updated the routine above to correct this

I figured there *had* to be some way of leveraging unique keys in arrays to do this, just took a while to work it out. Hopefully there is not a downside that I am not thinking about. My initial need, and all of my testing were for a single word on the line, but I just tested it with longer lines and...

Aha! I figured it out! the script below results in ridiculously fast duplicate removal: on mouseUp put deleteDuplicateLines(field 1) into noDupes put the number of lines in field 1 && the number of lines in noDupes end mouseUp function deleteDuplicateLines theList --this function removes duplicate l...

Oh, and I also tried this: on mouseUp put deleteDuplicateLines(field 1) into noDupes put the number of lines in field 1 && the number of lines in noDupes end mouseUp function deleteDuplicateLines theList split theList by return combine theList by return return theList end deleteDuplicateLines which ...

I have some very long (25K lines) lists that I would like to filter for duplicates, and I am wondering if there is a faster way to do this than what I am currently doing. Right now I have tried on mouseUp put field 1 into Temp --field 1 contains about 25K lines put empty into noDupes put the millise...

I thought I knew the answer to this, but apparently, I don't. According to the tutorial at http://lessons.runrev.com/buckets/1228/lessons/20441 this should come down to the fact that unicode characters are 16 bits rather than 8 bits long (or double-byte). However, only the charToNum and the NumToCha...

I don't think that - I know that there are 4 chars in the field. What I was saying was: If you ask livecode for the number of lines in field 1 it would answer "1" If you ask for the number of chars in that line it would answer "3" So one could draw the conclusion that there are three characters in f...

What I was referring to is that the return char is not counted as one of the chars of a line - and that this is the behavior that you would want, because it's a delimiter and when you ask for the number of characters in a line you almost always want to know how many visible characters there are. The...

The thing to remember (and I knew this in the back of my head already, but I am frequently dumb unless I stop and think things through) is that what you are seeing displayed in a field is the location of *the insertion point* - the place where the next character typed will appear. So the insertion p...

Yeah, I guess I will always just have to do a "if the last char of variable is return then delete the last char of variable', because really what filter without empty does is the equivalent of "replace return & return with return", which makes sense in most cases. I run into problems because the dow...