Recent content by nrsgzz

I haven't tested the solution yet but do you thing using oracle's to_char() instead of trunc() will present the same issue?

Hi. I have a fairly intricate query in a DOA dataset connected to a devexpress TcxDBGrid. Even though ROWID for the editing table is selected as first column and I have set the UpdatingTable property, it still doesn't work ("Record has been changed by another user"). This is the query (TAB_A is...

Hi all. I have a query that uses variables, something like this SELECT * FROM MYTAB A WHERE A.COL1 = :COL1 AND A.COL2 = :COL2 However the variables could be null and in that case the query will never return any results. How can I make it work?

The columns that do not belong to the UpdatingTable have become read only thus cannot be modified in the data-aware grid. However I need to be able to select a value and pass it to the OnBeforePost() event for further manipulation

The solution works however I realized it is not exactly what I want. Using the previous SQL as example: SELECT t1.rowid, t1.name, t1.address, t1.age, t2.role FROM t1, t2 WHERE t1.id = t2.id Using the FieldKinds property allows me to post data to the right table but it also makes the column...

Thank you, exactly what I needed.

Hi all. How can I insert a new row in a dataset when it is formed by multiple tables connected with a JOIN statement? For example I have this SQL SELECT t1.rowid, t1.name, t1.address, t1.age, t2.role FROM t1, t2 WHERE t1.id = t2.id I want to be able to insert a new row in table t1 via a...

Hi all. I would like to present the user with a warning if he forgets to fill out the whole form. In this case oracle would return: However ORA-06550 is a generic error, what I'm interested in is the PL/SQL ORA-00936. How can I read it? Thanks!