OMG Martina,

I just changed the order of creating the cursors.. and the error was gone!!!!!

I really don't know the how and the why.. but I will take it..

Dennis


>Hi Dennis,
>
>It's possible. The bug can be in ODBC driver or MySQL server.
>But nobody find the cause without runable example.
>
>
>MartinaJ
>
>>Hi Martina,
>>
>>I have never had these problems as well, till I used MySQL Server 8.0.30.
>>
>>Now, I am back to 5.7.37 with ODBC 8.0.30. I ran all my code here with zero problems.
>>
>>So I guess MySQL Server 8.0.30 is the culprit.
>>
>>
>>>Hi Dennis,
>>>
>>>I use decimal and tinyint datatypes too, withouth problems.
>>>
>>>MartinaJ
>>>
>>>>Martina,
>>>>
>>>>This is the CursorSchema of table PIHDR:
>>>>

>>>>CREATE TABLE `pihdr` (
>>>>  `refno` char(8) DEFAULT '',
>>>>  `date` date NOT NULL,
>>>>  `supplierid` char(5) DEFAULT '',
>>>>  `suprefno` char(15) DEFAULT '',
>>>>  `terms` tinyint DEFAULT '0',
>>>>  `isvat` tinyint DEFAULT '0',
>>>>  `vatrate` decimal(6,2) DEFAULT '0.00',
>>>>  `isewtax` tinyint DEFAULT '0',
>>>>  `ewtaxid` char(5) DEFAULT '',
>>>>  `ewtaxrate` decimal(6,2) DEFAULT '0.00',
>>>>  `dtlcnt` decimal(3,0) DEFAULT '0',
>>>>  `totqty` decimal(12,2) DEFAULT '0.00',
>>>>  `amtgross` decimal(15,2) DEFAULT '0.00',
>>>>  `amtvat` decimal(12,2) DEFAULT '0.00',
>>>>  `amtpurch` decimal(15,2) DEFAULT '0.00',
>>>>  `amtewtax` decimal(12,2) DEFAULT '0.00',
>>>>  `amtpayable` decimal(15,2) DEFAULT '0.00',
>>>>  `jrnlcnt` decimal(3,0) DEFAULT '0',
>>>>  `amtdebit` decimal(15,2) DEFAULT '0.00',
>>>>  `amtcredit` decimal(15,2) DEFAULT '0.00',
>>>>  `istemplate` tinyint DEFAULT '0',
>>>>  `jthdrid` char(32) DEFAULT '',
>>>>  `notes` text,
>>>>  `posted` tinyint DEFAULT '0',
>>>>  `cancelled` tinyint DEFAULT '0',
>>>>  `printctr` tinyint DEFAULT '0',
>>>>  `uidcreate` char(20) DEFAULT '',
>>>>  `uidedit` char(20) DEFAULT '',
>>>>  `uidprint` char(20) DEFAULT '',
>>>>  `uidpost` char(20) DEFAULT '',
>>>>  `id` char(32) NOT NULL DEFAULT '',
>>>>  PRIMARY KEY (`id`),
>>>>  UNIQUE KEY `REFNO` (`refno`),
>>>>  KEY `SUPPLIERID` (`supplierid`),
>>>>  KEY `EWTAXID` (`ewtaxid`),
>>>>  KEY `JTHDRID` (`jthdrid`)
>>>>) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
>>>>

>>>>
>>>>My gut is telling me there is something wrong too many TINYINT and DECIMAL columns?
>>>>
>>>>I got another module with same error, and both have that in common.
>>>>