creating a record lock to ensure that only one user is updating records at a time
I have created an application using vb 6 that allows users (5) to create
orders by connecting to s sql database.
The only problem is that to often I am getting duplicate order numbers.
Here is the code:
adopagecounter.Open "select id,pagecounter,pagedate from Mops_counter",
db, adOpenDynamic, adLockOptimistic
dateformat = Format(adopagecounter.Fields("pagedate"), "ddddd")
If dateformat <> dateformat2 Then adopagecounter.Fields("pagedate") =
dateformat2: adopagecounter.Fields("pagecounter") = 1
mopscounter = adopagecounter.Fields(&...Creating Multiple Record Update Forms
I'm considering moving a payroll application out of Microsoft Access to some
web-based solution. It is getting way to big for Access and the system is
growing unstable, so I'm learning PHP and MySQL and things are looking very
There is one piece of this I am having problems with. The attendance module
shows users all their employees in a table and allows them edit it this way.
My users need to be able to see and update all their employee records at
once, and they need to do it quickly, so they can't wait to load one
employee at a time.
So they would see something...Automatically create new record to related table on update
Hi, first time posting to this group, but I have followed advice and
examples for several months, so thank you.
I work for a small telecommunications company. I have a simple Orders
database that has an Orders table to track a sales order, using
OrdersID as the PK. I have a related one-to-many table called
OrderDetails, with the OrdersID as a FK, which shows all the products
sold with that order. Then I have an Update table, in a one-to-many
relationship with the OrderDetails table (OrderDetailID is FK in Update
table). This table is used to track the status of each product as it
flows throug...Linked Tables Path Updated
I created a MS Access 2002 database with linked tables on a SQL Server
database by way of a File DSN, A. I have created a form which points to
one of the linked tables. After I finished testing it in the development
environment I updated the path for all the linked tables to a new File
DSN, B. After this action, I opened the form to test adding a new record
and the "add new record" navigation button has been disabled. Can anyone
help? I need to be able to add new records through the form and can't
figure out why I am now NOT able to add a record. PLEASE HELP!!
Thank you,...Insert & Update triggers fire together when a new record is created.
I have two triggers, one when an insert is performed and the other
when an update is performed. I use these triggers to synchronize two
billing systems. So when a new account is created I update a temp
table with a tag of 'NEW' and when a account is modified I send it
with a tag of 'CHG'. But I create a new record both of the triggers
fire and I get both the tags 'NEW' and 'CHG' in my temp table. Is
there a way I could avoid this only when I am creating new accounts. I
would be grateful if someone could help me. Thanks in advance.
It shouldn...Tie::DBI problem -> new record is created instead of updating existing one
This was posted a week ago on c.l.p.modules. Since I did not get any
answers, decided to post here as well. Apologies in advance for the ugly
Example taken with modiications from
I'm running Windows XP, MySQL server 3.23.49, ActiveState Perl 631 and the
following relevant modules:
DBD-mysql [2.1026 ] A MySQL driver for the Perl5 Database Interface
DBI [1.37 ] Database independent interface for Perl
Tie-DBI [0.93 ]
I created a MySQL test database as fo...Creating a record of records
I need to have a table which is a list of records (Like a
subscription), one for each user and in that record is a list of all
of the records they have attached to them.
The max number is unknown
What is the best way to do this.
Can I create a set of record ID's within a column or is there another
way to store this data.
In the past I have created a new record for each item in the list, but
I have had problems in manipulating them afterward.
> Hi there,
> I need to have a table which is a list of records (Like a
...UPDATE functions updates all records instead of error records, trap for control characters
I am uploading files for a conversion. I would like to know why the
set_error_flag function doesn't work. I don't get a returned error
message but all the error_flags are set to 1. I inserted some ndc
values into the inventory table from the link table to make sure there
was at least a few that aren't errors in the data but a select shows
all records are marked with 1. The error function purpose is to flag
those that have no match so the ndc value can be added so it will
match the link table.
if ($_POST['cart_id'] && $_POST['bu'] &&
move_uploaded...update record when record is deleted
I want QTY on hand to be updated when record in detail sale is deleted.
can any one help
"khan" <firstname.lastname@example.org> schreef in bericht =
>I want QTY on hand to be updated when record in detail sale is deleted.
> can any one help
IMO helping you is just a waste of time ... I won't help you again, =