Mydac 3.5.17 have bug?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
amosqueda

Mydac 3.5.17 have bug?

Post by amosqueda » Thu 19 May 2005 04:43

I have one table with 47 fields, and when I try post table, MyDac send my the follow messagge:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Dual, EmpDual, Seccion, Nivel, Mausoleo, FechPPago, Dcto, Total, Enganche, Plazo' at line 2

This field is there aprox in field 22, the insert code is:

INSERT INTO MauCont
(Contrato, Solicitud, Fecha, Nombre, Domicilio, Colosect, Mun_edo, Telefono, CP, FechNaci, Sexo, EdoCiv, Profesion, Ingreso, Empresa, TelEmp, Benefi1, Benefi2, Agte, Plan, Servicios,
Serv_pres, Dual, EmpDual, Seccion, Nivel, Mausoleo, FechPPago, Dcto, Total, Enganche, Plazo, Saldo, Interes, Descuento, FechUltPag, Pagado, UltDocPag, Cancelado, FechaCan, Titulo, Factura, TipoCan, TipoServ, Comprados, SuconTel, SuconPos)
VALUES
(:Contrato, :Solicitud, :Fecha, :Nombre, :Domicilio, :Colosect, :Mun_edo, :Telefono, :CP, :FechNaci, :Sexo, :EdoCiv, :Profesion, :Ingreso, :Empresa, :TelEmp, :Benefi1, :Benefi2, :Agte, :Plan, :Servicios, :Serv_pres,
:Dual, :EmpDual, :Seccion, :Nivel, :Mausoleo, :FechPPago, :Dcto, :Total, :Enganche, :Plazo, :Saldo, :Interes, :Descuento, :FechUltPag, :Pagado, :UltDocPag, :Cancelado, :FechaCan, :Titulo, :Factura, :TipoCan, :TipoServ, :Comprados, :SuconTel, :SuconPos)


MY QUESTION IS:

MyDac have some limitation of record large??

You can help my?

Some idea?

Saludos

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 19 May 2005 07:20

> MyDac have some limitation of record large??

No

> Some idea?

Try to download MyDAC last version (3.50.0.20). If problem persists then send us complete small sample to demonstrate it and include script to create MauCont.

Post Reply