Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ikkyu65

    Get User Information IP....

    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...
  2. ikkyu65

    multiple database connection - OPEN_FORM (..,SESSION)

    OK. Thank you, Dima.
  3. ikkyu65

    multiple database connection - OPEN_FORM (..,SESSION)

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

    multiple database connection - OPEN_FORM (..,SESSION)

    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...
  5. ikkyu65

    How to insert a graphic in a built report

    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...
  6. ikkyu65

    URGENT HELP: How to show a record using NOT NULL?

    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...
  7. ikkyu65

    URGENT HELP: How to show a record using NOT NULL?

    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.
  8. ikkyu65

    Have problems to run *NOT IN* using Join statement

    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...
  9. ikkyu65

    batch job to run stored procedure

    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; /
  10. ikkyu65

    Have problems to run *NOT IN* using Join statement

    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...
  11. ikkyu65

    refresh record in block

    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>...
  12. ikkyu65

    refresh record in block

    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.
  13. ikkyu65

    Display values in a field(wich has a lov) when navigateing

    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...
  14. ikkyu65

    storage parameters

    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...
  15. ikkyu65

    Determining session inactivity from within a form

    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...
  16. ikkyu65

    Passing parms to Crystal Report

    Does anyone have any examples of how to pass parms to a Crystal Report from a Form. I tried CRYSTAL_CRYSTALCTRL.ParameterFields(:item('OCXBLOCK.CRYSOCX').interface,0,'parm1name;30;TRUE'); where parm1name is the parameter name in Crystal. The type is STRING (but I tried with type NUMBER, too)...

Part and Inventory Search

Back
Top