Recent content by RayMan

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

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

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.

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

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

Thanks for all your input. RayMan

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

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

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

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

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

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

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

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

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