Search found 4 matches
- 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...
- 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 ...
- 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...
- 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...