Search found 37 matches

by Stevie
11.01.2018, 12:40
Forum: Firebird
Topic: Support for CHAR(16) CHARACTER SET OCTETS
Replies: 15
Views: 205

Re: Support for CHAR(16) CHARACTER SET OCTETS

FWIW it needs to be considered that Firebird stores uuids big endian so that the typical conversion to TGUID like using PGuid over the byte array and alike will not work and cause similar issue to this one (probably my own workaround I mentioned in my first post suffers from that issue as well): htt...
by Stevie
11.01.2018, 10:30
Forum: Firebird
Topic: Support for CHAR(16) CHARACTER SET OCTETS
Replies: 15
Views: 205

Re: Support for CHAR(16) CHARACTER SET OCTETS

Why not both? Specify type mapping rules on the connection and on the individual datasets (that's how DevArt does it - see https://blog.devart.com/data-type-mappi ... nents.html)
by Stevie
08.01.2018, 14:46
Forum: Firebird
Topic: Support for CHAR(16) CHARACTER SET OCTETS
Replies: 15
Views: 205

Support for CHAR(16) CHARACTER SET OCTETS

Zeos should treat CHAR(16) CHARACTER SET OCTETS as ftGuid and not ftBytes similar to FireDAC (see http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Firebird_and_Interbase_Servers_Questions_(FireDAC)) I tested a bit and I think this should be implemented somewhere in ZDbcInterbase6Utils.TZSQLDA.GetFi...
by Stevie
22.02.2017, 15:21
Forum: 6.6 - stable
Topic: TZquery dont works with Multiple Statements
Replies: 17
Views: 1911

Re: TZquery dont works with Multiple Statements

Awesome, thanks ;)
by Stevie
15.02.2017, 11:02
Forum: 6.6 - stable
Topic: TZquery dont works with Multiple Statements
Replies: 17
Views: 1911

Re: TZquery dont works with Multiple Statements

Yes, the change to GetMoreResults is not needed - I updated the diff in my previous comment accordingly
by Stevie
14.02.2017, 20:00
Forum: 6.6 - stable
Topic: TZquery dont works with Multiple Statements
Replies: 17
Views: 1911

Re: TZquery dont works with Multiple Statements

I think you are absolutely right. My first version of the change did take the last resultset and it was always closed because of the following call to GetMoreResults which returned False. Later I decided to take the first and leave the loop. So it could be the change in GetMoreResults is not needed ...
by Stevie
12.02.2017, 14:00
Forum: 6.6 - stable
Topic: TZquery dont works with Multiple Statements
Replies: 17
Views: 1911

Re: TZquery dont works with Multiple Statements

Sure that would be better - however until now even if you did multiple select statements it returned the results from the first. It only raised an exception if the first statement did not return a result set but discarded the following anyway. So I just fixed that by making it possible to return the...
by Stevie
09.02.2017, 16:09
Forum: 6.6 - stable
Topic: TZquery dont works with Multiple Statements
Replies: 17
Views: 1911

Re: TZquery dont works with Multiple Statements

I think this is actually a bug in ZEOS as it cannot handle what the DBMS supports. See https://dev.mysql.com/doc/refman/5.7/en/c-api-multiple-queries.html Here is a patch to enable this functionality (based on 7.1.4-stable) --- ZDbcMySqlStatement.pas +++ ZDbcMySqlStatement.pas @@ -324,8 +324,21 @@ b...
by Stevie
16.02.2010, 13:05
Forum: 6.6 - stable
Topic: can't find libmysql41.dll libmysql.dll problem?
Replies: 2
Views: 597

If you are working on Windows 7 64 bit make sure the libmysql.dll is in the windows\syswow64 folder.
You can also copy the file to the Delphi\bin folder.
by Stevie
23.09.2005, 14:48
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: CVS Downloads
Replies: 9
Views: 2523

Thx Michael, That's what we were all waiting for. Unfortunately it does not solve my problem with the StrUtils unit that is not known by Delphi5. Why are the used functions not necessary for the other ZDbc*****ResultSet units? Hi, I have just fixed this bug. The method leftstr is replaced with copy...
by Stevie
09.09.2005, 15:25
Forum: Announcements
Topic: New component: TZSequence
Replies: 3
Views: 5498

Dear users,

now the components TZQuery and TZTable have both support for TZSequence implemented.
Just link a TZSequence-Object to one of them and set SequenceField property to fill this field with TZSequence.GetNextValue if it IsNull when posting.

Regards
Stevie
by Stevie
09.09.2005, 13:21
Forum: 6.1.5
Topic: No Authentication to MySQL 5
Replies: 5
Views: 2001

Hi,

please refer to the MySQL Reference Manual for further information.

Regards
Stevie
by Stevie
08.09.2005, 15:16
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: problem with ZQuery
Replies: 5
Views: 3133

Yes, we decided to change this property from RequestLive to ReadOnly. I recommend to use the Tool BKReplaceEm to search and replace any reference in your code (*.pas and *.dfm). Please consider that RequestLive = True is now ReadOnly = False and RequestLive = False is now ReadOnly = True! Please ref...
by Stevie
07.09.2005, 15:10
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ZeosDBO in Lazarus
Replies: 23
Views: 8427

:oops: Why does Lazarus not want to call an abstract method? ...
Ok, I fixed it already... :wink:
by Stevie
06.09.2005, 15:34
Forum: Announcements
Topic: On which database are you using Zeos?
Replies: 8
Views: 6909

On which database are you using Zeos?

Dear users,

the Zeos-Team is very interested to know on which databases you work with zeos. Please let us know. If you use multiple databases, please choose your favorite.

Regards

Go to advanced search