Search found 159 matches

by Wild_Pointer
03.12.2013, 10:28
Forum: ZeosLib 7.1 stable Forum
Topic: protocol differencies
Replies: 3
Views: 336

Re: protocol differencies

Hello, The Name? Actually there are NO behavior changes. Just a hint "we support PG9+". Are you sure? For some unknown reason we get range check errors on some computers when using postgresql-8 and they are gone if we use postgres-9... I was unable to reproduce it on my computer, but the p...
by Wild_Pointer
20.11.2013, 10:03
Forum: 6.6 - stable
Topic: windows 7 - SQLHourGlass - SLOW
Replies: 12
Views: 2311

Re: windows 7 - SQLHourGlass - SLOW

Hello marsupilami,

Thank You for the explanation.

Best regards,
Wild Pointer
by Wild_Pointer
19.11.2013, 11:01
Forum: 6.6 - stable
Topic: windows 7 - SQLHourGlass - SLOW
Replies: 12
Views: 2311

Re: windows 7 - SQLHourGlass - SLOW

Hello, marsupilami I thought about that too, like replacing all ZQuery.Open with OpenDataSet(ZQuery) where procedure OpenDataSet(ADataSet: TZQuery) begin ADataSet.Connection.ShowSQLHourGlass; try ADataSet.Open; finally ADataSet.Connection.HideSQLHourGlass; end; end; After thinking about that a bit l...
by Wild_Pointer
18.11.2013, 09:48
Forum: 6.6 - stable
Topic: windows 7 - SQLHourGlass - SLOW
Replies: 12
Views: 2311

Re: windows 7 - SQLHourGlass - SLOW

Hello mdaems, it took me some time :). As usual, when a temporary solution is made, the proper fix is postponed. Anyway after switching to Zeos 7.0.6 we faced the same decrease in performance so here I am sending a patch. It speeds things up for me. I've used git on 7.0.6 version of ZeosLib. If I sh...
by Wild_Pointer
24.08.2013, 22:04
Forum: SQLite
Topic: detail Sqlite error messages
Replies: 1
Views: 770

detail Sqlite error messages

hello, I've noticed that error messages for SQLite are useless. What can you say when you get error "SQL logic error or missing database" when you have the name of table misspelled in the SQL statement you want to execute? So I made error messages more detail using sqlite_errstr function. ...
by Wild_Pointer
15.08.2013, 11:18
Forum: 6.6 - stable
Topic: Syntax error - Multiple commands
Replies: 2
Views: 760

Hello,

the other solution is to change the SQL to:

Code: Select all

UPDATE SCE2_ESTQUIMI SET quant_nf = quant_nf + 1 WHERE codigo IN (200, 201, 202)

That should increase the speed of your application.

Good luck!
by Wild_Pointer
25.01.2013, 11:32
Forum: PostgreSQL
Topic: Comments of DB Objects in Zeos
Replies: 4
Views: 1019

EgonHugeist , ProstgreSQL doesn't convert the characters to your current client encoding? Well, it tries but because the byte-sequences are incompatible it gives an exception "SQL Error: ERROR: character with byte sequence 0xc5 0xa1 in encoding "UTF8" has no equivalent in encoding &q...
by Wild_Pointer
24.01.2013, 11:02
Forum: PostgreSQL
Topic: Comments of DB Objects in Zeos
Replies: 4
Views: 1019

Comments of DB Objects in Zeos

Hello, in ZDbcPostgreSqlMetadata.pas I see the table of DB comments (pg_description) is used when getting column information : function TZPostgreSQLDatabaseMetadata.UncachedGetColumns(const Catalog: string; const SchemaPattern: string; const TableNamePattern: string; const ColumnNamePattern: str...
by Wild_Pointer
31.10.2012, 14:41
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos does not recognize the command case of PostgreSQL.
Replies: 3
Views: 712

Not strange at all :) This is how Data Aware component TDbGrid works. It does not show the value for the memo fields. Someone should correct me if I'm mistaken but it is the libpq that tells the Zeos lib that the column is memo. You could try selecting value from the column that is varchar(N) where ...
by Wild_Pointer
31.10.2012, 09:46
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos does not recognize the command case of PostgreSQL.
Replies: 3
Views: 712

Hello elidorio2 , the problem is the Postgresql server presumes the result of case command is text. Text type fields are used as memo fields in Zeos. Try casting the result of case command to character varying (20) and you'll get what you want. example SELECT ..., CAST( case when .... then .... end ...
by Wild_Pointer
12.03.2012, 16:11
Forum: 6.6 - stable
Topic: windows 7 - SQLHourGlass - SLOW
Replies: 12
Views: 2311

Hello mdaems , sorry for a long delay. I would be glad to produce such a patch, but I wanted to consult You a bit before coding: 1) by saying ZQuery property did you mean new property of a component or a new parameter in TZQuery.Properties? 2) what name would you suggest for it? BusyPointerWhenScrol...
by Wild_Pointer
05.03.2012, 10:30
Forum: ZeosLib 7.0 Beta Forum
Topic: comerr32.dll not found
Replies: 2
Views: 686

Hello hzmsky , are you sure you have all the dll's used by the libpq ? Zeos uses this library to connect to postgresql DB. If you are not sure what files are needed just open pgAdmin directory (I'm sure you have it if you work with PostgreSQL) or from the Postgresql subdirectory named "bin"...
by Wild_Pointer
22.01.2012, 14:38
Forum: 6.6 - stable
Topic: windows 7 - SQLHourGlass - SLOW
Replies: 12
Views: 2311

Hello, vajtsz , I'm not sure what zeos is doing when you "click on a menupoint", but I can share my experience here. I've noticed that if I do a TZQuery scan (read every row in a cycle) my program performance is poor. Also like You I observed, that SQLHourGlass := False eliminates the prob...
by Wild_Pointer
05.01.2012, 11:58
Forum: ZeosLib 7.0 Beta Forum
Topic: Numeric - float, rounding problem
Replies: 14
Views: 817

hello papelhigienico,

but float(32) bit should have at least 7 digit precision. This is more than needed for the example. Please explain in more detail what goes wrong here please.

Thank you in advance
by Wild_Pointer
05.01.2012, 08:36
Forum: ZeosLib 7.0 Beta Forum
Topic: Numeric - float, rounding problem
Replies: 14
Views: 817

hello

try deleting field and then adding it manually in the field list. When adding manually you can specify the field type. There is no way to convert a field from one type to another without recreating it. I'm not sure it will help (or work at all) but please experiment :)

Good luck!

Go to advanced search