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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RayMan

  1. RayMan

    How do i setup a combo box to list entries when clicked

    Try this: cmbEvent.Clear SqlTxt = "SELECT * from EventMstr order by event_dt desc " Set rstEventMstr = dbsFruit.OpenRecordset(SqlTxt, dbOpenDynaset) If rstEventMstr.EOF Then MsgBox "Event must be added before inventory " rstEventMstr.Close Exit Sub End If Do...
  2. RayMan

    MSHFlexGrid - Row Selection

    This is some code I used to mark a flex grid row with the color red if it was clicked on. If the row clicked was already marked as red, then the color was turned off. Private Sub Flex_Click() ' if we clicked on a row marked with red, then ' we will unmark the row and exit the routine If...
  3. RayMan

    How do i insert a text file as part of the program

    generally files are referenced by curdir (the default directory which the vb executes from) & the file name. if you do not fully qualify (IE: c\mydir\myfileid) you will not locate the file.
  4. RayMan

    How do you read from an .INI file?

    ' Read the fruit.ini file to get parameters Open sDir & "\fruit.ini" For Input As #1 Len = 80 ' Read thru ini file. Do While Not EOF(1) ' Loop until end of file. Readini ' Read fruit.ini file. If EOF(1) Then Ctr = 0 End If...
  5. RayMan

    use progress bar to show status of SQL stored procedure action

    jUST AN IDEA Since the stored procedure takes control and does not pass control back to your app until finished, I do not think you have the ability to increment your progress bar. If you modify your stored procedure to do N transactions and then return to the Vb app then you can increment the...
  6. RayMan

    AIX/Oracle tuning WIO problem

    Thanks for all your input. RayMan
  7. RayMan

    AIX/Oracle tuning WIO problem

    My disks are logical volumes with the data stripped across multiple physical volumes. So an iostat tells me hdisk5 is busy. This does me little good this is not the activity for a physical volume but a logical one. Is would be easier if I could tell the pid causing the WIO. tty: tin tout...
  8. RayMan

    AIX/Oracle tuning WIO problem

    Yes, I know, When I copied this from unix, the columns were skewed during the copy. The problem is that I get WIO even when the sys and user cpu consumption is very low, in some cases 0. Look at the last two times. WIO of 3 and 2 when sys & usr cpu is zero. As the load increases so do the...
  9. RayMan

    AIX/Oracle tuning WIO problem

    I am running Oracle 8.1.5 on AIX 3 4 000942214C00. My sar report is as follows: 07:50:51 %usr %sys %wio %idle 07:50:52 4 1 1 94 07:50:53 3 0 0 96 07:50:54 2 2 1 96 07:50:55 16 3 1 80 07:50:56...
  10. RayMan

    Upload a File to a Database?

    On a form; set up a drive list box set up a directory list box set up a file list box lET THE USER select the file they want using this set of list boxes. one the user has selected the file he/she wishes you can open the file and read it and do anything with the contents record by record...
  11. RayMan

    to_number

    you might try sqlCAP = "select prod_id, to_number(prod_num)," _ & "to_number(item_num),release_date, prod_status " _ & "from PRODUCTS " _ & "where prod_id = '" & RSprod_id!Issn & "' " _ & "and current_prod = 'Y'...
  12. RayMan

    Search strife..

    I use a flex grid to display the records that meet my search criteria. Then I double click on the row selected, and click a command button (View Record) which displays the detail information on a update,delete form. RayMan
  13. RayMan

    Data.Recordset.FindFirst

    Perhaps your need a wildcard! ex: "ART*" For best performance, the criteria should be in either the form "field = value" where field is an indexed field in the underlying base table, or "field LIKE prefix" where field is an indexed field in the underlying base...
  14. RayMan

    to_number

    What does the sql statement return in VB? Can I see your openresult statement and how you reference the variable in your code? to_number converts char, a value of CHAR or VARCHAR2 datatype containing a number in the format specified by the optional format model fmt, to a value of NUMBER...
  15. RayMan

    INSERTING RECORDS

    What is the objective of trying to physically order the rows. Is it by last name, timestamp, etc.? You can always return the rows in the order you desire by using an order by on your sql statment. In a realational db the physical order of the rows is not important in most cases. Rayman
See more

Part and Inventory Search

Back
Top