LiveCode Forums

Hello LC forum, My last post under the old subject heading having received no comment, I experimented and found that the title of an old thread can changed to a more informative one. Perhaps there is nothing to comment other than if my app is being affected by uncorrected bug no. 19023, there is not...

Hello again, Maybe I' don't understand the bug report, but it seems to me that the bug labeled 19023 and described in the link above may be the cause of my problem. I do my work on Windows and am developing for just the Windows platform. If the presence of the browser widget on the same card as fiel...

Thanks, Jacque, for your suggestion. I added your suggested line to the opencard handler, but it had no effect. I opened the card with the handler, clicked into a field, and typed text normally, then I left the card and returned to it, clicked in the same field or any other field on the card, typed,...

Thank you Bangkok and Sparkout. The apostrophes in the text was the problem, or most of it, and the escape technique worked. About a hundred records were inserted. Thanks for the comment on the mixture of literal and placeholder syntax. No need to try it now but your suggestion will be used in futur...

Capture.JPG Thanks for your quick reply. I had seen the result function explained in the DIctionary but had never used it. I added a line putting it into a variable and ran the actual script on my card which has 16 fields rather than four. Here's the new script below and the results from the variab...

Thanks Andy for your suggestion and test stack. Yes, if I uncheck "Can receive keyboard focus" of a field in the Project Browser or "Focus with the Keyboard" in the Property Inspector of the same field (aren't they two different ways of doing the same thing rather than the former action "overriding"...

I am trying to put data in the fields of a LC card into a sqlite database, but what looks like a correct script does not work. The data does not appear in the database after I run the script. GLOBAL gDatabaseID on mouseup repeat with j=1 to 4 put fld j into MyArray[j] end repeat put "INSERT INTO MyT...

Hi LiveCode Forum members, It is a year later since the last post in this thread and I have continued working on my application in the IDE despite the problem, which is that after going from one card to another that I previously opened I cannot enter text into a field unless I first toggle the modes...

I've search the forum and other sources on this question and could find nothing that I could understand. I have s SQLite table where some fields have several lines. I need to construct a SQL INSERT or UPDATE statement that will add a new line of text anywhere to such a field, but it would be nice if...

I too noticed today, more than five years after the first post, that there does not seem to be a way to change the border color of the datagrid from its default color, black. I take the silence to be a negative answer to the question.

Monty

Thanks, Klaus, your amended line works perfectly.

Monty

I have a sqlite database in which surnames and first names are in different columns. I want to populate a datagrid table such that the first name and surname are put into one datagrid column in that order, separated by a space. Is that possible? Can anyone suggest the script or a tip on how to do it...

Hi Klaus, Thank you for your response. Although my primary interest is hyperlinks in the text, as a test, I put word "abc" into field "xyz", styled it bold, using the menu command, and then used your command, i.e., "put the htmltext of fld "xyz" into a variable, and then used the query "UPDATE myTab...

I am developing an app that is basically the front end to a sqlite database. At times I would like to put links to web content into the text of LC fields such that when I update the corresponding database field, the links are preserved, i.e., when the script retrieves the text from the database the ...

I am developing the the front end to a database that accesses more than 3000 documents that begin in 1950 and continue to the present year, named in the following format: item 1: the last two digits of the year of publication and the order of publication in that year as a four-digit number, e.g., 14...