Search results for query: *

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

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

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

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

thanks a ton I seem to be all set now.

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

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

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

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

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

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

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

thanks again!

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

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

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

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

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

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

windows XP, Compaq Visual Fortran Professional 6.6.a