Thanks Matthias, that's good to know. I'm using the evaluation version but I think that its supposed to return 3 rows of data. This should work in the LC IDE correct? Any ideas on how I can trap this error?
On Fri, Apr 25, 2014 at 7:22 PM, Matthias Rebbe | M-R-D < matthias_livecode_150...@m-r-d.de> wrote: > Hi Rodney, > > i am using the Actualtech ODBC driver with Microsoft SQL server without > problems. > Just to be sure that there are no problems with newer versions of LC i did > a quick test right now with one of my projects with LC 6.7.0DP2, > Actualtech ODBC driver version 3.2.3 and MS SQL Server 2005 and 2008. > My select query is about 70 lines contains several case statements with > several replace statements and several joins. All is working as expected > even over VPN. > > Regards, > > Matthias > > > > > > Am 25.04.2014 um 00:51 schrieb Rodney Green <green.rod...@gmail.com>: > > > 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 > _______________________________________________ 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
