Search found 4 matches

by Gunit31
Wed Mar 01, 2017 12:58 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Variable in an SQL Query
Replies: 11
Views: 13323

Re: Variable in an SQL Query

I've changed a lot of the rest of the app but when I went back it was broken again. Now when I type it in, I get "revdberr,Database Error: no such table: Login" which doesn't make sense due to the fact that there is a table called Login and if I run the same type of query in Sql it works. put "SELEC...
by Gunit31
Fri Feb 24, 2017 7:09 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database Query HELP
Replies: 1
Views: 2228

Database Query HELP

My query system was fine before but then I added 3 tables to draw from(Student, Administrator, Instructor) and now every time I try to execute it I get an answer of "revdberr,Database Error: no such table: Administrator" which does't make sense. The solution seems to be staring me in the face but I ...
by Gunit31
Thu Feb 16, 2017 6:29 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Variable in an SQL Query
Replies: 11
Views: 13323

Re: Variable in an SQL Query

Thank you to everyone who helped me with this. It now works the way that i intended however, SparkOut brought up the issue I hadn't thought about which is how bad it is to localize and check the password within the app. If i were to check it within the database would I need to add the input informat...
by Gunit31
Wed Feb 15, 2017 6:19 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Variable in an SQL Query
Replies: 11
Views: 13323

Variable in an SQL Query

Hello my name is Garrett and I am trying to build a login system but I don't know how to incorporate my variable into the query. My variable is "tUsername" and i need help if anyone knows how to get around this. As I said it is for an SQL Database. put "SELECT Password FROM Login WHERE Username = tU...