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@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@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@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
>
--
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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
