Search found 24 matches

by Lonnie
Fri Oct 02, 2020 7:38 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Escape Clauses
Replies: 6
Views: 370

Re: Escape Clauses

Thanks gang, Ended up using placeholders so whatever was in the trn.team1name field would go into the standings.teamname. ------------------------------------------------------------------------------------------ ttTeam1 is temporary text memvar populated in the outside repeat loop along with the ga...
by Lonnie
Thu Oct 01, 2020 9:19 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Escape Clauses
Replies: 6
Views: 370

Re: Escape Clauses

The actual project is a softball tournament manager app. In this section I'm using game results to calculate each team's tournament standings. Once scores are posted I use a repeat loop to go through a list of games and the results.with the fields .. team1name, runs1, team2name, runs2. Within this l...
by Lonnie
Thu Oct 01, 2020 8:41 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Escape Clauses
Replies: 6
Views: 370

Escape Clauses

Hi everyone, I had the issue of hyphens in some field data that was causing issues my app. I found the code below to resolve this as well as quotes, returns and tabs and a few others but at the bottom is my attempt to escape a set of parentheses. Obviously, it didn't work. Any way to escape a set of...
by Lonnie
Mon Sep 14, 2020 11:51 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Single quote/double quote syntax issue with SQLite
Replies: 8
Views: 770

Re: Single quote/double quote syntax issue with SQLite

Hi Gang, Still fiddling with this ... Trying to find the correct syntax to use for the SQL command "INSERT INTO" to add an array of 26 rows each containing 19 fields. Here's what I've tried and the best I've been able to accomplish is getting 1 row or record in the table properly populated ... set t...
by Lonnie
Fri Sep 11, 2020 7:56 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Single quote/double quote syntax issue with SQLite
Replies: 8
Views: 770

Re: Single quote/double quote syntax issue with SQLite

I was able to enter multiple records of data into a table called standings, by inserting 1 line of a text file using: revExecuteSQL gConID, "INSERT INTO standings VALUES(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19)","theLine" theLine contains a comma delimited list of 19 value...
by Lonnie
Sun Sep 06, 2020 8:54 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Single quote/double quote syntax issue with SQLite
Replies: 8
Views: 770

Re: Single quote/double quote syntax issue with SQLite

Thank you soooooooooo much Stam. This is so helpful! In this app each time a round of games is played and scores are posted this table has to be repopulated. My first thought was to DROP or Delete and recreate the table. Then I decided to delete the contents of the table. Of all the methods you've d...
by Lonnie
Sun Sep 06, 2020 1:08 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Single quote/double quote syntax issue with SQLite
Replies: 8
Views: 770

Single quote/double quote syntax issue with SQLite

Hi Everyone. A newbee here ... In my softball program I'm writing I'm having an issue appending records to a SQLiite database table when the field data contains a single quote ... like Tom's Team or Kaua'i Sluggers. All data without single quotes appends properly. The only way I've been able to get ...
by Lonnie
Sat Jul 04, 2020 7:37 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Calling a Variable in an SQLite Select command
Replies: 3
Views: 417

Re: Calling a Variable in an SQLite Select command

I must fess up ... Klaus you are absolutely correct my code with the 2 "WHERE"'s didn't work!! Here's the code that actually works ... put "SELECT id, orgs_id, teams_id, events_id, sets_id, trn_id," && \ "eventno, setno, teamno, teamname, division, teamid, bracket," && \ "pool, rank, wins, losses, t...
by Lonnie
Fri Jul 03, 2020 9:16 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Calling a Variable in an SQLite Select command
Replies: 3
Views: 417

Re: Calling a Variable in an SQLite Select command

I got it ... the double filter: put "SELECT id, orgs_id, team_id, event_id, eventno, set, teamno, team, division, bracket," && \ "pool. rank, wins, lossed, tie, totdiff, oppscore, totscore" && \ "FROM tteams WHERE orgs_id = " && gOrgs_Id && " AND WHERE events_id = " && gEvents_Id && \ "ORDER BY even...
by Lonnie
Fri Jul 03, 2020 4:00 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Calling a Variable in an SQLite Select command
Replies: 3
Views: 417

Calling a Variable in an SQLite Select command

Hi everyone, Thanks in advance for your help! A relative newbee here building an app for my senior softball league. I have an SQLite database with 4 tables I want to link with relationships and issue filter statements(plus a few other tables): orgs(organizations), users, events and teams. The first ...
by Lonnie
Mon Jun 01, 2020 1:07 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Hidden Objects
Replies: 8
Views: 865

Re: Hidden Objects

Hi RossG and the gang! sorry to barge in but ... I have a page full of listings in my Project Browser and can't figure out how to clear them out. None of them respond to clicking. I've shut down and rebooted. Most are various library files that my app must have called but sure like to clean it up. S...
by Lonnie
Sun May 31, 2020 10:18 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Changing a button's "Disable" property
Replies: 3
Views: 391

Re: Changing a button's "Disable" property

Thanks ... I can make that work!
Lonnie
by Lonnie
Sun May 31, 2020 8:15 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Changing a button's "Disable" property
Replies: 3
Views: 391

Changing a button's "Disable" property

I want to change a button's "disable" property. When I click on one button I want to have it disable another button so it can't be selected. And when I click a 3rd button have the disabled button re-enabled.

I looked at setProp but can't get the syntax right.

Thanks,
Lonnie
by Lonnie
Sun May 31, 2020 6:53 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Browser Widget
Replies: 10
Views: 944

Re: Browser Widget

We're doing weekly webinars, Learning LiveCode Q&A. I'll mention my issue there.
Thanks again
by Lonnie
Sun May 31, 2020 6:19 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Load an SQLite database into a data grid table
Replies: 2
Views: 409

Re: Load an SQLite database into a data grid table

Thanks bangkok,

My day is planned out with some video watching!!

Lonnie

Go to advanced search