Zeoslib Portal

how to get the key field of a table query or the constrain keys ?

Im using postgres and a zquery select * from items and using fetchrow = 10 but it still loads all query rows on the open. I only want 10 rows on start up and the rest as it is needed ...


How i fetch only 10 by 10 rows ?

Any effective answer ?

Is it working ,

Im using Pg 9 and i cant do it work i do events='removed';active = true after connection up and on postgres trigger ondelete procedure i do notify removed;


Its not working. can someone check this. I use Pg9 x64 and x32 libs.

Thanks,

I think this is becuase zeos alwasy have a transaction started so it cant receive pgevents....
Im i correct or is missing some thing ?

Any on please , does this component works at all???

I have a masterTable and a detail table on postgresql, i need to inset mastertable line and the the details lines. How can i do this two tables if on fail rollback ? cached updates is for own table how can i do both be on same commit ? This to avoid convert tables to sql text because then work ... a...

How works TZPgEventAlerter because i cant do it work ?
Can you help me with a simple example.

How can i get the primary key fields with Zeos ,

Can it be done a a zquery or zTable ?

Didnt find it , on paradox it works with fieldsdefs.

Yes is odd to me too but i spoke with firebird team and they said is like that.


so i solved the problem so im developing yet so i deleted all data from table and inserted again. Prob solved.

Can i develop a TzDatasource to trigger error events to TzDatasource. When we have a Tdatamodule used for all software we cant set error messages for specific purposes we dont know in which form we where and the "DbControls used to exec error". So can i develop a TzDatasource and you set t...

This only fails if we alter a table add a new column with null if we create new rows with null i works fine but it is a firebird way to work, so after we alter and set the new column to null we must change the value and then set it to null again.

ENDDATE is date and was created after the table being created and it allows nulls so it filled the colum with nulls automatic. So i want to set ENDDATE then i do : UPDATE MYTABLE SET ENDDATE=CURRENT_DATE WHERE MYID=1 Error -605 ???? ****value null**** This wasnt supposed to happen ? It should Set Ro...

Can you Create a variable on ZAbstractRODataset type EZDatabaseErrorClass = class of EZDatabaseError; var defaultEZDatabaseErrorClass:EZDatabaseErrorClass=EZDatabaseError; on the exceptions defaultEZDatabaseError.Create instead of EZDatabaseError.Create. So if we change the defaultEZDatabaseError va...

Can you replace the resourcestring with {DEFINE ENGLISH} {IFFDEF ENGLISH} {$I EnglishResource} var cMyErrorMessage1= rResourceErrorMessage1; var cMyErrorMessage2= rResourceErrorMessage2; var cMyErrorMessage3= rResourceErrorMessage3; var cMyErrorMessage4= rResourceErrorMessage4; var cMyErrorMessage5=...

Inserting a record on a table the events Before Post,Before Insert ,On error arent executed if we have required fields as null on a table , this should be triggered before even the dataset do check the required fields and raise the exception. Im trying to show my own error boxes, so i tried it on th...