I there a simple way to append a new field to an existing open ADO RecordSet? fields.append() won't work if the RecordSet is open, and closing appears to kill the existing data. NB: I'm using Microsoft ActiveX DataObject 2.8 Library ...
How can I generate a report in access with the data from a recordset (instead of a query or table). I have updates to the recordset that also must be shown in the report. ...
I have a form whose controls I want to enable/disable depending on the values in a ComboBox control. This ComboBox control is linked, like all the other controls in the form, to a table. Inside the ComboBox's Change event, I placed the code that enables/disables the other controls. The problem I have is that when I open the form, the ...
I've done development in both VB6 and VB.NET, and I've used ADODB objects in VB6 to handle recordset navigation (i.e. the MoveFirst, MoveNext, etc. methods), and I have used ADO.NET to handle queries in a row-by-row nature (i.e For Each Row In Table.Rows ...) But now I seem to have come to a dilemma. I am now building a program in VB.N...
For background see my question here. So the problem now isn't that I can't send a DataSet to classic ASP but that it can't do anything with it. So I found some code to create a recordset xml structure from a DataSet. I have tweaked it a little from it's original source. The problem is that I can't seem to extract the base stream and ...
This is probably a beginner question, but how do you set a recordset to a string variable? Here is my code: Function getOffice (strname, uname) strEmail = uname WScript.Echo "email: " & strEmail Dim objRoot : Set objRoot = GetObject("LDAP://RootDSE") Dim objDomain : Set objDomain = GetObject("LDAP://" & objRoot.Get("defaultNamingC...
I am using CODBCRecordset (a class found on CodeProject) to find a single record in a table with 39 columns. If no record is found then the call to CRecordset::Open is fine. If a record matches the conditions then I get an Out of Memory exception when CRecordset::Open is called. I am selecting all the columns in the query (if I change th...
Hi, Will a query like this on a recordset work rs.open "select * from table where vd=1; update table set vd1 = 1 where vd=2 or vd=3;" or is there anything wrong thanks ...
Someone I know wants to use diconnected recordsets in an application. To me it sounds like if I have a ORM tool there would really be no need to even touch disconnected recordsets. The way I understand it with ORM the ORM takes care of not hugging connections for unnecessarily long amounts of time, solving the need for a disconnected rec...
I am trying to retrieve an oracle field with datatype clob into a VB array without reformating the retrieval SQL string (simply SELECT * FROM my_table). I am using an ADO recordset. The clob values are lost when I close the connection or do any other action with the recordset. How can I achieve this. ...
What is the fastest way to fill ListView from query when it has over 15000 lists with 9 subitems. it is taking me about 6 minute to load. Here is what I wrote to fill ListView control. Set rs = db.OpenRecordset(strSQL, dbOpenForwardOnly, dbReadOnly) With Me.listViewData .View = lvwReport .GridLines = True .FullRowSelect = ...
Hi, I would like to quickly display MySQL recordsets in blog posts, using a similar ASCII layout to that used by mysql.com in their help pages. I'm using wordpress v2.7. Any ideas? I should also add that I'm using wp-syntax for syntax highlighting, so it's really just generating the ASCII that I'm interesting in. ...
Is there a way to work on a recordset returned from an exec within another SP? The whole recordset, preferably not using OUTPUT I.E. MyStoredProcedure @var1 int AS BEGIN EXEC anotherSP @var1 -- do something against the recordset returned by anotherSP END ...
I am working on a .NET 2.0 conversion of a multi-layer client-server application. For the time-being, we're converting the server-side to .NET but leaving client apps in COM (VB6). My current work is focused on getting data to/from the detached COM based clients. The current version under development is using ADO(COM) recordsets persis...
Hey I wrote a programme that would add, delete, save and search through records in a database (recordset) however I was doing it in a team. My task was to add the search function to the programme, which I have however I am having problems with adding an error message for when somebody types a word/anything that isn't in the database/reco...
I want to iterate through records returned from a MySQL database using Perl, but only ten records at a time. The reason is that the server component can only handle 10 items per request. For example: If the query returned 35 records then I have to send the data in 4 requests: Request # # of Records -------- ...
I'm consuming a web service using a stand-alone VBScript. The web service returns to me a list of jobs, which I need to loop through and add to a SQL database. I can either Run through the nodelist, reading the data and actioning the SQL insert in the loop. or Run through the nodelist building a recordset, then run through the recor...
Hi, I'm retrieving Data from a Database in a record set using VB6... so while retrieving data using Select in SQL I added a column called Comments along wit it so that in the recordset, all the columns of the table+'Comments' column would be present... I don't want to(and also I cannot) update any contents in the database as i'm only 'fe...
Hi, I ve two recordsets which have the same primary key: combination of two columns called 'item_no' and 'Order_id'..... Both recordsets have this primary key(combination) and rest other different columns... Now, I want to order the(those) rows in two recordsets such that the position of the records(with same primary key values) should ...
I'm in a little bit of a road block here, but what I would like to ultimately do is to create a recordset based off of a query and store the information into separate objects (let's call them Foo) then create a new query to group all the Foo objects with the same id's into an ArrayList into Bar objects. How would I go about doing this in...