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

The BETA tester's 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: 36
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: 612
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: 36
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 Betatest Forum”

Who is online

Users browsing this forum: No registered users and 1 guest