LiveCode Forums

Thanks for the suggestion, Thierry. I have checked the custom properties now, and the problem is not located there.

The standalone maker generates a working MacOS version of my stack. However, it also presents me with a window of errors: 14 "File not found" errors in a total of more than 500 cards, with paths that point to a non-existant folder within an old Supercard folder that I have not used for a number of y...

Elegant. Thank you.

I have read just the first 40 pages of the printed "LiveCode User Guide" and am sorry to say that I am disappointed. Not only is there no table of contents, there is no index, so looking up topics is impossible. If the book has bee proofread, there is little evidence of this. Just look, for example,...

Just arrived here in Spain.

Timothy, interesting. I, too, have been having problems of total freezes on my Mac when using a stack that has several hundred cards with Player objects. Tests showed that going from card to card in a repeat loop was causing hundreds of Threads to be generated. The only solution I have found, is to ...

This has got me thinking. If SQLIte has problems with the single quote character in a text string, then it might have problems with other characters that might then also need to be escaped (&,/,¿ and suchlike come to mind). Is there a list of such problematic characters and does SQLite always escape...

Thanks for your concern, Sparkout. Data is put into the wk variables from fields in the current card. That the data is there can be seen in the error shown in the first post. I have now amended the script to replace single quotes in the variables by double quotes and it works a treat. Many thanks to...

The variable content. Of course (I think)! The wkTitle (see first post) contains a single quote. Presumable this has to be escaped. I'm off to see if I can find how to do that.

Thanks for the nudge in what I hope is the right direction.

Klaus, that I do not understand. Your leaving off of the final bracket results in the following string: INSERT into original (title, date_rec, comments) VALUES ('wkTitle', 'wkRecDate', 'wkComments'; With the final bracket, as I proposed, results in: INSERT into original (title, date_rec, comments) V...

Thank you, Klaus. Your put "INSERT into original (title, date_rec, comments) VALUES (" & q2(wkTitle) & ", " & q2(wkRecDate) & ", " & q2(wkComments);" into tSQL results in a LiveCode error, so I have modified it slightly, as follows: put "INSERT into original (title, date_rec, comments) VALUES (" & q...

The following code put "INSERT into original (title, date_rec, comments) VALUES (wkTitle" & ", " & "wkRecDate" & ", " & "wkComments);" into tSQL revExecuteSQL tDatabaseID, tSQL results in the error: No such column: wkTitle. I have added other information to the error display, in order to show the co...

Indeed, and I can't, so should I take it that there is no more efficient way to achieve what I want than my code? It works surprisingly well, but seems a bit dated (just like my car…).

Thank you again, Klaus. That looks a lot tidier!

However, this returns the old character HTML entities, such as &,ä,á,à,â,ã,å,æ,ë,è, etc.

I want the entity numbers, such as &,ä,á,à,â,ã,å,æ,ë,è, etc

Many years ago, I wrote a HyperText function to convert accented and other special characters to HTML entities. I was recently looking at the now LiveCode stack that contains this function, in order to modify the old textual entities into numeric ones. The function is: function textToEntities textTo...