Hi,
Do i have to give a commit statement when i update tables in backend(insert, delete,update) from a form, say when user clicks submit, it takes the data in fields and inserts it into the table , but till now i never did that but i could see all data when i queried the table, but i am not sure if that would be right, if i have to give Commit, how do i do that using VBA?
Any help would be appreciated!
Thanks so much in advance!
3 5488
Hi,
Do i have to give a commit statement when i update tables in backend(insert, delete,update) from a form, say when user clicks submit, it takes the data in fields and inserts it into the table , but till now i never did that but i could see all data when i queried the table, but i am not sure if that would be right, if i have to give Commit, how do i do that using VBA?
Any help would be appreciated!
Thanks so much in advance!
If you are using a DoCmd.RunSQL on an INSERT statement then that will be enough. In other words how are you doing the Insert?
Mary
yes! i use Docmd. runsql to do all my insert, delete..so u mean, that should be enough???
yes! i use Docmd. runsql to do all my insert, delete..so u mean, that should be enough???
Yes but without seeing your code I can't confirm anything.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Markus Breuer |
last post by:
I have a question about oracle commit and transactions. Following scenario:
Process A performs a single sql-INSERT into a table and commits the
transaction. Then he informs process B (ipc) to...
|
by: Colm Connolly |
last post by:
Hi all,
I'm working with tables stored by the InnoDB engine and would like to
be able to commit only if there are no errors generated by a group of
statements like this.
/* -*- sql -*- */...
|
by: Fan Ruo Xin |
last post by:
Nothing got wrong with DB2 COMMIT, db2 cfg, ...
Even you did an "insert some_id+1 ..." immediately after you did "select
max(some_id) from .... " in session1. This will not block the operations...
|
by: Martin Staael |
last post by:
When doing a UPDATE on a very large table it can take quite a long time due
to the commit/rollback option.
Is there any way on the client side to disable the commit/rollback option so
that UPDATE...
|
by: janet |
last post by:
HI,
I had a question on auto-commit in DB2 EEE V8 on AIX V5.
Here is my example..
there are two script A.sh , B.SQL
A.sh is following:
|
by: harborboy76 |
last post by:
Hi,
I had posted one topic earlier, but somehow the link
has been broken and I cannot see the topic. So sorry if
this is a duplicate topic for some. Here is the issue
that I'm running into....
|
by: MelApiso |
last post by:
Hi,
I have two databases in the same instance, sourcedb and
targetdb. In sourcedb I created one table (t1). In targetdb I created
another table (t2).
In sourcedb I created one nickname (N2) for...
|
by: fyi85 |
last post by:
I have 8.1.5 on Windows 2003, when I do from CLP with auto commit off:
db2 update table set column=something
and then
db2 terminate
and then
db2 connect to db
db2 select updated column from...
|
by: Anonymous |
last post by:
I resolved this issue.
If you are using an Oracle XA DataSource, Oracle's JDBC driver
will automatically issue a COMMIT when it sees a "DROP TABLE foobar"
statement.
Oracle's JDBC driver...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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,...
|
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...
|
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,...
|
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...
| |