Search results for query: *

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

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

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

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

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

Hi I want to have my program delete a file if it already exists and then reopen it. In the process I expect the time stamp of the file to change from t0 to t1. So that: before program run file X.txt 2/27/2007 exists Run program 1) delete X.txt...

Hi I am rebuilding old code to use modules. In these modules are subroutines. Often a subroutine will perform a similar function as another sub in a different module. I would like to call these subroutines the same thing. For example : Output If possible to do this, How would I reference...

Hi This is not so much a programming problem as a data change commitment problem. I have a table, newly made... no one else has access to it. No other operations are being performed on this table. I open it in SQL server 2005. I edit data in the table manually. Some of the rows however...

I have large program which I;ve developed with COmpaq Visual Fortran 6.6a on Windows XP. My machine has 1GB RAM and is 2.80GHz. It makes use of f90SQL, user defined types, structures, modules, all sorts of neat stuff. (Well I think its neat anyway) There are 100's of files involved...

hI I was wondering if it were possible to dynamically set the database with the use statement? I have tried exec ('use '+@db) and have tried to use exec sp_executesql N'use '+@db,N'@db varchar(50)',@db=@dbtobeused neither seem to work. I am thinking this is because it is out of scope...

HI I have executed a query and had SQLServer output data to a file. When I try to open the file using TextPad, it says it cannot be opened. I can open it with NotePad and WordPad. I see nothing strange in the file. What's more when I try and read this file using FORTRAN nothing is read...

OK.. I have a large amount of data coming from european sources. The data are text data but they should be numbers. While going through these data I have found some 'typos' where there exist values such as CHAR(215). of course trying to do any sort of convert or cast into a float fails here...

I have been trying to reset values in my recordset using syntax such as rs.fields("colname").value = "value" this seems to be fine. But when I then try to do a MoveNext (or Move Previous) I get a complaint that a column does not exist. (This column is not necessarily the column I tried to...

I have a a string with value '7.0445'. It is placed in a real variable (Ci) and appears as 7.044500 in the debugger. When I try and write it to a string (STR) using F8.3 WRITE(STR,FMT='(F8.3)')Ci It comes out as 7.044 (NOT 7.045) However if I make the variable = to 7.044510 Then the value...

Hi Does anyone out there use F90SQL? If so, do you know if you can bind an array of parameters using ROW-WISE BINDING? I know you can with Column-WISE binding... thanks

Hi When I rename a table in ACCESS, all the queries get automatically updated with the new table name. How can I prevent this? Thanks sagn

This is my dilemma: I have the following: query Private rs As ADODB.Recordset Dim sql As String sql = "Select * from database.dbo.sysobjects where id = object_id(N'database.dbo.tablename')" Set rs = sqlexec (dbc, sql) where sqlexec is a function designed to carry out the query. This...

Hi I have, or at least have tried to, create a class. Using the CompaqVisualBasic 6 interface I opened a new class module. (I did not use the builder) I saved the class. In my project window it appears as Class1(IO.cls) (why does the 'class1' still appear? And when I try and use the class...

I would like to be able to use the ENDFILE command to denote the end of a file. The problem is, the file has been previously rewound, so ENDFILE puts the end of file after the record that was being currently read when the job was 'aborted' (ie an error is found so you exit from the subroutine...