Zeoslib Portal

Why does zeos load the stream on the fly ?? I used fb to create a file structure with directories and so on. But when it haves a large blob it takes a lot to change "dir" when i zquery that folder .... DOES ZEOS load blob when select * from FILELIST where my folder = 'ICONS'; when filelist...

I have use Sweep from IBO doesnt this a firebird internal function ????

I triend to save a blob stream from loadfromfile() of 500 MB.

I just Outof memory! Why ??? Can you solve this.

Why using Blob stream takes a Lot to load a file of ex 60 MB ... ???? can it be faster ????

Is possible to remove Firebird deleted records from database????

i inserted records on a db till 130 MB

I deleted 100 mB .
I used Sweep from IBO but file still haves 130 MB.

How can i remove it from File ?????

And How can i change transact isolation to READ COMMIT on ZeosLib ????

Can anyone explain why zquery have zSequence. If i have a multiple / user using db i cant do zsequnec.last id because it couldnot be that the last posted, and i cant use the Query 'insert etc ect returning id' because is visual control not supposed a mix. How can i have the last id on a open table o...

I Found the Solution is Isolation Level must be READ COMMITED...

How Can i change From SNAPSHOT To READ COMMITED ???????

I have a Db on fb running and my program. If a open IBO change a value of a table post and commit it saves on db viewing by IBO or if i open a new program the new value is there. But on the first program if a zquery (select aname * from nametable) it returns the old value and not the new one. If i c...

When a do a new post on "firebird forum" and click on View more Emoticons it appers a window sayingin that "trying to hack!!!" instead of smiles (because my browser blocks it ). So i seeams ya smilie is trying to do something not good. Pls check this out. PS: im using Chromium un...

Is the zConnection.protocol Correct "firebird-2.0" rename the gds32.dll to fbclient.dll if you use embedded use "firebirdd-2.0" insted.

Should solve.

Ok thanks,
but zeos lib works fine with it(composite types), like in the dbgrid as a tcolumn child columns????

????

I use firebird but postgre have much more datatypes so i thinking to change to postgre.

I need to know if post gre suports Composite Types and if it have a embeeded server like firebird.


Thanks.

Ok, forgot the result is boolean.. thinking on other stuff of the project. But i tried several ways and it didnt work.. and with zquery at first worked so .. supposed the before post. .. . Ill try it later cause i have to finish a project for lastweek... so with zquery is workin .. it stays by now w...

Lol ,Ok .. didnt catch that... so .. I need to check further, but i dont think it will be easy then.

Ill try to understand a bit of the parser to try to help on this issue.
Then if i found a way i ll post it back.

Thanks mdaems.

Ok , No bug,we can only use Boolean and Integer with "and" operator. so we can do a basic filter like = <> > < but not or "and" "or" "xor" ... etc. So is correct and documented then no problems with it. Whould be better we can filter double,Floats with it but ...

I suppose it have a bug on date ill use then the zquery query. and later try to check if i found the prob on the code.


Thanks darkbow