Recent content by Grubi

Exactly what I was looking for. Thank's a lot.

What we were looking for is the possibility you have in the property editor of TVariables at runtime where you could scan the query for all variables it contains.

Having exactly the same problem. Any suggestions.

Ok. Thank's. I think we will stick with 3.4 as the timline for the project is very hard.

We are currently developing an Oracel app with DOA 3.4.6. Would you recommend to switch to 4.0 ? Are there any interface changes from 3.4 to 4 and do any methods/properties behave similar ? Thank's for you suggestions.

Ok, meanwhile I found many many post dealing with this issue in GoogleGroups. This seems to be one of the quirks of Oracle itself and has nothing to do with DOA. IMHO other DBMS (Interbase, Firebird, Informix) have better options with regards to concurrency. Would be enough to have a NOWAIT...

Following scenario with TOracleQuery: 1.) User a executes update query for record x 2.) User b executes update query for record x Now the query of user b is waiting until user a commits the transaction. Is there a way that the query of user b returns immediately with an errormsg. Changing...

How do I declare a variable for queries holding a numeric integer larger that 32bit. otInteger is stated to be 32bit. Thank's.

Maybe this has answered before but I could not find a sufficient answer. How to update and how to insert contens to a blob field from a TOracleQuery ? Seems there must be some add steps taken before you can use a TLOBLocator? Edit:: There are detailed examples in the docs. Sorry for posting...

Does this mean, that a query which reaches eof is automatically closed ? If not this would not work. Edit::: Ok seems that calling Execute and Close multiple times does no harm so you will not need to now the state either. [This message has been edited by Grubi (edited 11 September 2003).]

Hi we are evaluating DOA and have the following question. How is it possible to determine if a TQuery is open or not (Execute was Called) ? Thank's. Regards. Grubi. [This message has been edited by Grubi (edited 11 September 2003).]