MS SQL

Rodney Green green.rodney at gmail.com
Sat Apr 26 12:24:17 EDT 2014


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_150811 at 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.rodney at 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.rodney at 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.rodney at 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 <pete at 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.rodney at 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 <pete at 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" <jacque at 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         |     jacque at hyperactivesw.com
> >>>>>>> HyperActive Software           |     http://www.hyperactivesw.com
> >>>>>>>
> >>>>>>> _______________________________________________
> >>>>>>> use-livecode mailing list
> >>>>>>> use-livecode at 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 at 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 at 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the use-livecode mailing list