odbc "information type out of range"

[Mike Kerner]

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."