Search found 25 matches

by WorldWalker
20.01.2013, 14:51
Forum: ZeosLib 7.0 Stable Forum
Topic: [solved] PostgreSQL : Can not update this query type
Replies: 7
Views: 2198

Hello, Thank you for this detailed explanation, anyway working with lowercase statements in the runtime executed queries is simple and could be easily applied as solution in end-user application, thus it's a fix without a need to change a whole codebase behavior in ZeosLib, Thank you for your time, ...
by WorldWalker
16.01.2013, 15:40
Forum: ZeosLib 7.0 Stable Forum
Topic: [solved] PostgreSQL : Can not update this query type
Replies: 7
Views: 2198

EgonHugeist, I recieve the exception Table "Test" not found, that's normal, so there is no fields within the query as it was not opened. In the example I sent you I can open the query in designtime sample as read-only and in the runtime I can open it for edit, but I recieve the exception &...
by WorldWalker
16.01.2013, 09:12
Forum: ZeosLib 7.0 Stable Forum
Topic: [solved] PostgreSQL : Can not update this query type
Replies: 7
Views: 2198

Am i right?
Yes, that's true.

Best regards.
by WorldWalker
15.01.2013, 16:23
Forum: ZeosLib 7.0 Stable Forum
Topic: [solved] PostgreSQL : Can not update this query type
Replies: 7
Views: 2198

[solved] PostgreSQL : Can not update this query type

Hello, Sorry for writing here as the old one is locked! At last I found the reason, as my code was executed at run time I spent several hours to extract the SQL code and I discovered that something maybe strange: if I execute SELECT * FROM test the query is executed normally but if the table name is...
by WorldWalker
09.01.2013, 13:57
Forum: PostgreSQL
Topic: database name case
Replies: 4
Views: 2058

tintinux,
It's not an issue it's the case sensitive mechanisme.
Regards.
by WorldWalker
06.01.2013, 11:51
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeosdbo-9.0.1-beta_r1918 for CodeTyphon 3.00 Beta1
Replies: 9
Views: 3448

Hi again, ZeosLib 7.0.1 beta failed with "cannot find ZEncode.pas" while the latest 7.0.3 Stable (that I didn't know about it only few minutes ago :) ) is working good. Thus with ZeosLib-7.0.3, Lazarus32 ,CodeTyphon 3.1 and Postgres 9.1, I have a database application running on a Raspberry...
by WorldWalker
06.01.2013, 09:18
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeosdbo-9.0.1-beta_r1918 for CodeTyphon 3.00 Beta1
Replies: 9
Views: 3448

Hello,
Good work but what did you do exactly, I failed to install zeosdbo 7.0.1 on CodeTyphon 3.1. Uninstalling pl_zeosbdo and intslaling ZeosDBO didn't succeed neither replacing the files and building Lazarus too, I'll give a try your files.
Best regards.
by WorldWalker
06.01.2013, 09:10
Forum: ZeosLib 7.0 Beta Forum
Topic: PostgreSQL : Can not update this query type
Replies: 7
Views: 2923

Hello,
No, there is no special chars in the table.
MFG
by WorldWalker
28.12.2012, 08:48
Forum: ZeosLib 7.0 Beta Forum
Topic: PostgreSQL : Can not update this query type
Replies: 7
Views: 2923

Hello, Well I found some difficulties to give the step by step guide to reproduce the bug, as it's a part of complexe code and I didn't found the easiest way to extract the methode as it's a part of many different units, and while doing that I found that the problem only occurs on Windows plateform ...
by WorldWalker
22.12.2012, 11:59
Forum: ZeosLib 7.0 Beta Forum
Topic: PostgreSQL : Can not update this query type
Replies: 7
Views: 2923

EgonHugeist, Thank you very much for your quick reply and your support, as you said the error is related to the missed table name and raised within TZGenericCachedResolver.DefineTableName TZAbstractDataset.InternalUpdate Anyway TZUpdateSQL solves the problem, despite the query is a simple SELECT * F...
by WorldWalker
22.12.2012, 10:46
Forum: ZeosLib 7.0 Beta Forum
Topic: PostgreSQL : Can not update this query type
Replies: 7
Views: 2923

PostgreSQL : Can not update this query type

Hi all, First of all I'd like to thank for your nice work. I am using a Run Time Fields control creation from TZQuery+TDatasource both created at design time. e.g.: I create a TDBEdit for every character varying field retrieved from the metadata. I'm receiving the 'Can not update this query type' wh...
by WorldWalker
12.11.2009, 06:27
Forum: ZeosLib 7.0 Beta Forum
Topic: Strange characters
Replies: 8
Views: 1148

Hi,
I've just tried this, it didn't work neither.

Thank you again.
by WorldWalker
12.11.2009, 06:19
Forum: ZeosLib 7.0 Beta Forum
Topic: Cannot update this query type
Replies: 6
Views: 1708

Yes, just elementary queries and using primary key.
I'd even avoided to call "order by" and recreated empty tables to understand this behavior but I failed.
I'm still trying,
Thanks ever so much for your reply.
by WorldWalker
08.11.2009, 11:53
Forum: ZeosLib 7.0 Beta Forum
Topic: Strange characters
Replies: 8
Views: 1148

Strange characters

Hi,

I am using a db with character ENCODING = 'Latin9', and when I post a string including special characters (latin9) they are converted to strange ones.
Postgres 8.4.1
D2010 Pro
Zeos Rev.716
Did someone faced that before?
Thanks.
by WorldWalker
08.11.2009, 10:09
Forum: ZeosLib 7.0 Beta Forum
Topic: Cannot update this query type
Replies: 6
Views: 1708

Hi All,
I've just realized that the error occurs in a random way, it works with some queries fine and with others the error is shown when I attempt to update, insert or delete.

I'm using Postgres 8.4.1

Any ideas?