Search found 140 matches

by trupka
20.05.2011, 08:12
Forum: ZeosLib 7.0 Beta Forum
Topic: [patch_done] Overwrite Records in Tables
Replies: 18
Views: 2561

Hi Mark, in original code InternalGotoBookmark(@BM) never happens because BM var is never used. In that sense, my patch solves row jumping problem but I didnt do any serious testing (and I'm not using filters in my apps so I can't be 100% sure, but, in other hand, can't be worse than without patch :...
by trupka
18.05.2011, 23:56
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Memory Leak at DriverManager.GetConnection
Replies: 11
Views: 3289

JavaPauloMG,
can you create some example so I can reproduce the problem?
I've been using Zeos with EL and FastMM for some time and never encountered
anything similar...
by trupka
18.05.2011, 23:42
Forum: MS SQL Server
Topic: Encodeing problem
Replies: 5
Views: 1777

ahmed232323 wrote:it didn't work also ,it's will be good if there is class and it's members documentations to find options to added to the TZConnection.Properties
There is - download stable version from http://sourceforge.net/projects/zeoslib/files/ and take look inside parameters.pdf
by trupka
14.05.2011, 18:03
Forum: SQLite
Topic: sqlite, zeos and delphi urgent help
Replies: 6
Views: 4216

If I understood problem, SQL might be:

Code: Select all

 select date, message from events where date between :start_date and :end_date
then you can do interations as shown before..

SQLLite date/time support is very limited and error prone, beware...

btw, I'm from HR.
by trupka
13.05.2011, 08:46
Forum: SQLite
Topic: sqlite, zeos and delphi urgent help
Replies: 6
Views: 4216

after you open query, you can manipulate with data directly whith standard dataset methods (next, first, prior, insert, update etc.. - see delphi help). Unfortunately, Delphi 2007 Help system sucks - go search for D7 old winhelp files, they are much beter and (still) useable with D2007. But if you n...
by trupka
12.05.2011, 16:47
Forum: SQLite
Topic: sqlite, zeos and delphi urgent help
Replies: 6
Views: 4216

vvv, I'm not sure where to start.. do you have any experience in SQL, Delphi and databases? I will gladly give you some hints and directions but don't want to write stuff you already now...
by trupka
12.05.2011, 00:37
Forum: ZeosLib 7.0 Beta Forum
Topic: [patch_done] Overwrite Records in Tables
Replies: 18
Views: 2561

Try this patch Index: src/component/ZAbstractDataset.pas =================================================================== --- src/component/ZAbstractDataset.pas (revision 891) +++ src/component/ZAbstractDataset.pas (working copy) @@ -475,6 +475,7 @@ FreeFieldBuffers; SetState(dsBrowse); Resync([]...
by trupka
11.05.2011, 17:29
Forum: ZeosLib 7.0 Beta Forum
Topic: [patch_done] Overwrite Records in Tables
Replies: 18
Views: 2561

rvgugisch,
Can you make and post some simple example to reproduce problem?
Pascal is language we both understand... :-)
by trupka
11.05.2011, 17:26
Forum: 6.6 - stable
Topic: Zeos license
Replies: 4
Views: 1645

You don't need to redistribute DCU-s, but you need to meet lincence terms of database client libs -e.g. mysql dll's are "tricky" here but that's another story... Zeos is licensed under LGPL 2.1 which states: A program that contains no derivative of any portion of the Library, but is design...
by trupka
11.05.2011, 12:37
Forum: ZeosLib 7.0 Beta Forum
Topic: [patch_done] Overwrite Records in Tables
Replies: 18
Views: 2561

Hi,

I'm sorry, it's very hard to understand from your post what issue do you have..
Can you rephrase question? Code sample maybe?
by trupka
11.05.2011, 12:31
Forum: 6.6 - stable
Topic: Zeos license
Replies: 4
Views: 1645

Hi, in short: Yes Longer: see license agreement in source, important part is: { As a special exception, the copyright holders of this } { library give you permission to link this library with } { independent modules to produce an executable, } { regardless of the license terms of these independent }...
by trupka
06.05.2011, 08:17
Forum: 6.6 - stable
Topic: problems with param for limit clause (in Zquery)
Replies: 10
Views: 1504

but! anyway! parser dont give any chance to activate Zquery if "LIMIT :param" inside SQL script. very strange Did you try to set additional properties for param in design time: Object inspector -> select ZQuery ->Open params collection Select param in param collection editor and in Object...
by trupka
05.05.2011, 19:48
Forum: 6.6 - stable
Topic: problems with param for limit clause (in Zquery)
Replies: 10
Views: 1504

Interesting... I don't think Delphi 7 makes the difference... Currently I don't have it but lets try something else (see attach). You should see generated sql and then you can test it inside mysql console and see is it realy (not) working. If you wish, you can post generated SQL so I can test it ins...
by trupka
05.05.2011, 14:53
Forum: 6.6 - stable
Topic: problems with param for limit clause (in Zquery)
Replies: 10
Views: 1504

railgun3r,
This works fine for me:
- Mysql 5.0
- Delphi 2007
- zeos 6.6.6-stable
Code sample attached in post, maybe this will help you.
by trupka
19.04.2011, 16:12
Forum: ZeosLib 7.0 Beta Forum
Topic: delphi 64 bit and ZEOS 7
Replies: 3
Views: 1123

Probably yes because FPC64 version is on the way.... but we need working delphi compiler first. I don't believe this will happen soon, no matter what Bor/Cod/Emb guys says..