Search found 3 matches
- 09.02.2006, 15:33
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: Problem with Zeos and PostgreSQL
- Replies: 7
- Views: 1771
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;...
- 07.02.2006, 11:34
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: Problem with Zeos and PostgreSQL
- Replies: 7
- Views: 1771
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...
- 06.02.2006, 18:34
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: Problem with Zeos and PostgreSQL
- Replies: 7
- Views: 1771
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...