Search found 1700 matches

by EgonHugeist
23.02.2016, 06:15
Forum: ZeosLib 7.2 Betatest Forum
Topic: Firebird - using merge statement in ZUpdateSQL.ModifySQL
Replies: 4
Views: 568

Re: Firebird - using merge statement in ZUpdateSQL.ModifySQL

Hi Zoran, might be true you'll fail using the TZUpdateSQL component. But you can use the TZQuery in this case. Note that's not a FB issue only. For Postgre/MySQL i emulate such scenarios (because of a different arichtecture in DBC). All (except SQLite) to me known RDBM's do run into same issue. I've...
by EgonHugeist
23.02.2016, 06:06
Forum: ZeosLib 7.2 Betatest Forum
Topic: doCachedLobs = True, but List index out of bounds (3)
Replies: 19
Views: 858

Re: doCachedLobs = True, but List index out of bounds (3)

Hi louis,

thanks for pointing this issue out. Patch done R3878 \testing-7.2 (SVN)

note if you set this option zeos always loads the lobs for FB/PostgreSQL+OID-Lobs. If you do not use this option, Zeos just loads the lobs on demand.

Regards, Michael
by EgonHugeist
17.02.2016, 07:09
Forum: ZeosLib 7.2 Betatest Forum
Topic: Firebird - using merge statement in ZUpdateSQL.ModifySQL
Replies: 4
Views: 568

Re: Firebird - using merge statement in ZUpdateSQL.ModifySQL

Hi Zoran, there is no issue using a "merge" statement. Your problem is the subselect: (select :old_id as id, :field2 as f2 from rdb$database) y FireBird isn't able to prepare the statement because there is no type determination possible for "old_id" and "field2" which y...
by EgonHugeist
09.02.2016, 05:48
Forum: OleDB (Microsoft Windows)
Topic: OleDB Alpha testers thread!
Replies: 5
Views: 2115

Re: OleDB Alpha testers thread!

Hi,

inbetween the issue should have been resolved. As i wrote Ole doesn't return the lob-attribute for the column, just a imbelievable huge col-size.
However i can use the VARxxxx(MAX) fields now. Same on ODBC
by EgonHugeist
09.02.2016, 05:45
Forum: Firebird
Topic: ZEOS 7 and Firebird 3.0
Replies: 4
Views: 1232

Re: ZEOS 7 and Firebird 3.0

Hi,

i think so. I made loads of FB3.0 test with FB3-alpha and did introduce the new Boolean type and some more FB3.0 features (e.g. better/bigger batch-bingings sinze the records of FB3.0 aren't limited to 64KB any more, sadly the SQL-String still is limited to 32KB)

Have fun
by EgonHugeist
09.02.2016, 05:36
Forum: ZeosLib 7.2 Betatest Forum
Topic: error parse -- comment
Replies: 4
Views: 319

Re: error parse -- comment

Hi Alex,

i got the nasty bugga. Can you test and confirm it?

Patch done R3826 \testing-7.2 (SVN)
by EgonHugeist
08.02.2016, 18:02
Forum: ZeosLib 7.2 Betatest Forum
Topic: why sometimes does 'last insert id' return 0
Replies: 7
Views: 601

Re: why sometimes does 'last insert id' return 0

I DON'T KNOW what you're doing, dude.
This way nobody can help you. Note Last_Inserted_id depends to last update smt. Are you using a pure sequential code or do you play with threads oslt

Did you read my last post? Why did you drop your last post?
by EgonHugeist
08.02.2016, 17:58
Forum: ZeosLib 7.1 stable Forum
Topic: Firebird Superserver with Zeos extremly slow
Replies: 5
Views: 632

Re: Firebird Superserver with Zeos extremly slow

@haegar,

some notes ... since 7.2 i made the Lob-loading just on demand with FB and Postgre-OID lobs. So if the lob column is selected .. loading just happens first on accessing the field..

Have fun sir
by EgonHugeist
08.02.2016, 17:56
Forum: ZeosLib 7.1 stable Forum
Topic: TZConnection, MSSQL, Windows Authentication, TDS
Replies: 28
Views: 2095

Re: TZConnection, MSSQL, Windows Authentication, TDS

Hands up Jan, aweful! If i've time i'll finalize the remaing implementation for optional use of LibIconv etc.
by EgonHugeist
08.02.2016, 17:54
Forum: ZeosLib 7.2 Betatest Forum
Topic: D2010 + Firebird + Varchar doubles FieldSize?
Replies: 17
Views: 1107

Re: D2010 + Firebird + Varchar doubles FieldSize?

@Louis.

doAlignMaxRequiredWideStringFieldSize should only be included to your options if you want to have a full width as i wrote before.
I've been testing the doubled size and this should be resolved. Do you use persistent Fields? Than i can't handle your trouble..
by EgonHugeist
08.02.2016, 17:49
Forum: ZeosLib 7.2 Betatest Forum
Topic: error parse -- comment
Replies: 4
Views: 319

Re: error parse -- comment

I'll check out what's going on..
by EgonHugeist
08.02.2016, 17:48
Forum: ZeosLib 7.2 Betatest Forum
Topic: why sometimes does 'last insert id' return 0
Replies: 7
Views: 601

Re: why sometimes does 'last insert id' return 0

Don't know why your making it so complicated. If you're using the TZQuery for the fetches and you insert a row ... zeos automalicaly returns the last inserted id into the field. Is there a spezial reason whay you want to do everthing manually? In addition stop working with pascal quoted strings, thi...
by EgonHugeist
25.01.2016, 21:59
Forum: ZeosLib 7.1 stable Forum
Topic: SQLite and Encryption
Replies: 1
Views: 278

Re: SQLite and Encryption

did you assign the encryption cipher?
by EgonHugeist
25.01.2016, 21:57
Forum: ZeosLib 7.1 stable Forum
Topic: TZConnection, MSSQL, Windows Authentication, TDS
Replies: 28
Views: 2095

Re: TZConnection, MSSQL, Windows Authentication, TDS

Nope it isn't, there is a opened ticked on FreeTDS.org or our compilated lib's are wrong.

I've been excluding this approch. Trying this raises a bad AV in the lib...

Sorry have to pass. With the ntwdblib.dll it works like a charm.
by EgonHugeist
24.01.2016, 09:01
Forum: ZeosLib 7.2 Betatest Forum
Topic: why sometimes does 'last insert id' return 0
Replies: 7
Views: 601

Re: why sometimes does 'last insert id' return 0

:?: :?:

Which compiler, database and which protocol? An example to support you would be nice!
My crystal balls don't tell anything here..

Go to advanced search