LiveCode Forums

Hi AxWald, This is amazing ... what a lesson. Thank you so much for all the information and taking the time to put it all out. I'm going to try all of this out. I usually grab my data set, and store it in a custom Property of the card/ stack. Then I make a copy of it, and display an ordered/ formatt...

Thanks again gang, AxWald: I still have the error handler code, I moved it down and commented it out so more of the code I used and tried is visible. I wanted to show how the var tRecords was populated ... or not. At this point I'm not getting an error but tRecords is blank when I say it doesn't wor...

Ok ... I have a feeling your going to tell me how to copy and paste the results of an -- answer tSQLput -- command into the forum but until you do the best I could come up with is screen shots. If you look on the right side you can see most of the code that generated the SQL statement. I had to recr...

Hi All, Thanks for your help. bangkok ... sorry for the confusion, I'll try to reword it a simpler way. Craig ... thanks ... I found the code button ... I'll have to check out the other buttons up there!! AxWald ... I hadn't run across the format() feature, it looks like a powerful tool. Here's, hop...

Hi everyone, This is sort of related to the topic submitted by lemodizon's "How to search between two dates in LiveCode" on Nov. 12,2020. I'm trying to create the SQLite SELECT statement below, to include a text field with date formatted content in the WHERE clause. Using the suggestions by Xero, ev...

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...

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...

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...

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...

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...

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...

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 ...

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...

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...

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 ...