DBGrid insert fails - Raspberry Pi Jessie, PostgreSQL 9.4.10, Lazarus

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
ertank
Junior Boarder
Junior Boarder
Posts: 37
Joined: 02.06.2017, 12:00

DBGrid insert fails - Raspberry Pi Jessie, PostgreSQL 9.4.10, Lazarus

Postby ertank » 02.06.2017, 12:22

Hello,

I have a project that has to be developed on a Raspberry Pi 3 device. I am using Lazarus 1.8RC1 and Zeos 7.2.1-RC1. Both built from sources. PostgreSQL is installed using apt-get and running on Raspberry Pi.

I have below table in my database:

Code: Select all

CREATE TABLE malzemeler
(
  kodu character varying(20) NOT NULL,
  adi character varying(40),
  paketiciadet smallint,
  kayitzamani timestamp without time zone,
  kaydeden character varying(40),
  degisiklikzamani timestamp without time zone,
  degistiren character varying(40),
  secili smallint,
  CONSTRAINT malzemeler_pkey PRIMARY KEY (kodu)
)


I put ZConnection, ZQuery, DataSource and DBGrid. All settings are defaults. Adjust necessary links. Establish connection and Activate the query at design time. Query is a simple one

Code: Select all

select * from malzemeler


I run the application try to add a new record and I receive below error message:

Code: Select all

null value in column "kodu" violates not-null constraint
DETAIL: Failing row contains (null, null, null, null, null, null, null, null).


However, I have a value entered in DBGrid in column "kodu" and focus is set to another column just to be sure that value is assigned to the column.

Same problem I can reproduce using 7.1.4 stable package. But I need to use 7.2 latest for PostgreSQL and recently changed transaction behavior.

Any help is appreciated.

Thanks & regards,
Ertan

marsupilami
Gold Boarder
Gold Boarder
Posts: 662
Joined: 17.01.2011, 14:17

Re: DBGrid insert fails - Raspberry Pi Jessie, PostgreSQL 9.4.10, Lazarus

Postby marsupilami » 06.06.2017, 14:47

Duh - I will have to get my Raspberry PI set up to test this. I will be back when that is finished.

ertank
Junior Boarder
Junior Boarder
Posts: 37
Joined: 02.06.2017, 12:00

Re: DBGrid insert fails - Raspberry Pi Jessie, PostgreSQL 9.4.10, Lazarus

Postby ertank » 06.06.2017, 21:23

I do believe this problem directly links to my other thread here: http://zeoslib.sourceforge.net/viewtopic.php?f=40&t=68754


Return to “ZeosLib 7.2 Forum”

Who is online

Users browsing this forum: No registered users and 1 guest