odbc "information type out of range"

[Mike Bonner]

Ah k. was hoping.

On Fri, Jul 6, 2018 at 3:36 PM Mike Kerner via use-livecode <
use-livecode at lists.runrev.com> wrote:

> The bizarre parts are
> a) No errors returned from Valentina
> b) The operations succeed but I get an error, almost like LC is sending
> something extra to the ODBC driver.
>
> Ralph:
> Windows, connecting to Marxmeier's SQL/R (which is connecting to eloquence,
> a legacy mainframe environment for HP).
>
> Bob
> No
>
> mike,
> That gives me
>
> revdberr,[Marxmeier][SQL/R ODBC Server]37000 - Unexpected symbol (#1)
>
> syntax error near "("
>
>
> Unexpected symbol or invalid SQL/R language statement.
>
>
> On Fri, Jul 6, 2018 at 1:04 PM Mike Bonner via use-livecode <
> use-livecode at lists.runrev.com> wrote:
>
> > I have no way to test it, but if you change your insert to..
> > insert into employee (empno) values (double(-1))
> >
> > Does it make a difference?
> >
> >
> > On Fri, Jul 6, 2018 at 10:14 AM Mike Kerner via use-livecode <
> > use-livecode at lists.runrev.com> wrote:
> >
> > > Hmmm.  How about this:  The insert is actually succeeding, but I'm
> > getting
> > > the error.
> > >
> > > select count (*) from employee where empno=-1 -> 0
> > > insert into employee (empno) values (-1) -> "revdberr,[Microsoft][ODBC
> > > Driver Manager] Information type out of range"
> > > select count (*) from employee where empno=-1 -> 1
> > > delete from employee where empno = -1 -> "revdberr,[Microsoft][ODBC
> > Driver
> > > Manager] Information type out of range"
> > > select count (*) from employee where empno=-1 -> 0
> > > _______________________________________________
> > > 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
> >
>
>
> --
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>    and did a little diving.
> And God said, "This is good."
> _______________________________________________
> 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
>