Recent content by ziller

But it worked with the tquery component and it does not with toracledataset.

hello, i use a toracledataset with this sql : select d.cod_doc,d.lib_doc,de.cod_elp,de.cod_anu from ctu2_doc_elp de, ctu2_document d where de.cod_anu = :cod_anu and d.cod_doc = de.cod_doc and then i use this component like this : if not qry_DOC_ELP_SEL.Active then with...

that's it

Hello, i'm using DOA 4 and having the following problem : i have a dbgrid connected to a toracledatastet in the onbeforeinsert event of my dataset i make a savepoint i have a cancel button that make a rollback when i add a record to my dbgrid, post-it and then click on the cancel button the...

i will make a wrapper around toraclesession that maintains a first-in-first-out list of the currents savepoints...

hello, when i issue i have a form in the oncreate event i issue : ora_session.savepoint("S1"); in the onbuttonclick event i issue : ora_session.commit; self.close; in the onclosequery event how do i know that i'm in the S1 savepoint and that i have to do a commit or a rollback? (i cannot...

hi, since beta 4 it seems that the designconnection properties doesn't work anymore : when i execute my application it tries to connect automatically to the database when connected = true and designconnection = true. in beta 2 it was working fine. regards

hello, i'm using DOA 4 beta here is my query : select pgs.rowid, pgs.*, p.nom_pers, p.prenom_pers from GT_PERS_GERE_SERV pgs, GT_PERSONNEL p where cod_serv = :cod_serv order by NOM_PERS, PRENOM_PERS i have the updating table property to GT_PERS_GERE_SERV the problem is that when i insert a...

hello, is there a way to clone a toracledataset ? i mean myrorads2.assign(myorads1); regards

thanks in advance

i already use the 4.0 version

hello, is there a way to change the background color of only fields who are queryable when setting the QBE definitions? regards

here is my problem : form1 contains a toraclesessionpool form2 contains a toraclesession linked to the pool of form1. The connected and designconnect properties are set to true. when i open my projet in delphi 7 (both form1 and form2 are open) i have always this message "Cannot change pool...

hello, i have a query like this : select rowid,i.itemid, i.blobfield from table mytable i where mytable contains about 250 rows and blobfield is of type long in oracle but this is very slow even if i set the readbuffer property to 1. how to set speed up this query? regards

Great! it works now! thank you very much.