LiveCode Forums.

Thanks guys! The Quartam Reports seems the way to go. Until I'm ready for that, I'll practice the SELECT SQL way to put data to a card for on-screen reports as a good learning exercise.

Having finally succeeded in connecting to a database, creating tables, inserting, updating, finding and closing SQLite and Valindina DBs, I'm going to the next step-writing reports. I don't find a report writer in LC altho my last systems had them (Access & REALbasic). So what is the best practice i...

Tom: Appreciate your help. I have read the links you said, but I went back and re-read them, looked at the video, and I do remember when using SQL with another language system that you have to be very exact when using the single quotes, double quotes and ampersand. So I went back and tried several d...

I'm building my first app, and practicing by putting hard-coded words into the different SQL fields, i.e. put "INSERT into apts VALUES ('Lakepoint','1821 Dora Ave');" into tSQL But I really need to insert the contents of an entry field into each, so I put the contents of each field into a local vari...

Craig: Florida is a mysterious but wonderful place. :-) I'm sure I did something wrong, but I'm learning to like LC and also finding some anomalies. There is a formal syntax to every language and loose ends dangling, not finding an orderly presentation of how to handle those is what's frustrating; b...

Shaosean: That's exactly what I did. And it works great. I guess that I'm just confused by the lack of orderly documentation of some important steps, compared to the languages I've previously worked with. Frustrating! I'm going to take their LCUniv $50 course in my spare time (?) to see if that will...

Newbie4: The adding of "global gName" to the address field should have worked. Right, but it didn't. So I followed shaosean's idea of just using 'the text of field X' for each of the 9; it worked in the answer command and also worked in the Save button handler putting those into local vars. ie "put ...

Thanks guys for all the suggestions. If I was unclear before, I did try declaring the globals, separately, at the top of the main stack, the top of the card, the top of each field handler and it never worked. It never occurred to me to re-declare it wherever it was later used. My background is in se...

I have a data input screen with nine fields. Each one edits the raw input to uppercase, lowercase, titlecase etc and an answer command shows me its correct. Then in each handler I put the text into a global variable like gName, gAddress etc in order to store them until all nine are entered and then ...

Mark said: "We really need full-text search built into the dictionary."
That's a GREAT idea! Tell Kevin.

Thanks guys, that's exactly what I was looking for. Mentally indexed it under handlers, or functions, or triggers, never thought to look at messages.

I have several actions to code which could be triggered by different events. Is there a list of all events which can be used to trigger a handler or a function so that I can choose which would be most appropriate to use in the situation? I've looked everywhere but haven't been able to find one so I ...

OK thanks guys; I'll try Dixie's code first and adapt from there if necessary. So my 2nd question was about best practices I guess. Since you can drag any existing stack into the one you're working on, would you keep various scripts in a master file and copy the desired ones to the current stack, or...

TitleCase (sometimes called Mixed Case) puts the first letter of each word in uppercase and the rest of the word in lowercase. Very convenient for input of names of people, addresses, cities, books, etc especially when the user is low on grammatical skills and can just type everything in lowercase a...

I had this is another thread but think I should start a new one for it. Craig, I think you are telling me that there is no TitleCase function in LiveCode and I had better resurrect an ancient coding technique into LC language to roll my own. Maybe something like-separate chunks delineated by space, ...