Search found 9 matches

by timg11
09.06.2020, 16:58
Forum: Documentations
Topic: Simplest example to perform INSERT into Postgres table?
Replies: 7
Views: 3023

Re: Simplest example to perform INSERT into Postgres table?

I wanted to share how I solved my problem of getting data out of my old D7 application into Postgres. I realized that there is a steep learning curve with Zeos, built around the whole Delphi database approach that I've never used. I could eventually probably figure it out, but I found another way. I...
by timg11
25.05.2020, 17:08
Forum: Documentations
Topic: Simplest example to perform INSERT into Postgres table?
Replies: 7
Views: 3023

Re: Simplest example to perform INSERT into Postgres table?

Thanks! I have no experience with Delphi database or components. I see an name like TZQuery, and I think the word Query means "asking a database to give me some data". I'll keep looking for something to put data into the database.... From reading the ZeosDocumentationCollection-2017-03-20....
by timg11
24.05.2020, 21:36
Forum: Documentations
Topic: Simplest example to perform INSERT into Postgres table?
Replies: 7
Views: 3023

Simplest example to perform INSERT into Postgres table?

A few months ago I was able to install and test Zeoslib in Delphi 7, and was able to connect to the database. Now I'm ready to integrate it into the Delphi program. All I need to do is perform an INSERT. Even with the ZSimple example, there seems to be a lot of functionality I don't need. As I study...
by timg11
24.05.2020, 21:14
Forum: Documentations
Topic: How to Install ZEOS.
Replies: 9
Views: 17775

Re: How to Install ZEOS.

I'm working on this and wanted to explore the ZSimple example. I told it to ignore the missing properties when loading. I copied the Postgress DLLs into the folder. Then when compiling, there is an undefined Refresh_OLD_ID_SEQ error on the line in ZSimpleMain UpdateSQL.Refresh_OLD_ID_SEQ:=true; Comm...
by timg11
04.04.2020, 18:59
Forum: Documentations
Topic: How to Install ZEOS.
Replies: 9
Views: 17775

Re: How to Install ZEOS.

I've solved the database name problem. After looking at the pgAdmin browser, I realized that the database is postgres, and testdata is a table. Changing the database to postgres and connecting now results in an SQL Error Exception "relation "cargo" does not exist - LINE 1:select * fro...
by timg11
04.04.2020, 17:11
Forum: Documentations
Topic: How to Install ZEOS.
Replies: 9
Views: 17775

Re: How to Install ZEOS.

I found this thread regarding the DLL loading issue. It is for FreePascal, so maybe not relevant... It suggested from providing these DLLs from version 12.1 (presumably 64 bit). libcrypto-1_1-x64.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, libssl-1_1-x64.dll. I copied them into the project, but g...
by timg11
04.04.2020, 16:26
Forum: Documentations
Topic: How to Install ZEOS.
Replies: 9
Views: 17775

Re: How to Install ZEOS.

Jan, Thanks for the reply. The "subscription" on this forum doesn't seem to work - I did not receive any email notification of your response. I'm using zeosdbo-7.2.6.1-stable.zip. While waiting for moderator approval here, I asked a question on StackOverflow . I had some suggestions propos...
by timg11
01.04.2020, 14:21
Forum: Documentations
Topic: How to Install ZEOS.
Replies: 9
Views: 17775

Re: How to Install ZEOS.

Running Delphi 7 in Windows 10. I'm trying to connect to PostgreSQL. I installed ZEOS according to the instructions in this thread. The components are installed and visible in the components palette. When trying to build the Zeos Examples projects, I get the following results: ZBlobs - cannot build ...
by timg11
31.03.2020, 23:30
Forum: Documentations
Topic: Installed in D7 but cannot build ZSimple
Replies: 0
Views: 686

Installed in D7 but cannot build ZSimple

I would like to use ZeosLib to connect a Delphi 7 application to PostgreSQL. I was able to follow the installation guide and get Zeos installed in Delphi 7. I edited the library path to include the "build" folder of ZeosLib. However, when I open and try to compile ZSimple project, I get th...