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: *

  • Users: Ravala
  • Order by date
  1. Ravala

    how to declare table in sql*plus

    ...tJacketID is TABLE of NUMBER(10) INDEX BY BINARY_INTEGER; PROCEDURE UPD_OPEN_WAIT (JacketID IN tJacketID ); END; How can I execute this package from sql*plus? I tryed to set: var JacketID TABLE of NUMBER(10) INDEX BY BINARY_INTEGER; and var JacketID tJacketID; it doesn't work this way...
  2. Ravala

    how to use codabar?

    How can I use codabar? Do i need additional functions for that? I have it in fonts and when I format fiels with codabar, all order_id look the same. Please help.Thanks.
  3. Ravala

    FlatScrollBar-inavlid use of property

    I can't figure out why I have this error. I have two picture boxes. One picData as a frame for another picData2 where I load controls in run time. Private Sub picData_Resize() Dim sngHeight As Single ' Initializations sngHeight = 0 scbVert.Visible = (picData2.Height > ScaleHeight)...
  4. Ravala

    property visible always false

    in first case, it is false in second, it is true.
  5. Ravala

    command button click event

    I have text box with mltLine=true. The problem is if user put "enter" in this box it triggers the command button click event. How cam I void it? Thanks.
  6. Ravala

    property visible always false

    I have small procedure, Private Sub picData_Resize() Dim sngHeight As Single sngHeight = Me.txtName(0).Height * Me.txtName.Count + 100 scbVert.Visible = sngHeight > ScaleHeight .... some code End Sub scbVert is flat scroll bar. It's never getting Visible even when sngHeight >...
  7. Ravala

    selection formula

    I have three input parameters and record selection formula looked like this: {ORDER_PROC_V.ACCOUNT_ID} = {?Account_ID} and {ORDER_PROC_V.SHIP_DATE} >= {?FromDate} and {ORDER_PROC_V.SHIP_DATE} < DateAdd("d", 1, {?ToDate}) It worked fine until I inserted control structure and changed formula on...
  8. Ravala

    selection formula

    I use selection formula from VB. {ORDER_PROC_V.SHIP_DATE} in Date (2004, 8, 5) to Date (2004, 8, 5) . How can I modify this formula if I need report just for one single day:{ORDER_PROC_V.SHIP_DATE}=Date (2004, 8, 5) Thanks.
  9. Ravala

    not a GROUP BY expression

    I need in one SQL count by two different group: by order_id from ORDERS table and item_id from order_items. I have the folloing SQL: SELECT O.ACCOUNT_ID, O.SHIP_DATE, count(O.ORDER_ID) , COUNT(I.ITEM_ID) over (partition by COUNT(O.ORDER_ID) ) LINE_ITEMS FROM orders o, order_items i WHERE...
  10. Ravala

    help with sql

    Did you notice tr_number always different, it just breaks grouping. I have 0 in "STATUS NULL" and 1 in "STATUS V".
  11. Ravala

    help with sql

    It gives me all orders, I need orders with at least one V status. And it doesn't give me sum.
  12. Ravala

    help with sql

    I have order_id status tr_number 123 null 99991 123 null 99992 123 V 99993 128 null 99994 128 V 99995 130 null 99996 130 null 99997 And I need to select orders which have at least one status "V" , and how many such...
  13. Ravala

    connection to datasource

    Tables, Views are checked. It's not a reason.
  14. Ravala

    connection to datasource

    When I connect to Database I see just PUBLIC and SYS users. What settings I have to change? Thanks.
  15. Ravala

    database link

    in dba_db_links: OWNER DB_LINK USERNAME HOST CREATED PUBLIC COM_PROD prod 11-OCT-04
  16. Ravala

    database link

    We have two databases, dev and prod. I created publik link on dev, COM_PROD. Still when i use desc myTable@COM_PROD, it gives description of myTable on development server. What could be wrong? Thanks.
  17. Ravala

    Unique constraint

    In table we have order_id (number) and ship_status (varchar2(1)). I'm trying to create Unique as order_id and status. If status null the same order_id can be in table a few times, but if status 'V' it should be unique. Can I do that thru oracle. Thanks.
  18. Ravala

    different result

    select DATE_LAST_USED from inventory where item_code='125-325'; i have: DATE_LAST --------- 12-AUG-04
  19. Ravala

    different result

    We have two servers: development and production. I run this sql: select DATE_LAST_USED from inventory where item_code='125-325' and DATE_LAST_USED <=TO_DATE('07081997','mmddyyyy') ; on development i have: no row selected, and on production I have: DATE_LAST --------- 02-AUG-04 What could...
  20. Ravala

    foreign key before primary key

    could you give me example using this constraint. What I have to specify in Jacket_object_id field? Thanks.

Part and Inventory Search

Back
Top