Search found 13 matches

by aleroot
15.12.2014, 00:50
Forum: ZeosLib 7.1 stable Forum
Topic: 7.1 and Kylix 3 not supported
Replies: 1
Views: 591

7.1 and Kylix 3 not supported

I've just tried to build zeoslib 7.1 with Kylix 3 and I've noticed that it is not supported anymore ...

Since I would need the support, someone could indicate to me what was the main reason to drop Kylix 3 support ?

If I want to port it to Kylix 3 : what are the main issues to be aware of ?

thanks.
by aleroot
04.08.2014, 23:15
Forum: ZeosLib 7.1 stable Forum
Topic: Delphi7 + zeos 7.1.3 + PostgreSQL € char saved as Ôé¼
Replies: 4
Views: 1132

Re: Delphi7 + zeos 7.1.3 + PostgreSQL € char saved as Ôé¼

Ok, setting AutoEncodeStrings to True solved the problem ...
by aleroot
01.08.2014, 11:07
Forum: ZeosLib 7.1 stable Forum
Topic: Delphi7 + zeos 7.1.3 + PostgreSQL € char saved as Ôé¼
Replies: 4
Views: 1132

Re: Delphi7 + zeos 7.1.3 + PostgreSQL € char saved as Ôé¼

I've tried with the latest version of zeoslib 7.1 in the SVN repository and changing the clientcodepage property as you pointed out, but still the same problem.

Note that I'm using CLX graphic library and that the string is coming from a TEdit .
by aleroot
30.07.2014, 18:05
Forum: ZeosLib 7.1 stable Forum
Topic: Delphi7 + zeos 7.1.3 + PostgreSQL € char saved as Ôé¼
Replies: 4
Views: 1132

Delphi7 + zeos 7.1.3 + PostgreSQL € char saved as Ôé¼

I'm experiencing a strange problem saving € sign into a PostgreSQL 9.3 database, the € sign is saved as : Ôé¼ . I even tried to change the following properties on the TZConnection object, but with no luck : ZDBase.Properties.Values['codepage']:='WIN1252'; ZDBase.Properties.Values['client_encoding']:...
by aleroot
11.11.2013, 12:38
Forum: ZeosLib 7.1 stable Forum
Topic: 0 record(s) updated. Only one record should have been update
Replies: 18
Views: 7872

Re: 0 record(s) updated. Only one record should have been up

I don't use Firebird at all, I use only MSSQL and MySQL (where the problem occur, on MSSQL I don't have any problem).

The previous version was 6.6.6
by aleroot
08.11.2013, 14:56
Forum: ZeosLib 7.1 stable Forum
Topic: 0 record(s) updated. Only one record should have been update
Replies: 18
Views: 7872

0 record(s) updated. Only one record should have been update

Only on mySQL I get back this message in some situation after posting changes to a Ztable : aZTABLE.Post 0 record(s) updated. Only one record should have been updated The error is displayed in a messageBox and i removed it commenting this define : {$DEFINE WITH_VALIDATE_UPDATE_COUNT} Why with previo...
by aleroot
27.09.2013, 10:49
Forum: ZeosLib 7.0 Stable Forum
Topic: ZTable linked with TEMPORARY TABLE
Replies: 4
Views: 2835

Re: ZTable linked with TEMPORARY TABLE

Basically I need a ZTAble that link to a Temporary table, this means that the TABLE in the database is created with : CREATE TEMPORARY TABLE sometable (on Mysql, POstgresql, ...) CREATE TABLE #sometable (on mssql) I need these kind of tables because I want them dropped automatically at the Connectio...
by aleroot
27.09.2013, 10:45
Forum: ZeosLib 7.0 Stable Forum
Topic: DBError 1007 Committing changes on mssql
Replies: 2
Views: 1788

Re: DBError 1007 Committing changes on mssql

AutoCommit = True
Protocol = 'mssql'

Others to default ... With other database type (e.g. : PostgreSQL, Mysql) it works without any problem, while on mssql I have the above error.
by aleroot
22.09.2013, 10:19
Forum: ZeosLib 7.0 Stable Forum
Topic: ZTable linked with TEMPORARY TABLE
Replies: 4
Views: 2835

ZTable linked with TEMPORARY TABLE

HI,
I have an application that make use of a lot of temporary tables, and i was wondering if it is possible to link a TEMPORARY TABLE with a ZTable object or if there is a better way to handle this kind of tables .

Anyone have any suggestion ?


Thanks.
by aleroot
21.09.2013, 19:51
Forum: ZeosLib 7.0 Stable Forum
Topic: DBError 1007 Committing changes on mssql
Replies: 2
Views: 1788

DBError 1007 Committing changes on mssql

Hi, I have a strange problem with ZEOS 7.0.5 and SqlServer 2005 using the mssql library, when I try to commit changes i get the error DBError 1007 from SQL Server that says that A Begin Transaction is not called ... The strange thing is that the record is correctly inserted in the database table des...
by aleroot
30.06.2013, 20:49
Forum: 6.6 - stable
Topic: TZTable and temporary tables
Replies: 3
Views: 2255

TZTable and temporary tables

I'm trying to use a TZTAble component to link a Temporary table on mssql(e.g. #tablename ), but I get an error each time I try to open the TZTable component ... The error message say table #tablename not found even if the table is present because I have previously created it with a TZQuery ... Is th...
by aleroot
23.02.2013, 20:47
Forum: 6.6 - stable
Topic: List all indexes on a table
Replies: 3
Views: 1993

Never used the Dbc-tier, can you post an example ?


Thanks.
by aleroot
21.02.2013, 22:30
Forum: 6.6 - stable
Topic: List all indexes on a table
Replies: 3
Views: 1993

List all indexes on a table

Hi,
is it possible to list all indexes on a table in a standard and database independent way ?

How can it be done ?

Thanks.