Just a heads up, remember that SQL servers have a timeout on connections, so when you open a database, remember to close it after you are done. If it has been idle for any length of time, Livecode still thinks it is open, but the SQL server has probably terminated the connection.
This has resolved all my connection hangs I was experiencing in the past. Just a thot. Bob On Apr 23, 2014, at 2:47 PM, Rodney Green <green.rod...@gmail.com> wrote: > I turned on tracing in the odbc driver and I can see field names in the > data. So I'm assuming the query is working. But still can't figure out why > LC is hanging. I have database checked in the stand alone settings, not > sure if this matters while in LC. Any ideas how I can track down why LC is > hanging? > > > On Wed, Apr 23, 2014 at 10:13 AM, Peter Haworth <p...@lcsql.com> wrote: > >> In gmail, you can fix that by using the "Paste and match style" option on >> the edit menu. >> >> Pete >> lcSQL Software >> On Apr 22, 2014 7:34 PM, "J. Landman Gay" <jac...@hyperactivesw.com> >> wrote: >> >>> On 4/22/14, 6:49 PM, Kay C Lan wrote: >>> >>>> I don't know if it's just your email client but what I'm seeing is an >>>> asterisk * around the words get, put and return which shouldn't be >> there. >>>> >>> >>> That happens to all keywords when a colorized script is copied from the >>> script editor and pasted into a text-only email list. I see it here all >> the >>> time. >>> >>> -- >>> Jacqueline Landman Gay | jac...@hyperactivesw.com >>> HyperActive Software | http://www.hyperactivesw.com >>> >>> _______________________________________________ >>> use-livecode mailing list >>> use-livecode@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >>> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
