I use revDataFromQuery all the time, but it's to access a local (to the app) sqlite DB. Works great with SQLite
I also use MS SQL Server, but only access it via custom web services. I have never had any luck connecting to it otherwise. I've heard good things about the Actual Drivers, but again, never used it. Web services are a great way to connect to SQLServer if you have the infrastructure to run it. Cross platform, etc. I develop on a Mac, OS X 10.9.2 HTH, Steve MacLean On Apr 24, 2014, at 6:51 PM, Rodney Green <green.rod...@gmail.com> wrote: > I'm curious, does anyone have a project that uses the revDataFromQuery() > command? And does anyone use the Actual Technologies ODBC driver? > > > On Thu, Apr 24, 2014 at 9:23 AM, Rodney Green <green.rod...@gmail.com>wrote: > >> I'll put in a bug report for this. Does anyone have any kind of >> work-around for this? Have there been any updates to database in the >> developer previews? Maybe I'll give a DP a try. >> >> >> On Wed, Apr 23, 2014 at 7:53 PM, Rodney Green <green.rod...@gmail.com>wrote: >> >>> I tried it in 6.6 and 6.6.1. I'm using Actual Technologies ODBC manager >>> (demo). And I can connect successfully to the SQL server with Navicat. I'm >>> on a Mac (10.9.2) and connecting via a VPN. >>> >>> >>> On Wed, Apr 23, 2014 at 7:17 PM, Peter Haworth <p...@lcsql.com> wrote: >>> >>>> That seems strange - I wouldn't expect to see field names, just the data >>>> in >>>> them. What version of LC are you using? Might be time to enter a bug >>>> report. >>>> >>>> Pete >>>> lcSQL Software <http://www.lcsql.com> >>>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and >>>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> >>>> >>>> >>>> On Wed, 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 >>>> >>> >>> >> > _______________________________________________ > 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
