Search found 3 matches

by mpmaia
09.02.2006, 15:33
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem with Zeos and PostgreSQL
Replies: 7
Views: 1747

To work without problems with postgresql I havemodified the ZUpdateSqlEditor.pas. The function GetTableRef now returns a empty string, so the table name is not prefixed to the generated SQL statements. function TZUpdateSQLEditForm.GetTableRef(const TabName: string): string; begin REsult := ''; exit;...
by mpmaia
07.02.2006, 11:34
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem with Zeos and PostgreSQL
Replies: 7
Views: 1747

I fixed the problem, the TZUpdade Sql was generating SQL statements with the table prefixed to the field names, like: INSERT INTO clients (clients.name, clients.address, .... ) VALUES (:name,:address, ...) and I don't know why this was generating the error, because I think this is a valid SQL statem...
by mpmaia
06.02.2006, 18:34
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem with Zeos and PostgreSQL
Replies: 7
Views: 1747

Problem with Zeos and PostgreSQL

Hi, I'm having a problem using Zeos 6.5.1 (alpha) with Postgresql 8.1. I'm using a TZQuery and a TZUpdate. The query works fine, all data is retrieved, but when I post a new record I get the following error: "SQL Error: ERROR: column "client" of relation "client" does not ex...