Zeoslib Portal

Download the source via SVN. (via zeos.firmos.at) and start testing

A special registration is not necessary.

A few hours debugging down the line, I'm not so sure this is a bug . Rather an unexpected sideeffect of changing encoding on the connection I noticed that the dbmemo field is ansistring based, also in D2009. One needs a dbwidememo for unicode. So I deleted the tdbmemo, and reimported the field from ...

marcov , Using trunk isn't that bad idea. Certainly not for experienced fpc + SVN users as you are. However, it's not sure your issue will be fixed there. I've set up a way to easily test with trunk (on a different machine). The trouble is that I don't know my way in the DB parts of the VCL, so I c...

I noticed that Zeos stil uses versions (150below) etc to steer condiitional code. This can be a bit clumsy specially with two different version hierarchies (FPC's and Delphi's). It can be easier to move to a capability based system as described in this document: http://www.stack.nl/~marcov/porting.p...

mdaems wrote:marcov,
I did have a look, but the existing comments were already in the code before I even had a look at the zeoslib project. How easy would a migration to fpdoc format be?

I'll ask the fpdoc original author, and have a deeper look at the sources.

marcov , Attached you'll find the 'minimal' part of OleDB that should be available when compiling zeoslib with ado support in Lazarus (doing this on windows). Attention : this file is coming from another thread in this forum (http://zeos.firmos.at/viewtopic.php?t=2702) and is in my opinion not lega...

I did this too, but then get exceptions on startup that the tdbmemo fields should then be of type "ftwidememo". If I change that, the memos are not correctly fills (it looks like opening UTF-16 text with a ascii only editor, iow like T H I S I S T E X T ) Does sb recognize this? Is it corr...

I think you also need mysql-dev or something similar. It provides the symlink for development.

If that doesn't solve it, it would be helpful to see what .so files exist in /usr/lib/mysql

Another thing you could try is set LD_LIBRARY_PATH to that dir.

Try to put them in the path, specially for the IDE this could matter, because the working dir of the IDE is not very well defined under Delphi. Under Lazarus it is compiletime and runtime defined to be the place where the .exe ends up, and afaik undefined otherwise. I took the dlls from pgadmin3 ins...

Wild Pointer: thanks that was the kind info I was looking for.

IOW make sure the transaction regime is sane, and it will be ok.

Yes, I found that, and understand that could be a manual way?

But how to use that returned "id" in the next statement in a TZUpdatesql insertsql. block ?

If not I assume the logical solution would be to make a stored procedure for this?

Note that 2.2.2 is nearly 2 years old (in august). If you suspect a problem in FPC, better test with a recent version first, before spending too much time on it.

(postgres 8, zeos 7,D2009) I've a m x n relation between table A and B, and for this I use a table AB that contains references to both. Now, for a certain tuple in A, I need to add a relation to B, so I need to insert an item into B and AB. So I do insert into B (datafield1,datafield2) values (value...

Mdaems: does Zeos only need ADO headers translated (and if so, which ones?), or do the relevant Delphi units also contain e.g. tdataset implementations for ADO? I can do the first (but due the size it will take a while), but I don't know much about db components, so can't try to build something equi...

Silvio, the examples are very nice

Unfortunately, I tested the old version (so could run them, just had to study them).

I'll try to test them with a postgres setup the coming days.