odbc "information type out of range"

[Mike Bonner]

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
>