Queries Stopped Working

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Not a lot of thought
Posts: 77
Joined: Thu May 21, 2015 2:41 am

Re: Queries Stopped Working

Post by Not a lot of thought » Mon Nov 06, 2017 12:59 pm

Text, see above example. Date, name, score

MaxV
Posts: 1579
Joined: Tue May 28, 2013 2:20 pm
Location: Italy
Contact:

Re: Queries Stopped Working

Post by MaxV » Wed Nov 08, 2017 1:55 pm

AWS security issue? Probably something with table name...
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w

Not a lot of thought
Posts: 77
Joined: Thu May 21, 2015 2:41 am

Re: Queries Stopped Working

Post by Not a lot of thought » Wed Nov 08, 2017 3:16 pm

I’ve tried several different table names.

ghettocottage
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 366
Joined: Tue Apr 10, 2012 9:18 am

Re: Queries Stopped Working

Post by ghettocottage » Wed Nov 08, 2017 3:24 pm

I am vaguely recollecting having some query issue with LC 7, but it was LC Server. Still, it was a random issue that would happen sometimes on some specific query that caused me no end of hair-pulling.
Moving to 8 solved the problem. Have you tried LC 9, if for no other reason than to rule out LC 7 as the culprit?

Not a lot of thought
Posts: 77
Joined: Thu May 21, 2015 2:41 am

Re: Queries Stopped Working

Post by Not a lot of thought » Wed Nov 08, 2017 3:50 pm

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.

ghettocottage
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 366
Joined: Tue Apr 10, 2012 9:18 am

Re: Queries Stopped Working

Post by ghettocottage » Wed Nov 08, 2017 4:05 pm

Just make a copy and work from that rather than altering your current work.

I generally make a copy each day I am working on a project so I have something to backtrack to when I completely bungle things.

ghettocottage
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 366
Joined: Tue Apr 10, 2012 9:18 am

Re: Queries Stopped Working

Post by ghettocottage » Wed Nov 08, 2017 4:29 pm

...also, in case you were not aware...you can have multiple versions of LC installed at the same time and run wichever you need at the moment. I have both 7 and 9 at the moment.

Post Reply

Return to “Databases”