Search found 77 matches

by Not a lot of thought
Wed Nov 08, 2017 3:50 pm
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

I have not...a bit terrified that I would loss everything to be honest (unrightfully so I’m sure). I’ve never had much luck with updates.

I might try that though.
by Not a lot of thought
Wed Nov 08, 2017 3:16 pm
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

I’ve tried several different table names.
by Not a lot of thought
Mon Nov 06, 2017 12:59 pm
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

Text, see above example. Date, name, score
by Not a lot of thought
Mon Nov 06, 2017 3:40 am
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

I didn’t really change the name, I created a new table with a different name and migrated the Data to that table. It worked once initially, but when I tried to run it again a couple days later it returned blank in the variable. Then I few days later I tried to repeat the process again and it worked ...
by Not a lot of thought
Sun Nov 05, 2017 1:10 pm
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

I also just tried an insert statement with a revExecuteSQL to insert the information from the table that wasn’t working into a new table in order to eliminate it being just the revDataFromQuery function. When I did that both queries worked. It inserted into the new table and then pulled the informat...
by Not a lot of thought
Sun Nov 05, 2017 11:42 am
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

MaxV, I tried adding a space before the semicolon, still no go though.
by Not a lot of thought
Sun Nov 05, 2017 11:41 am
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

I’m using a Mac. The app runs queries against all other tables in that DB just fine within the livecode environment. It’s literally just this one table. And really I should say it’s just this one set of Data in this table. I’ve created multiple tables with the same data and every query returns blank...
by Not a lot of thought
Sun Nov 05, 2017 5:18 am
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

So, apparently it isn't fixed...I'm really not sure what is going on. The queries work exactly as they are written below in Workbench, but when I run them Livecode I only get a returned value for the second one. When I run them in Workbench I get both. I've confirmed that the table does exist in the...
by Not a lot of thought
Sun Oct 29, 2017 11:58 am
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

So, after trying dozens of different things I tried changing the name of the table. For some reason removing the word "Analysis" from the name of the table allowed it to function properly. I have no idea, why that would have been, but it's working fine now.

:|
by Not a lot of thought
Wed Oct 25, 2017 11:17 am
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

So, I ran the below queries. The first two, which are exactly the same, return nothing. The last one which is a different query returns accurate information. All of them work in MySQL Workbench (copied the exact text in all of them from livecode to MySQL Workbench and ran the queries to test). The P...
by Not a lot of thought
Tue Oct 24, 2017 5:12 pm
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Re: Queries Stopped Working

The table is quite small actually. There are quite a few very large tables in the DB, which I’ve had trouble with before on the time, but this one only takes a few milliseconds to run in MySQL Workbench and only has a couple hundred rows. Initially, I thought it was an address problem, but other kin...
by Not a lot of thought
Tue Oct 24, 2017 12:05 pm
Forum: Databases
Topic: Queries Stopped Working
Replies: 21
Views: 1456

Queries Stopped Working

Below is an example a revDataFromQuery command in my system. All of them have stopped working. It pulls a blank, but when I use mysqlWorkbench it works fine and pulls appropriate response. Other database functions are working. I’ve noticed that my insert queries are working to some degree. I have a ...
by Not a lot of thought
Tue May 30, 2017 11:50 pm
Forum: Databases
Topic: Lost Connection to MySQL DB Thru Livecode
Replies: 9
Views: 1706

Re: Lost Connection to MySQL DB Thru Livecode

I tried executing the "Begin Transaction/Commit" for the query with a revDataFromQuery and a revExecuteSQL. The revExecuteSQL won't pull the data, so I'd have to create a table in order to gain the information that I need and query that (I'm guessing). The revDataFromQuery returned an error in the s...
by Not a lot of thought
Mon May 29, 2017 8:42 pm
Forum: Databases
Topic: Lost Connection to MySQL DB Thru Livecode
Replies: 9
Views: 1706

Re: Lost Connection to MySQL DB Thru Livecode

Or better, a simple example. I'm kind of new to this idea and trying to learn. I was considering building stored procedures in the database that could be called from livecode perform the function on the server side in order to prevent the constant transmission of data between host and app, but I'm s...
by Not a lot of thought
Mon May 29, 2017 8:17 pm
Forum: Databases
Topic: Lost Connection to MySQL DB Thru Livecode
Replies: 9
Views: 1706

Re: Lost Connection to MySQL DB Thru Livecode

Any advice on where I might learn more about that as it applies to Livecode?

Go to advanced search