
Query SQL db often
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Query SQL db often
Well I guess If I was to have hundreds of thousands of records to query it could cause some latency issues with the program though...seeing that I am only going to have a few dozen messages at best at one time, querying the DB shouldn't be an issue...but I like your idea.... 

Re: Query SQL db often
Send again the log (or at least part of it)... Can't open the zip file.KennyR wrote:Ok I decided to go with the send in time option and all is working as expected. BUT there is a major crash when I attempt to query the DB using my home internet connection. I have no problems querying the DB using another internet connection, but when I connect with my home connection it crashes the IDE and closes LC. I am not sure why this is happening....I am going to attach the error log in the case that someone knows what it means...
Even an Internet connexion problem shouldn't cause Livecode to crash.
Which OS do you use at home ?
Re: Query SQL db often
Hi Bangkok,
That was my joke above...
It's not a zip file just txt with a zip suffix.
Simon
That was my joke above...
It's not a zip file just txt with a zip suffix.
Simon
I used to be a newbie but then I learned how to spell teh correctly and now I'm a noob!
Re: Query SQL db often
hey guys sorry for the long delay but the forums were messed up on my end for a day....wouldn't allow me to log in....seems to be fixed now...anyhow, here is the crash log compressed the CORRECT way!
Re: Query SQL db often
Wrong format. Unable to extract zip archive.KennyR wrote:hey guys sorry for the long delay but the forums were messed up on my end for a day....wouldn't allow me to log in....seems to be fixed now...anyhow, here is the crash log compressed the CORRECT way!