Re: odbc "information type out of range"
Ah k. was hoping.
On Fri, Jul 6, 2018 at 3:36 PM Mike Kerner via use-livecode <
use-livecode@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@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
>
___
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
Re: odbc "information type out of range"
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
Re: odbc "information type out of range"
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
Re: odbc "information type out of range"
Is empno an auto incrementing column? Bob S > On Jul 6, 2018, at 09:06 , Mike Kerner via use-livecode > wrote: > > I've got an odbc database that I'm trying to write to. From a tool like > valentina it works fine, but in LC I'm getting "Information type out of > range" from the driver. > The line that fails is > insert into employee (empno) values (-1) ___ 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
RE: odbc "information type out of range"
Mike, What DB engine and odbc driver version are you using? Mac, Windows, Mobile? Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -Original Message- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Mike Kerner via use-livecode Sent: Friday, July 06, 2018 12:06 PM To: How to use LiveCode Cc: Mike Kerner Subject: odbc "information type out of range" I've got an odbc database that I'm trying to write to. From a tool like valentina it works fine, but in LC I'm getting "Information type out of range" from the driver. The line that fails is insert into employee (empno) values (-1) employee is defined as a double. Again, that very same line in valentina works. I'm using LC 9.0 -- 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 ___ 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
Re: odbc "information type out of range"
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
