Search found 34 matches

by Stevie
22.02.2017, 15:21
Forum: 6.6 - stable
Topic: TZquery dont works with Multiple Statements
Replies: 17
Views: 1354

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: 1354

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: 1354

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: 1354

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: 1354

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: 509

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: 2413

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: 5376

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: 1881

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: 2971

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: 8127

: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: 6755

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
by Stevie
06.09.2005, 12:31
Forum: Announcements
Topic: New component: TZSequence
Replies: 3
Views: 5376

New component: TZSequence

Dear users, today I have finished the work on our new TZSequence-Component! With this component you have direct access to sequences/generators on your database. You can get the current or next value to initialize key-fields for example. Currently only Interbase/Firebird is supported but others will ...
by Stevie
06.09.2005, 12:21
Forum: User Patches
Topic: Database Rebuild for Firebird 1.5
Replies: 11
Views: 4610

Re: Cursor?

If not then it can't work in ZEOS. How would you access the different values of x otherwise? If you can then your example is something like a select statement. That is possible in Sybase too, but there this has to be the content of a procedure and you have to call/select it to get the result(s). No...
by Stevie
06.09.2005, 07:33
Forum: User Patches
Topic: Database Rebuild for Firebird 1.5
Replies: 11
Views: 4610

I do not know exactly what purpose "begin" and "end" fulfill in this example. It could be executed without them but it could also be (PL/SQL): declare y number; begin for y in 1..10 loop select count(*) into :x from dual; end loop; end; There are a lot of amazing things you can do with scrip...

Go to advanced search