Search results for query: *

Hi, I'm going to read a matrix(3,4)text file in col-wise and calculate average for each column. please help me my matrix: 1 2 3 4 2 3 4 5 3 4 5 6

Hi, thanks for the reply. I'm using v2000. Running the code I originally posted does not give an error. However, if I try to access the returned recordset afterwards I get the above error. i.e. if after set rsBill = .execute I then do: Do while not rsBill.eof OR If not rsBill.eof then then it...

TomKane, I tried your way now, and I get the same error - operation is not allowed when the object is closed. Any suggestions? Sara

Thanks. I know this is an alternative method and I suppose I could use it. I just wonder why on earth the other way doesn't work and specifically why it gives that error. Oh well, I'll have to live with this! Thanks again, Sara

Hi, thanks for the reply. Yes, regular SQL statements work, as in: Dim cn as adodb.connection Dim rsBill As ADODB.Recordset Set cn = New ADODB.Connection cn.Open "Provider=PervasiveOLEDB;Data Source=MyPath" 'connection is fine Set rsBill = new ADODB.recordset rsBill.open...

Hi all, I am connecting to a Pervasive DB from VB and am calling a stored procedure and trying to put the results into a recordset. This is VERY standard code and I use it all the time with MSSQL with no problems. But here, when I try to later reference the recordset, I keep getting the error ...