Search found 600 matches

by marsupilami
12.01.2018, 08:17
Forum: Firebird
Topic: Support for CHAR(16) CHARACTER SET OCTETS
Replies: 10
Views: 79

Re: Support for CHAR(16) CHARACTER SET OCTETS

Hello Fr0sT, I suggest to add two parameters. One for the connection and one for the dataset. On the connection there could be a parameter for specifying a GUID domain. For example: ZConnection.Properties.Add('FB_UUID_DOMAIN=FAKEUUID') On the data set there could be a parameter that takes a field li...
by marsupilami
11.01.2018, 18:13
Forum: ZeosLib 7.2 Betatest Forum
Topic: Problems in the field editor with fields of the same name in two different tables
Replies: 16
Views: 172

Re: Problems in the field editor with fields of the same name in two different tables

Hello Fr0st, 1) Unquote field names in TZGenericStatementAnalyser.FillFieldRefs - global change for all drivers; the most early processing and does what you plan for 7.3. But: SelectSchema doesn't link to IdentifierConvertor so unquoting will be the same for all drivers or additional reference to co...
by marsupilami
11.01.2018, 10:00
Forum: Firebird
Topic: Support for CHAR(16) CHARACTER SET OCTETS
Replies: 10
Views: 79

Re: Support for CHAR(16) CHARACTER SET OCTETS

Hello Fr0st, I agree that I dislike the pattern idea. And I see the benefits of an approach where the developer specifies which fields are to be treated as GUID-Fields in each and every data set. This is the most flexible approach. But in any bigger application it would require the developer to do t...
by marsupilami
11.01.2018, 09:45
Forum: ZeosLib 7.2 Betatest Forum
Topic: Problems in the field editor with fields of the same name in two different tables
Replies: 16
Views: 172

Re: Problems in the field editor with fields of the same name in two different tables

Hello Fr0st, I had a talk with EgonHugeist yesterday. From an API perspective we agree that usually the identifier patterns or identifierrs that go into GetColumns and the like should already have the correct case and should not be quoted. So the right way to go would be to modify all callers to not...
by marsupilami
10.01.2018, 11:56
Forum: Firebird
Topic: Support for CHAR(16) CHARACTER SET OCTETS
Replies: 10
Views: 79

Re: Support for CHAR(16) CHARACTER SET OCTETS

It might make sense to have an option where a domain can be specified that is to be translated into ftGUID. Imagine you declare a domain like this: CREATE DOMAIN FAKEGUID AS CHAR(16) CHARACTER SET OCTETS; The driver then could treat all columns of this domain to be ftGuid. Which domain is to be used...
by marsupilami
10.01.2018, 11:47
Forum: ZeosLib 7.2 Betatest Forum
Topic: Problems in the field editor with fields of the same name in two different tables
Replies: 16
Views: 172

Re: Problems in the field editor with fields of the same name in two different tables

Hello Fr0st,

UncachedGetColumns should be supplied with column names in the correct case - upper case if field names are unquoted. So if the case is not correct the caller should be corrected. I hope, this somehow helps you.

With best regards,

Jan
by marsupilami
10.01.2018, 09:27
Forum: Firebird
Topic: Firebird and TGuidField
Replies: 3
Views: 43

Re: Firebird and TGuidField

Moved to the Firebird Forum.
by marsupilami
09.01.2018, 10:18
Forum: Firebird
Topic: Firebird and TGuidField
Replies: 3
Views: 43

Re: Firebird and TGuidField

Hello zbylo, it is possible - yes. But since CHAR(16) CHARACTER SET OCTETS also could be something else, it is unlikely to get implemented. One could implement a switch for specifically enabling a behaviour like this. If you want to try to implement this, I will help you as good as I can. With best ...
by marsupilami
08.01.2018, 11:00
Forum: ZeosLib 7.2 Betatest Forum
Topic: Problems in the field editor with fields of the same name in two different tables
Replies: 16
Views: 172

Re: Problems in the field editor with fields of the same name in two different tables

hello tkszeos,

which database (MySQL, Firebird, ...) do you use?

With best regards,

Jan
by marsupilami
27.12.2017, 23:07
Forum: ZeosLib 7.2 Betatest Forum
Topic: Interbase 5?
Replies: 7
Views: 138

Re: Interbase 5?

Hello Fr0sT, Ertan, me - a project commander? Hmmm - I hope to find a consensus between all active members who develop for Zeos ;o) Honestly the people who did releases in the past thought that there was more to it than just zipping up a copy of the current 7.2 branch. There are some scripts to run ...
by marsupilami
27.12.2017, 23:01
Forum: ZeosLib 7.2 Betatest Forum
Topic: WinCE compatibility
Replies: 3
Views: 34

Re: WinCE compatibility

Hello Ertan, Windows CE is more or less dead, I think. But that shouldn't stop you from developing if you need it or if you have fun doing it. I am willing to accept patches, if they don't break other targets :o) Regarding CharToOem and OemToChar: OEM only has a meaning on the regular Windows for PC...
by marsupilami
19.12.2017, 14:33
Forum: ZeosLib 7.2 Betatest Forum
Topic: PostgreSQL: Problems inserting timestamp into table
Replies: 4
Views: 70

Re: PostgreSQL: Problems inserting timestamp into table

Hello JD, could you please create a log using a TZSQLMonitor component to see what gets sent to the database? I think this could help finding the problem.
by marsupilami
14.12.2017, 12:28
Forum: ZeosLib 7.0 Stable Forum
Topic: Pb migration program with SQLite ANSI db from D2007 to XE4
Replies: 1
Views: 32

Re: Pb migration program with SQLite ANSI db from D2007 to XE4

Hello lfcap, which version of Zeos do you use for your Delphi 2007 and for your Delphi XE4? Are both versions on Zeos 7.0? The problem here is that usually no other data than Unicode characters should have been written to your database - this is an SQLite requirement, as far as I know. See "Sup...
by marsupilami
12.12.2017, 09:28
Forum: MySQL
Topic: range check error
Replies: 12
Views: 1236

Re: range check error

Could you please try the current Zeos 7.2 from SVN?
by marsupilami
11.12.2017, 14:51
Forum: MySQL
Topic: range check error
Replies: 12
Views: 1236

Re: range check error

Hello shiva4,

which verson of Zeos did you use?

With best regards,

Jan

Go to advanced search