Hello,
I was wondering, is it possible to add to a recordset? i.e. I create a DAO
recordset with information from one SQL statment, and add records from
another SQL statement (which grabs info from a different source). Similar
to data mapping. Is that possible?
Thanks! 4 2678
huh?
--
Danny J. Lesandrini dl*********@hot mail.com http://amazecreations.com/datafast/
"Jozef" <me@you.com> wrote ... Hello,
I was wondering, is it possible to add to a recordset? i.e. I create a DAO recordset with information from one SQL statment, and add records from another SQL statement (which grabs info from a different source). Similar to data mapping. Is that possible?
Thanks!
Well spoken!
Alright, here is some air code intertwined with some indication of what I'm
trying to acheive
Dim rst as DAO.Recordset
set rst = CurrentDb.OpenR ecordset("Table 1")' This table has three fields
"Field1, Field2 and Field3"
'This would return 12 records, all the records in table1
set rst=rst & currentDb.OpenR ecordset("Table 2")
' Pretend that this would work, and table 2 would have three fields as well,
maybe the same name, may not, but as long as the data types were the same,
result would be all the records from table1 and appended to that would be
all the records from table2.
....similar to data mapping using an ADO dataset.
"Danny J. Lesandrini" <dl*********@ho tmail.com> wrote in message
news:c8******** ************@co mcast.com... huh?
--
Danny J. Lesandrini dl*********@hot mail.com http://amazecreations.com/datafast/ "Jozef" <me@you.com> wrote ... Hello,
I was wondering, is it possible to add to a recordset? i.e. I create a DAO recordset with information from one SQL statment, and add records from another SQL statement (which grabs info from a different source). Similar to data mapping. Is that possible?
Thanks!
Possibly a Union Query would achieve what you describe. Example:
SELECT 'Table1' AS Source, IDS AS Field1, Value AS Field2 FROM Table1
UNION
SELECT 'tbl2002Transac tions' AS Source, fldCategory AS Field1,
fldDescription AS Field2 From tbl2002Transact ions
Data Mapping is (I think, but I claim no expertise here at all) a
technical term referring to the sharing of data between disparate
systems according to a set of specific rules; I'm not familiar with it
in the context of ADO recordsets but perhaps I'm missing something.
Searching ADO (2.8) help for Data Mapping brings up only minor and
incidental references.
Jozef wrote: Hello,
I was wondering, is it possible to add to a recordset? i.e. I create a DAO recordset with information from one SQL statment, and add records from another SQL statement (which grabs info from a different source). Similar to data mapping. Is that possible?
Thanks!
Sure. But you have to do it field by field.
Dim rs1 as dao.recordset
dim rs2 as dao.recordset
'<...stuff to open and filter recordsets...>
rs1.movefirst
while not rs1.EOF
'assuming that rs2 has already been filtered, etc.
while not rs2.EOF
rs1.AddNew
rs1!field1.valu e = rs2!fieldX.valu e
rs1!field2.valu e = rs2!fieldY.valu e
'...
rs1.update
rs2.movenext
wend
wend This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Agoston Bejo |
last post by:
I would like to use an ADODB.RecordSet object to temporarily store some data
and then iterate through it. Actually it needs to be a RecordSet only
because it is a perfect choice as data structure for what I want to do, I
don't want to actually run queries or update tables with it.
It seems to me, however, that the RecordSet works only if there's a query
behind it. ADO complains about the RecordSet not being open when I try to
add rows by...
|
by: Abhijit |
last post by:
I am working in a data warehousing environment which gets sourced from
Oracle ERP (AR/GL/AP). The dimensional entities associated with
incoming data are GL Code (e.g. 110), Department (e.g. 1050), Core
account (e.g. 301) , sub account (e.g 9).
The incoming data needs to be mapped to key performance indicators
(KPI) e.g. 'All Other Revenue', 'OEM Revenue' etc. The mapping is
driven by GL, Dept, Core account , sub-account ranges. Example -
...
|
by: elcc1958 |
last post by:
I need to support a VB6 application that will be receiving
disconnected ADODB.Recordset from out DotNet solution. Our dotnet
solution deals with System.Data.DataTable. I need to populate a
disconnected ADODB.Recordset from System.Data.DataTable data. Below
is the source code I am implementing to test the process. I do not
get any error, that I can see. The problem I have is that at the end,
the recordset seems to be empty. Any...
|
by: CV |
last post by:
Hello,
Could anyone please throw your suggestions on the following
scenario?
(It would be really helpful if you could provide a solution using
..NET,XSLT,XSD,Web Service other than 'Biztalk Server' Approach.) -
Honestly speaking, I am new to this Data Exchanging Process, though I
have some knowledge in XML,XSLT,Webservice,C#,ASP.net etc.
In my project, there is a need to design an interface to handle data
|
by: Josh Strickland |
last post by:
I am attempting to create an Access database which uses forms to enter
data. The issue I am having is returning the query results from the
Stored Procedure back in to the Access Form.
tCetecM1CUST (SQL Table that contains the Customer Information)
tAccountingDetail (SQL Table that contains the information in the
form)
frmAccountingEntry (Access form used to enter data)
spGetCustomerInformation (Stored Procedure which returns data using...
| |
by: Kevin C |
last post by:
I was curious to know what some developers out in the industry are doing when it comes to exposing Data access logic, specifically persistence. This is assuming that your not using an O/R framework or something that completely abstracts you from the persistence details.
Are you:
1. Having simple data type interfaces and the data layer know nothing about the domain models. For example:
public int SaveCustomer( string fname, string...
|
by: Joe-Paul Robb, Jr. |
last post by:
Hello:
I am building a program in Visual Basic 6.0. (Op Sys: Windows XP 2002
Service Pack 2)
I placed an AOD Data Control on a form...and a data Grid. I bound the data
grid to the data control. Then used the following code to populate the data
control ...and thus, the grid:
With datPos
|
by: coolsti |
last post by:
To the more experienced C# programmers, how do I do this best?
I have a 2 dimensional mapping of values in a database, which represent a somewhat round (but not exactly round) shape when drawn out on paper. That is, the "row" coordinate values run from 1 to the maximum number of rows in the mapping, and the "column" coordinates run consecutively from a starting value to an ending value. In somewhat the middle of the mapping, the column...
|
by: lifeisgreat20009 |
last post by:
I am a newbie to Struts and JSP...I have been working on the code below for 5 hours now..I googled a lot but couldn't get much help so finally I am here.. Hoping of getting my problem solved. Please give me some idea where I am going wrong ??
I just want to retrieve data from my emp_mstr table and display it using my JSP file...
The table emp_mstr is as follows :-
CREATE TABLE EMP_MSTR(
EMP_NO VARCHAR(10) PRIMARY KEY,
PASSWORD...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |