Recent content by ikkyu65

Some d2kwutil funtionality, you can get it, in 9iAS, with Webutil (look for webutil in OTN). Webutil is prepared to be run with Oracle 9i Forms version 9.0.2 and higher. But it's possible to try it with Forms 6i, perhaps with some changes. Webutil utility has a pll-library with a package named...

OK. Thank you, Dima.

Thanks Dima. I think I still haven't understood well the meaning of SESSION in OPEN_FORM built-in. Thanks again.

I have a Form (FORM1) running against a database connection (conn1). This form calls another form (FORM2) with OPEN_FORM('FORM2', SESSION). FORM2 makes its own LOGOUT + LOGON because it runs in a different database connection (conn2). ¡But this LOGON changes the FORM1 connection too! Is it...

Hi, You don't specify what kind of problem you have. I suppose... - Data Model has both queries. - You have created a graphic in Trailer Section or at the end of Main Section. - You have said to the graph wizard to get data from second query as you desire. Then, it should normally...

I was not sure to have understood what sommererdbeere needed. For that, I wrote what my query solved. The second query shows: - all workcenters <> 'SU' with their QTY (zero or not) and - Only workcenters = 'SU' with QTY <> 0 (if = 0, workcenter will be rejected) I'm not sure what he...

This select shows all work centers but only shows their quantity when workcenter code identifier is 'SU' and not equal '0'). I think it's what you need. SELECT workcenter,DECODE(workcen,'SU',DECODE(qty,0,NULL,qty), NULL) from workcenter Regards. Enrique.

Hi, My english is not very good but I'll try to explain correctly. I have an Oracle 9i DB, but, sorry, I can't understand why you say your query is ok: - SELECT clause can't see INV_HIST columns because this table is inside an expression and this query expression only returns ORD and PTNO...

The .bat file will be: sqlplus myuser/mypasswd@connect_identifier @mycommandfile.sql In mycommandfile.sql file write the sqlplus commands you need: -- sqlplus commands BEGIN MYPROCEDURE(param1,param2,...); END; /

On the one hand, there is a very simple way to solve cust(+) = trans(+) (full outer join) SELECT a,b,c,d,... FROM CUST C, TRANS T, ... WHERE C.IDa = T.IDa (+) AND C.IDb = T.IDb (+) ... UNION -- no UNION ALL SELECT a,b,c,d,... FROM CUST C, TRANS T, ... WHERE C.IDa (+) = T.IDa AND...

Form Property -> Isolation Mode = Read Committed Block (to refresh) Property -> Locking Mode = Delayed WHEN-BUTTOM-PRESSED /* This is the refresh buttom */ /* I get the new values of the record and assign them to my block */ SELECT ... from <block_table> ... SET_RECORD_PROPERTY(<my_record>...

Sorry, but I can't understand well the problem. However, I think that the text item property &quot;Initial Value&quot; can help you. Best regards.

I'd like telling you my experience about this case. When a value is assigned to a non-database field in post-query trigger, the record status is not altered. The matter, here,is the validation process, which starts when the record is loaded. We have a text item with a LOV attached and, I'm sure...

You have a storage definition clause. You can specify this when you create a segment definition (a logical structure of storage) in CREATE TABLESPACE. Also, you can put this clause in a CREATE TABLE/INDEX... in order to override the tablespace storage parameters asumed as default for every...

I don't know if you still have the problem. But there are the Windows System Interface routines (see Forms Help)I supposed can be usefull for you. (I don't know if you can use this capability (I'm a little beginner). I use Forms6. For example: Win_Api_Session.Timeout_Start_Timer Description...