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!

  • Congratulations TouchToneTommy 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: sagn
  • Order by date
  1. sagn

    select top N distinct

    I will try those methods as well. The query first listed is very slow as my table is quite large... Nonetheless, it did produce the required results and since this is a once and done need I did use it. However, I am curious about the other methods so will check them out as well! thanks
  2. sagn

    select top N distinct

    Thanks a lot! As I said I knew I had seen it before but being 3 pm on a friday my brain is fried!
  3. sagn

    select top N distinct

    I would like to have returned the top N entries of a table for each distinct Colvalue s. For example: Table id s 1 w 2 w 3 e 4 w 5 w 6 e 7 e What I want returned is (N above = 2) id s 1 w 2 w 3 e 6 e Any ideas on a query that will do this? thanks. (I'm sure I have...
  4. sagn

    Background color change on tablecell

    Hi I am VERY new to JAVA... but I have been working on something similar. I have a table that alternates row color depending on some value. This was done to improve readability of the table. Anyway, I wound up making each cell Object a JTextField. In the editor I created I used the...
  5. sagn

    multiple recordset update trouble

    thanks a ton I seem to be all set now.
  6. sagn

    One FcusListner for several jtextfields?

    HI I have a form with about 20 textfields on it. I;d like to highlight the jlabel associated with the jtextfield that is in focus. That is easy enough to do, what I am wondering is if there is a way to do this for each JTEXTFIELD/JLABEL without writing 20 different focusevent actions. I...
  7. sagn

    MSSQLServer driver, cursor not updatable

    I think I found the trouble. The Table whose data populate the recordset must have a primary key. Now on to see if I can now multiple concurrent statements and record sets with this driver. I am sure I'll be back. :) thanks
  8. sagn

    MSSQLServer driver, cursor not updatable

    Oh sorry but the exact exception message is Cursor is Read Only. thanks
  9. sagn

    MSSQLServer driver, cursor not updatable

    OK.. I have downloaded a jdbc driver from MS. version 1.4. I create a statement as con.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); when I try to execute updateRow(), I get an exception saying the cursor is not updatable. IF I use...
  10. sagn

    multiple recordset update trouble

    MSSQL Server. There are drivers for this which I clearly have to look into. Once I download the driver, I suppose I use the Class.forName(driver) command. True? Is that all I have to do to load the driver? thanks
  11. sagn

    multiple recordset update trouble

    Yes, they do say the JDBC:ODBC bridge should only be used for experimental use. Well, my experiment failed! Anyway, thanks for confirming my suspicions. I am VERY green as far as JAVA is concerned so I am not yet fully aware of all the nuances! thanks again
  12. sagn

    multiple recordset update trouble

    Hi I have written (or am writing) a program to do the following. Using a JDBC:ODBC bridge 1) Bring down data from three tables (t1,t2,t3) from two different databases (db1,db2). the tables should contain the same data ie db1.t1=db2.t1 but t1 != t2 in data or format. 2) The data between db1...
  13. sagn

    How to create child window?

    thanks again!
  14. sagn

    How to create child window?

    Thank You so much! In fact, I was able to open a javax.swing.JDialog object but did not know why! Thanks again.
  15. sagn

    How to create child window?

    I am *VERY* green at this, so this is a very basic question. I apologize. I have my main form up and running. I have successfully built classes to perform actions upon certain events. I now would like to be able to bring up another window (form) upon some action. But have been unsuccessful...
  16. sagn

    Table update Join Help Required

    OK you want to update the postion in TABLE1. I'd join on name,firstname and address. Why do you need to update ID and Contact# in TABLE2? It seems to me that you would then have two identical tables... Table1 and Table2 ... Also Notes Table2? Is this a separate table? The IDs and...
  17. sagn

    File modified outside of source editor??

    OK. An update. I think I discovered the problem. The code I was writing I placed in our company drive which may also be on our webserver and was not local. There may be some sort of virus checking or something to do with the fact its a webserver that causes the problem. Anyway, Having...
  18. sagn

    File modified outside of source editor??

    Thanks. I tried to close everything but I still get it. ugh...!
  19. sagn

    File modified outside of source editor??

    Hi I am using Compaq Visual Fortran, usually without incedent. Now, after I compile a file a message comes up saying the file was modified outside of the source editor and asking if I wish to reload it. Why is this happening? The file is modified within CVF, it is compiled. No-one else is...
  20. sagn

    file delete

    windows XP, Compaq Visual Fortran Professional 6.6.a

Part and Inventory Search

Back
Top