Search found 577 matches

by marsupilami
18.11.2017, 11:31
Forum: SQLite
Topic: SELECT UNION truncate string fields at 510 character
Replies: 1
Views: 11

Re: SELECT UNION truncate string fields at 510 character

Hello OsquiVilla, duh - hmm - the best answer would be to use another database - Firebird for example ;) SQLite is a bit of a hard case since from a Zeos / Delphi point of view it doesn't have Varchar fields at all, only Memo fields... That said - Zeos tries to emulate Varchar fields by truncating S...
by marsupilami
18.11.2017, 11:26
Forum: ZeosLib 7.2 Betatest Forum
Topic: How to identify primary key field(s)
Replies: 4
Views: 38

Re: How to identify primary key field(s)

Hello Ertan,

(Uncached)GetPrimaryKeys is part of the DBC layer. It might be more easy to use the TZMetadata component. It works like a query. Set the metadata you want to retrive to primary key. Set the table name to your desired table name. Call the open method.

With best regards,

Jan
by marsupilami
09.11.2017, 16:24
Forum: ZeosLib 7.2 Betatest Forum
Topic: PostgreSQL - cannot insert multiple commands into a prepared statement
Replies: 9
Views: 130

Re: PostgreSQL - cannot insert multiple commands into a prepared statement

Hello Fr0st, having \ as an escape character can be right and can be wrong. It depends on the setting of "standard_conforming_strings" in the server. And wether the string constant is preceeded by an E. For more details on the PostgreSQL string madness ... erm... syntax see here, section4....
by marsupilami
08.11.2017, 21:56
Forum: ZeosLib 7.2 Betatest Forum
Topic: PostgreSQL - cannot insert multiple commands into a prepared statement
Replies: 9
Views: 130

Re: PostgreSQL - cannot insert multiple commands into a prepared statement

ertank wrote:Hello Jan,

It is nice to know its a parser bug. Do you think it will be possible to handle it?

Thanks.
Ertan

Hello Ertan,

I am quite sure, it can be handeled. But I cannot even guess how much time it will take :(

With best regards,

Jan
by marsupilami
03.11.2017, 17:17
Forum: ZeosLib 7.2 Betatest Forum
Topic: PostgreSQL - cannot insert multiple commands into a prepared statement
Replies: 9
Views: 130

Re: PostgreSQL - cannot insert multiple commands into a prepared statement

Hello Ertan,

I can confirm this bug. It is a problem in the parser. If you remove the line that tries to insert '\', the script works.

With best regards, Jan
by marsupilami
03.11.2017, 08:28
Forum: ZeosLib 7.2 Betatest Forum
Topic: PostgreSQL - cannot insert multiple commands into a prepared statement
Replies: 9
Views: 130

Re: PostgreSQL - cannot insert multiple commands into a prepared statement

Hello Ertan, what is the exact error message you get? Do you use parameters in your SQL script? Currently the TZSQLProcessor uses prepared statements and it is not that easy to disable the use of prepared statements for it. Also I seem to remember that I tested the problem of fhaut in the thread tha...
by marsupilami
24.10.2017, 09:44
Forum: ZeosLib 7.2 Betatest Forum
Topic: libmysql.dll - to many subsequent errors
Replies: 4
Views: 58

Re: libmysql.dll - to many subsequent errors

Hello vejrous, I don't know about any problems when Zeos is used in a DLL. The SVN path for Zeos 7.2 is http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-7.2 . For Zeos 7.3 it is http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-7.3 With best regards, Jan
by marsupilami
19.10.2017, 16:16
Forum: 6.6 - stable
Topic: Index process in Firebird2.1
Replies: 1
Views: 30

Re: Index process in Firebird2.1

Hello elechos, Zeos 6.6 is not supported anymore. Please use Zeos 7.1 or even better Zeos 7.2 from SVN. Both have several improvements for Firebird and are compatible with Delphi 7. Regarding your question about Indices: Zeos deosn't decide about which Indices get used by the optimizer. Please ask t...
by marsupilami
18.10.2017, 09:17
Forum: ZeosLib 7.2 Betatest Forum
Topic: Zeoslib 7.2.1-rc. Internal error C1118 on Delphi 7
Replies: 3
Views: 84

Re: Zeoslib 7.2.1-rc. Internal error C1118 on Delphi 7

Hello tkszeos, honestly - the easiest way to solve this problem could be using a newer Delphi version. Delphi Internal errors are usually bugs in the compiler. You could also try the current SVN version of Zeos 7.2. and see if this resolves your problem. Or maybe the Lazarus project is an option for...
by marsupilami
04.10.2017, 14:40
Forum: ZeosLib 7.2 Betatest Forum
Topic: [Suggestion] group and declare as constants all supported values of Parameters
Replies: 12
Views: 185

Re: [Suggestion] group and declare as constants all supported values of Parameters

Hello Jan, This is good news. Honestly I am surprised about having properties in ZCore. This is where things get messy. In my opinion it makes sense again to have them in separate units again. Something like a ZParams.pas in core and a ZDbcParams in the dbc subdirectory. If we want to keep to one s...
by marsupilami
04.10.2017, 14:21
Forum: ZeosLib 7.2 Betatest Forum
Topic: How can I check if connection is active?
Replies: 1
Views: 51

Re: How can I check if connection is active?

Hello Soner, hmmm - currently the Firebird driver doesn't support pinging the server. But usually you should get an exception telling you that this operation is not supported... But: Changing the password of a user should not kill other connections. Maybe it is a good idea to use Zeos for changing t...
by marsupilami
04.10.2017, 14:08
Forum: ZeosLib 7.2 Betatest Forum
Topic: ZEOS 7.2 and Firebird 3 Boolean fields
Replies: 2
Views: 310

Re: ZEOS 7.2 and Firebird 3 Boolean fields

Just for the record: This got fixerd in Rev. 3943.
by marsupilami
27.09.2017, 14:27
Forum: ZeosLib 7.2 Betatest Forum
Topic: [Suggestion] group and declare as constants all supported values of Parameters
Replies: 12
Views: 185

Re: [Suggestion] group and declare as constants all supported values of Parameters

Hello Fr0st, Hello Jan, I made the main part, it wasn't hard but only messy sometimes. As some of the parameters are used in ZUrl and ZCompatibility units, I had to place the unit inside core\ folder to keep the hierarchy of uses. Let me know if dbс\ is preferred. Currently there are 43 connection a...
by marsupilami
21.09.2017, 09:38
Forum: ZeosLib 7.2 Betatest Forum
Topic: [Suggestion] group and declare as constants all supported values of Parameters
Replies: 12
Views: 185

Re: [Suggestion] group and declare as constants all supported values of Parameters

Addendum: I put you into the developer group on Sourceforge. That should give you access to the SVN. You need to check out using https, otherwise you will not be allowed to chek in your changes using your sourceforge username and password. I also reconfigured the Wiki to allow everybody to modify an...
by marsupilami
21.09.2017, 09:02
Forum: ZeosLib 7.2 Betatest Forum
Topic: [Suggestion] group and declare as constants all supported values of Parameters
Replies: 12
Views: 185

Re: [Suggestion] group and declare as constants all supported values of Parameters

Hello Jan, I guess the suggestions/patches are better than just requests anyway ;) Yes - they are. I am happy about that situation. Applying patches instead of hunting down things myself is much better :D Yep, talk with the guy of course. Soo - I talked to him. In the end he suggests this: have one...

Go to advanced search