TDataSetInsert - TActionList
lazarus / 16-Databases

----------------------------------------------------------------------
manolo · 2011-01-05 02:50

Hi everyone:

I have made an small windows application using Lazarus 0.9.29 in
windows XP Professional SP3 32-bit with ZEOSDBO-6.6.6 and Firebird
2.1.3 for the same operating system.

I use the component TActionList and I added a Standard Action -
TDataSetInsert linked to the corresponding datassource.

The datasource is linked to a TZQuery component which has this SQL:
select *
from sucursales s
order by s.nombre

that TZQuery component query has a TZUpdateSQL component which has the
fallowing Insert SQL:
INSERT INTO sucursales
  (ID_SUCURSAL, ID_CIUDAD, ID_ZONA, NOMBRE, DIRECCION, TELEFONO,
ALIAS,
   CODIGO_SUCURSAL_DOCUMENTO, NRO_BOCA_EXPEDICION, ACTIVO)
VALUES
  (:ID_SUCURSAL, :ID_CIUDAD, :ID_ZONA, :NOMBRE, :DIRECCION, :TELEFONO,
   :ALIAS, :CODIGO_SUCURSAL_DOCUMENTO, :NRO_BOCA_EXPEDICION, :ACTIVO)

And Finally I added an TButton linked its property Action with the
TDataSetInert Action defined above.

I connected to the database with the database's owner, but the button
doesn't enable it at all, even more, I dropped down a TDBNavigator
component and works fine, I mean, I can insert a new record!!.

I have proved with TIBConection that is in the SQLdb pallet comming
with lazarus by default and the same thing.

I think is something wrong with TDataSetInert, I searched in Internet
but nothing about it!!.

Does anybody has a clue around this issue??

Thanks a lot!!