Zeoslib Portal

papelhigienico , Some time ago I tried this technique with storing data inside app and recreate table when necessary but this didn't work well for me: - it's complicated to maintain code for multiple databases. - if end users can change database structure you have 1001 problem e.g: It's enough to c...

Ðerek wildstar,
I tried to reproduce your problem with D2007/2010 with Zeos 7 Alpha but no success.
Can you provide some code sample?

I have had similar problem with application upgrades because db schema changes often as well. My solution is based on concept of packages (like linux rpm/dpk) and works well most of the time.
Do you have complete control over database or someone else can change structure independently?

IMO, there's no simple way to store data to a stream. This task will probably need some component coding. Loading from stream into component is another story (nearly impossible). I still can't imagine why would you need this? If you want to store data locally for fast lookup and offline work, take a...

I probably misunderstood something, but must ask - why do you want to store Properties into memstream? It's just a simple string (Zquery1.Properties.Text == string).
Maybe you want to store entire component or Zquery/ZTable data?

Zconnection codepage param is client codepage so you will need something like: ZConnection.Params.Add('codepage=win1252') or, more generic: var CPCode: cardinal sCP: string; begin cpcode := GetACP(); case cpcode of 1250,1251,1252,1256,1258: sCP := 'WIN' + IntToStr(CPCode); some_other ACP: sCP := 'so...

Zeos SVN repo works perfectly fine while I'm writing this. It's probably network issue. It's impossible to resolve this through forum, I can give you only a few general tips: - you cant ping zeos.firmos.at. That's OK. - try to capture some network traffic and see is network connection established at...

You're doing OK and I just tested checkout from trunk.It also works OK so problem is somwhere else. Doesn Tortoise reports some error or just hangs? Firewall / provider issues maybe?

Unfortunately no. Child columns are not supported.

Postgres has, among the other, composite types. I'm working with both and, must say, PG have much more features. Take a look into excelent pg documentation. Pg doesn't have embedded server and never will. Full instalation is quite small for todays machines so it is not handycap. If you really need s...

Hi,

I did some tests and came to similar conclusion - leak happens deeper in code, in Firebird dbc layer. Strictly speaking, it's not a bug in Zeos - low level programming needs more attention.

I wasn't aware of this - since mid. of May all dreamcoder products (mysql, postgres and oracle managers) are free. Get it from: http://www.sqldeveloper.net/
Download, enjoy and donate..

mparak , compression mostly doesn't hurt but there are other factors that influence network bandwith. Network latency is one of them. If your network communcation consists of mostly smaller packets (mysql protocol is close to that definition) , this can be serious issue (time between two data packe...

This useful functions were added in 8.0.

you can't (and don't need to) freeAndNil interfaced object because they are reference counted and automaticaly freed when not needed. IMO, it is sufficient to: destructor TEntityManagerFirebird.destroy; begin fConnection.CLose; fConnection := nil; inherited; end; I tried to generate memory leaks (se...