recordset Questions
4
As a part of my shell script, I am trying to create record sets in AWS Route53. However, using variables in the aws cli within my shell script to create those records set, my variables exported in ...
Lindgren asked 12/3, 2018 at 5:14
4
Solved
I would like to know, which of the following examples is the best for closing a recordset object in my situation?
1)
This one closes the object inside the loop but opens a new object when it move...
Rizo asked 6/7, 2012 at 23:32
5
Solved
How do I test if a Recordset is empty?
Dim temp_rst1 As Recordset
Dim temp_rst2 As Recordset
Set temp_rst1 = db.OpenRecordset("SELECT * FROM ORDER_DATA WHERE SKUS_ORDERED = '" & cur...
3
Solved
I am working on an Excel application that queries a SQL database. The queries can take a long time to run (20-40 min). If I've miss-coded something it can take a long time to error or reach a break...
4
Solved
I have a filled ADO recordset in my VBA module. I also have a table in ACCESS that has exactly the same structure as the recordset.
Now I fill the table using a loop (which is fine) going through...
6
Solved
I have a program that is supposed to read data from an SQL database and report back to Excel. It works as expected on a 32-bit machine, but since I moved over to a 64-bit work environment, the prog...
4
Solved
I often find it confusing as to when it is appropriate to use:
rs.Close
opposed to
Set rs = Nothing
I can understand needing to close a connection to a source, but should I be using both w...
3
Solved
Are there any means to work with long query results in Hibernate? What if I want to draw table with million of records and allow user to navigate over it?
The goal is not to transfer all data to c...
2
Solved
I have done some tests:
>>> empty_recordset = self.env['res.users'] # empty recordset
>>> not_empty_recordset = self.env['res.users'].search([('id', '=', 1)]) # recordset with on...
Essam asked 12/12, 2017 at 17:29
3
Solved
I added some fields to the model stock.move and I importing a CSV file in order to create some records. I go over the all the rows and I create the records one by one as you can see here:
lot_id =...
4
Solved
The issue here is related to another question I had...
I have millions of records, and the ID of each of those records is auto-incremented, unfortunately sometimes the ID that is generated is som...
Typhogenic asked 9/12, 2011 at 17:58
5
Solved
What I'm looking for seems pretty straight forward to me, but my googles have failed.
I want a method that allows me to run any query and get the results in json format.
The trick is I don't wan...
4
I have two lists of song titles, each in a plain text file, which are the filenames of licensed lyric files - I want to check if the shorter list titles (needle) are in the longer list (haystack). ...
Hebephrenia asked 30/6, 2015 at 21:57
1
When I delete data in a Form or SubForm, I want to catch the deleted record in the BeforeDelConfirm event. I know it is possible to get the data out of the "delete buffer" to use it for something e...
1
Solved
I'm executing a stored procedure using ADO in VBA. I'm trying to populate the recordset with the results from a stored procedure in SQL Server 2008. Example of the VBA below:
Public Function DoSom...
Whipstitch asked 23/2, 2015 at 15:30
1
Solved
I have been searching for a way of duplicating or copying a recordset in VBA. And by that I mean, having the undelying data independent of each other.
I have tried
Set copyRS = origRS.Clone
Set c...
4
Solved
I'm a newbie at VBA and attempting to understand someone else's code.
Set rstClone = Me.RecordsetClone
rstClone.MoveFirst
Why does the recordset have to be cloned? Why can't the code be Me.Re...
1
Solved
Ok. I am quite new to SQL triggers and have had some issues with them. Insert trigger works just fine, and the Delete trigger also. At first, doing a delete on multiple rows would only delete one, ...
Stipple asked 18/5, 2013 at 13:52
3
Solved
I work on an Access DB and I have to use a Datasource connection to a SQL Server.
To do that I use the ADODB object with :
-ADODB.Connection
-ADODB.Recordset
Code Up-to-date, following an ob...
Surf asked 26/4, 2013 at 7:58
6
Solved
There is some literature available at expert's exchange and at teck republic about using the combobox.recordset property to populate a combobox in an Access form.
These controls are usually popul...
2
Solved
I fail to execute an SQL query with a with clause via ADODB and Oracle.
That is, the following snippet works:
Dim cn As ADODB.connection
Set cn = ....
Dim rs As ADODB.recordSet
Set rs = New ADOD...
Deliberation asked 23/2, 2010 at 9:7
2
Solved
I am trying to query a MySQL database with the below code:
'declare the variables
Dim Connection
Dim Recordset
Dim SQL
'declare the SQL statement that will query the database
SQL = "SELECT * FRO...
3
Solved
I've looked around and there doesnt seem to be any easy way to do this. It almost looks like it's easier just to grab a subset of records and do all the randomizing in code (perl). The methods I've...
2
Solved
Does use of PreparedStatements and ResultSets creates a "new database instance" everytime they are used?
Or, whith other words, if I use a PreparedStatement and a ResultSet, should I close them aft...
2
Solved
Please don't laugh because I'm asking a VB6 question? I have to do some maintenance work. Does anyone know what the maximum number of rows can be returned to a VB6 ADO Recordset? If there is a limi...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.