Hello,
My detailed versions are:
Lazarus 1.8RC1 build from sources on Raspberry Pi 3. SVN Revision: 55121, Date: 27-05-2017, FPC version: 3.0.2 (also build from sources)
PostgreSQL 9.4.10 on armv7l-unknown-linux-gnueabihf, compiled by gcc (Raspbian 4.9.2-10) 4.9.2, 32-bit
Both are on the same device.
I have below table in my database:
CREATE TABLE personel
(
adisoyadi character varying(40) NOT NULL,
grup character varying(10),
kayitzamani timestamp without time zone,
kaydeden character varying(40),
degisiklikzamani timestamp without time zone,
degistiren character varying(40),
CONSTRAINT personel_pkey PRIMARY KEY (adisoyadi)
)
When I do "select * from personel" PgAdmin III displaying that I have one record in it and all fields have value except degisiklikzamani and degistiren. These two fields both are null.
Problem 1: I start a fresh new Application, put PQConnection, SQLTransaction, SQLQuery on the form. Activate database connection at design time.
Write below in SQL property of SQLQuery to
select * from personel
When I try to activate SQLQuery (design time or run-time) I get error message saying:
SQLQuery1 : Field not found : "degisiklikzamani"
Problem 2: I create a test table:
CREATE TABLE test
(
atext text,
anumber integer
);
insert into test (anumber) values(1);
Do a select in PgAdmin III SQL Editor and I get single row with anumber having value of 1, atext is null (as expected)
If I try to use SQLQuery to "select * from test" this time I receive:
Access violation error.
It doesn't help to have single row with having both fields with some value. I still continue to get Access violation error. Error message is displayed both at Activating and dis-activating SQLQuery.
Even I have Access violation error, a DataSource and DBGrid connected to SQLQuery display me records selected. This does not work with my above Problem 1. I do not get any record in this case.
I do not understand if I am doing wrong here. I have another table
Appreciate any help.
Thanks & regards,
-Ertan