Zeoslib Portal

Hi,i was looking for the dataset , datalink datasource and i found it is a primitive way to acess data because it have only 1 data window by currentrecord till buffercount records < or > of currentrecord. So for special components with multiple "record acess" it is needed to acess data in ...

how can i acess a record any where without moving the cursor. for example : cursor pos = 7 and i want to acess pos 6000000 without move the curso or use disable controls. ex : im on pos 7 currently and buffercount = 100; for aa:= 600000 to 6000010 do begin datalink.activerecord := aa; getrecorddata(...

Is it possible to create a field (like datasetfield ) under firebird that is a table. Im doing this but by other way in bde using a blob and each row have a different table. Does firebird have this function integraded or do i need to use the blob field again???? Anyone have an idea for this without ...

Using : ztable, zquery , datasource, i whould like to add a dataset field to be able to useit in the dbgrid ( the button on the cell click and appear a new window with that table datasetfield table) With clientdataset and the other comnpos is possible to do this --- with zeos and firebird is possibl...

I need to create a dataset field in to fire bird do u know any way to do this.
URGENT

Indeed my last post of this issue is working perfectly till now.


I hope this help somebody .. it helped me a lot. of

Thanks for your answer. The problem is i have a ztable and a dbgrid. and i wanna do ztable.open. and the db grid title dont be the field name and "i dont wanna do it manualy on dbgrid". I want to save it on db with the field. Like create table ( myfield integer "mydecription",......

Finally i think i solved the problem with zsqlprocessor Set zSqlProcessorDelimiterType := dtGo. and In all statment did go: ex : go Create soemething go create other thing Dont use set term (big problems ).... but with go solves this issue .. :thanks: seawolf for ya support in all issues.

This worlked on flame robin fine .....

But not on zsqlprocessor.

set term ^ ;
create trigger TRI_GRUPOS_ID1 for grupos
active before insert
as
begin
if ((new.gr_id is null) or (new.gr_id=0)) then
begin
new.gr_id = gen_id(GEN_GRUPOSID,1 );
end
end
^
set term ;^

grupostable exists , GR_ID is integer no null, of grupos table exits, GEN_GRUPOSID is agenerator and exists to.... I did this on flamerobbin o run query : create trigger TRI_GRUPOS FOR grupos active before insert as begin if ((new.gr_id is null) or (new.gr_id = 0)) then begin new.gr_id = gen_id( GEN...

Error in Sql Statment ... I do this on a empty database after create tables and generators ; " CREATE TRIGGER TRI_GRUPOS FOR GRUPOS ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF ((NEW.GR_ID IS NULL) OR (NEW.GR_ID = 0)) THEN BEGIN NEW.GR_ID =GEN_ID(GEN_GRUPOSID ,1); " On the 1st post is exacl...

Why cant i exec this on zsqlprocessor or zquery But i dont want to add sql.clear ; sql.sql := text; parcial want to exec all on same string ??? any goodc :idea: :thx: Better yet how can i exec create table create procedure and every thing on same tstring ????? It it possible. Execdirect solve the pr...

Can i simplify generator and trigger management? Can i do something to improve the bottom(eof) code like (similar) the next code :?: Any ideas =???? CREATE TRIGGER MYDynamicTrigger(mygenvar,mytablevar,myidvar)FOR mytablevar ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (NEW.myidvar IS NULL) THEN BEGI...

How can i create field description , or title for each field on firebird. And how can i get it ... i suppose it is with metadata but dont undestand meta data yet What i want to do is : When i assign to a dbgrid a dataset want to set a readable name on title and not the fieldname... In case off &quo...

If i do :

Zquery Select * Form table ROWS 0 TO 100
ERROR : .... blabla have to be >= 0 ...

But is = 0 so ...

if i do ROWS 1 to 100 it works fine ...

( I need only the Field header Title) SO i NEED only ROWS 0 to 0


Does any one know how to get Title only without any lines.