I have a couple of questions about recordsets:
1. When a recordset is summoned by the code where does it actually exist and in what form...is it created in the database (data source location) as a new table that mimics the actual database table and contains the fields and rows asked for in the query? It is somewhat vague as to it's true nature in the materials I have rummaged through lately.
2. When an UPDATE code command is given does the edited value on the recordset immediately get placed in the actual corresponding table in the database...or does the edited value get changed on the recordset and then after the recordset session is closed the recordset passes the edited values to the permanent table in the database.
3. Finally, When new rows are added to a recordset using ADDNEW I believe that the new rows must be unique in the sense that they cannot overwrite already existing rows that have the same fields, query indexes, and the same information. For example if one were to have a row of data on a table in the database/recordset with a timestamp field (the field the query for the recordset was based on) for 200 hrs and another field on the same row that held the water temperature for that time, could one add a new row of data with the exact same time stamp and data value or would an error message be produced. Or would the new row be created and simply be a duplicate row that would be placed in the data base.
If you could clear this up it would be appreciated. Thanks
5  1606  
I have a couple of questions about recordsets:
1. When a recordset is summoned by the code where does it actually exist and in what form...is it created in the database (data source location) as a new table that mimics the actual database table and contains the fields and rows asked for in the query? It is somewhat vague as to it's true nature in the materials I have rummaged through lately.
2. When an UPDATE code command is given does the edited value on the recordset immediately get placed in the actual corresponding table in the database...or does the edited value get changed on the recordset and then after the recordset session is closed the recordset passes the edited values to the permanent table in the database.
3. Finally, When new rows are added to a recordset using ADDNEW I believe that the new rows must be unique in the sense that they cannot overwrite already existing rows that have the same fields, query indexes, and the same information. For example if one were to have a row of data on a table in the database/recordset with a timestamp field (the field the query for the recordset was based on) for 200 hrs and another field on the same row that held the water temperature for that time, could one add a new row of data with the exact same time stamp and data value or would an error message be produced. Or would the new row be created and simply be a duplicate row that would be placed in the data base.
If you could clear this up it would be appreciated. Thanks
Solutions
1. Recordset is pointer to context area its created on client machine but by assigning its cursorlocation property to server or to client lets the recordset use the consern liabraries of client or server machine
If ur thinking of recordset from db side then yes it is created on server whenevr the qry is get fired then context area is reserved for that qry
2. See whenevr any DML qry gets fired then from frontend u need to commit it i.e. u've to use explicit commit or rollback until that the changes are saved in buffer it doesn't affect the database directly
3. See the timestamp is mantainded by db itself so there is no duplicasy but suppose there is duplicasy then db (oracle) maintain it by using RowId so each and every record is unique
IF still some problem persists contact me
1. You can consider a recordset to be an array with methods. The data is stored in memory on your local computer. You use the methods to get at the data in the array (or collection). The recordset object, depending on the type, maintains any required connection to the database.
2. The database is updated immediately with any changes unless there is a problem as below
3. New rows must be unique only if a field or combination of fields is set in the database to be unique. If the database is supplying a datestamp or autonumber field as the only unique value then you cannot screw it up. If, on the other hand, you are supplying the unique value you must be careful to not add a duplicate value that the database will reject. You can only add duplicate field values to fields that have been set up in the database to allow duplicates.
1. You can consider a recordset to be an array with methods. The data is stored in memory on your local computer. You use the methods to get at the data in the array (or collection). The recordset object, depending on the type, maintains any required connection to the database.
2. The database is updated immediately with any changes unless there is a problem as below
3. New rows must be unique only if a field or combination of fields is set in the database to be unique. If the database is supplying a datestamp or autonumber field as the only unique value then you cannot screw it up. If, on the other hand, you are supplying the unique value you must be careful to not add a duplicate value that the database will reject. You can only add duplicate field values to fields that have been set up in the database to allow duplicates.
Thanks for your assistance!
Solutions
1. Recordset is pointer to context area its created on client machine but by assigning its cursorlocation property to server or to client lets the recordset use the consern liabraries of client or server machine
If ur thinking of recordset from db side then yes it is created on server whenevr the qry is get fired then context area is reserved for that qry
2. See whenevr any DML qry gets fired then from frontend u need to commit it i.e. u've to use explicit commit or rollback until that the changes are saved in buffer it doesn't affect the database directly
3. See the timestamp is mantainded by db itself so there is no duplicasy but suppose there is duplicasy then db (oracle) maintain it by using RowId so each and every record is unique
IF still some problem persists contact me
Thanks for your assistance!
Thanks for your assistance!
You are very welcome Joe
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: vasanth kumar |
last post by:
Hi,
I want to add a row to library table. Table has total 7 fields. But I
want to create the new row with 5 field data. When I run the following query
in MS Access
strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES
('B-096','Hihihihihi','hello','Book','07/18/04')"
It successfully adds the row. But same thing I am trying with the following
ASP code. It gives error, saying syntax error in INSERT into statement.
...
|
by: Mike |
last post by:
Hello,
I have a few rather urgent questions that I hope someone can help with (I
need to figure this out prior to a meeting tomorrow.) First, a bit of
background: The company I work for is developing a web-based application,
one part of which involves allowing the user the ability to page through
transaction "history" information.
The _summary_ history table will have the following fields: ServiceName,
Date, User-Ref1, User-Ref2,...
|
by: Hasanain F. Esmail |
last post by:
Hi,
Your help will be greatly appriciated.
I have a table with following fields. Table's name is tblTicketNumers
TicketNumberID (It is a key field)
TicketNumber (Text field)
AgentsName (Text field)
I have a form which is NOT BOUND to this table with following controls
|
by: Ryan |
last post by:
Hello,
I have a quick question (I hope). I have a form with a combo box and
a multi-selection list box. The list box is based on a query. Users
can select values from the cmbobox to add to the list box (items they
wish inserted into the table), or they can select items in the list
box to delete (from the table). Once they have finished making any
changes, they are to click a SAVE button to actually commit the
changes to the database....
|
by: E.T. Grey |
last post by:
Hi All,
Despite spending the past six to seven hours perusing the docs on the
mySQl site, I still have questions unanswered, and have been unable to
get any help. I am familiar with Sybase, some Oracle and PostgreSQL -
but the mySQL SQL seems a bit "non-standard". I would be very grateful
for any help I get in answering these questions:
Stored procedures
| | |
by: Bob |
last post by:
Hi,
In aspx file, i have a table:
<asp:Table ID="table1" runat="server">
</asp:Table>
In the code-behind, i create rows and cells:
For i = 0 To 50
r = New TableRow()
for j = 0 To 20
|
by: marc_r_bertrand |
last post by:
To all asp/db pros:
The quiz code below works. But there is a problem when too many
questions are answered (radio buttons clicked). I am not an asp pro.
So, is there a pro out there or an amateur guru who will be so kind as
to volunteer some time to figure out where the bug is? This may mean he
will have to go through the tedious steps of creating an .mdb with a
few records...unless the bug is obvious...
On a page with server-code...
|
by: Drew |
last post by:
I posted this to the asp.db group, but it doesn't look like there is much
activity on there, also I noticed that there are a bunch of posts on here
pertaining to database and asp. Sorry for cross-posting.
I am trying to build a "checklist", where a user can navigate to an ASP page
on the intranet which shows a list of "questions" that the user can check
off. I am trying to figure out how to do this so that it is scalable, but I
am...
|
by: darrel |
last post by:
HI vb Wizards, good day, just wanted to ask if somebody there can help me iwth my problem. Am having difficulty in adding up records in my table, the table is in Microsoft Access format.
It Like this when i run my program, there no conflicts at no error pop up message or anything. but not satisfied with the outcome, here my code:
Private Sub Command3_Click()
Dim rsShowRec As New ADODB.Recordset
Dim cnn As New ADODB.Connection
Set...
|
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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
