o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

[02/03] Is this the Right way to handle Concurrency -

hi All

i want to Control the Concurrency in my Vb.net Application that is Connection to a SQl table. this is my thought and am open for suggestion. Firstly i want to Add an bit Field in my table and named it "Locked" e.g

Customer
+++++++++++++++++++++++++++++
pk_ID | Cname | Lastname | Locked |
+++++++++++++++++++++++++++++
001 Miles Smith 1


if its "1" in the Locked field then its locked. So i want to have a Function in my DAL that returns a dataset, but when selecting records it should exclude those are not null in the "Locked" field, that means we don't select records that use locked. In my system we don't select Data for only viewing the, i was gonna create another object for Reader, but it was unnecessary. So when the user selects the records that are not locked, i want to have a Function that will locked those that are selected, so that another user cannot select them.

After the user has Finish with the Updating then the Lock is released , by setting the records that has been "locked" to Null.



My Question is this the good way to handle Concurrency ?


Thanks

 

[2005] How do you all handle concurrency -
For most of the applications we produce we've allowed "last-in-gets-the-update" type of concurrency. We are about to develop an app for a much smaller number of users then we typically work with - so concurrency on update has become more important. How do you all handle

Concurrency error code -
Hi, I am trying to fix a concurrency issue. I am using VB6, and I want to handle the concurrency issue differently. Does anyone know what is the error code or description for concurrency issues?

Concurrency anyone -
Hi Folks, How do you manage concurrency issues in your application? Do you have some method of propogating the concurrency issues back to the client or do you usually let the database take care of the problem? Either way I am interested to know more on the subject. In our applicati

Concurrency Violation: Update Command effected 0 rows... -
I've been getting a concurrency error when updating my Access database, and I was just wondering what are the most common reasons people get concurrency errors? I was under the impression that it happens mostly when data is changed then changed again before it can be saved, but I'v

ado locking -
Hi, I'm using VB6 + ADO + SS7 just like many others do. I would like to know, how will u implement locking to your applications? I can think of 3 ways at least: 1. Using recordset's Pessimistic or Optimistic locking. 2. Using timestamp field, and compare it b4 updating. 3. U

[02/03] Is this the Right way to handle Concurrency -
hi All i want to Control the Concurrency in my Vb.net Application that is Connection to a SQl table. this is my thought and am open for suggestion. Firstly i want to Add an bit Field in my table and named it "Locked" e.g Customer +++++++++++++++++++++++++++++ pk_ID

Concurrency Control...HOW -
Hi, Does any one of you know how to set concurrency control in VB database? I am currently doing my Human Resource Database Security projecy by using VB and Microsoft Access. One of the features is concurrency control. I need some idea or suggestion regarding to this, coz i really don'

Application Concurrency -
When I distribute my VB app' I want to use a concurrency licensing model. Does anybody know how do implement this?

Object Concurrency -
I would like to ask how everyone is handling object concurrency. For example, user A loads an object with data from the DB, and makes some changes. User B then loads the same data into an object and makes some changes. User B saves these changes (writes new data to the DB). Now use

[2005] hoow to handle concurrency -
im trying to make a simple database test project. i use the code in ado.net tutorial from this site. and run a two forms having the same code and database. unfortunately the other form when i navigate through records does not contain the update database value while the other one has. w

Optimistic concurrency -
How do you implement this in vb.net? Old-style using Timestamps (SQLServer) or do DataSets implement it anyway, in which case how do you trap and report a concurrency violation? Cheers, zapo

COM+ and VB6 (Debugging , Concurrency) -
COM+ and VB6 (Debugging , Concurrency) 1, How will be Test & debug a COM+ components. 2, How can we implement CONCURENCY Control in VB6 using COM+. Shall we make any changes to our VB6 code to accomplish this Anoop & Harrison Enthusiastic COM Aspirants

adFilterConflictingRecords -
Hi all.... I'm trying to handle any concurrency issues when a disconnected recordset is updated back to the db by filtering the recordset using adFilterConflictingRecords and then checking the Status values of each record. The problem is that when i create a concurrency issue(fill t

Recommended course of action in handling concurrency conflicts -
For instance, if you determined that a pending Edit operation would cause concurrency problem, that is another user has already modified the record you are trying to edit, what is the recommend course of action in such cases?

dealing with concurrency using web form insert -
I want to learn how i can deal concurrency when creating a web form to insert data to sql server db.Thanks

DataBase concurrency -
Hello kids. I've a trouble in na app, I use an Access Database conected by ADO.NET and direct commands and transactions. The database is accessed by a network. When the app is running alone there is no problem but if I try the same app in two PCs appears a trouble about locked table

Concurency update ADO -
How do you force a batch update. I am using disconnected recordsets in ado 2.6 and everything works fine. However when I get a concurrency error I want the user to be able to override the changed row if the user decides to. What is the standard way to do this. My second q

Question about databases -
Hello, I am currently in the process of developing a database, but would like to ask in advance the following questions: 1. When using a connection string to connect to a remote database, do i really need the IP address of the remote computer? Can't I just browse the path of the

How to do Concurrency Control Using VB 6 and SQL-Server -
Hi All Please anyone tell me How to do Concurrency Control Using VB 6 and SQL-Server. please tell me all the steps....how to lock the table, how will I know someone is inserting some records or deleting...that time i have to lock the table..... regards Varun

[2005] Concurrency Issue Help Plz! -
Hi Peeps, I have a routine which basically adds rows to a table which works fine. At the top of the routine it checks to see if the row already exists (using key columns); if it finds it, it simply updates the necessary rows. After it has created the row and then does a search and f

Concurrency Control -
Hello fellow VB programmers, I was wondering how one tackled the problem of maintaining data integrity by some sort of concurrency control system. To be more specific, I have a hypothetical vb built forum-like system and want to prevent several or more staff members from altering a

Can you solve this ! -
Hi to everyone. I have an vb app that generates a taxi tickes. This tickets are generated in different modules (or stands). I am using SQL SERVER as database. The tickes are identified by a unic number ( folio ). The problem is the concurrency, when many tickets are gener

Can you solve this !! -
Hi to everyone. I have an vb app that generates a taxi tickes. This tickets are generated in different modules (or stands). I am using SQL SERVER as database. The tickes are identified by a unic number ( folio ). The problem is the concurrency, when many tickets are gener

Cn you solve this -
Hi to everyone. I have an vb app that generates a taxi tickes. This tickets are generated in different modules (or stands). I am using SQL SERVER as database. The tickets are identified by a unique number ( folio ). The problem is the concurrency, when many tickets are ge

A few questions on ADO.net-access -
Hello, I will start working on a program using VB.net this week and i need some information on ADO.net and access 2003. It would also be helpful if you post some links which would be helpful main specifications of the program - DDBMS (not web-based) - concurrency - recovery Q

VB & Concurrent users -
Hi All, I would like to know how well will VB 6.0 handle a situation wherein hundreds/thousands of concurrent users try to access the same field of the same record of the same table of the same database. Database could be SQL Server / Oracle Does the concurrency

[02/03] DateTime formatting/concurrency issue -
I think I may be getting a concurrency violation because for some reason my dataset shows the datetime that it pulls from the database as this "7/10/2008 11:16 AM" and the actual datetime for the record in question in the database is "7/10/2008 11:16:43 AM". So,

Know anything about Citrix -
Bleedin ell.. Ive just been asked to look into the development of a thin client solution in .net and dont know what the hell I'm doing. I understand that Citrix allows Application sharing on a windows server but thats all I know. Have any of you developed anything like this be

Single User Windows Application Concurrency Error -
Hi People, i'm hoping someone will be able to help me soon, as this is a very fustrating problem. I am creating something very simple, but i am also quite new to VB.Net. I have a form that connects to an access database using the OleDB Connection. I am writing a simple address bo

[2005] Concurrency violation -
I get a concurrency violation if I try to do this twice in a row. I dont get an error if I do this once, close the program, re-open the program and do this again. Dim cbUserData As New OleDb.OleDbCommandBuilder(daUserData) Dim dsNewRowUserData As DataRow dsNewRowUserData = dsUse

concurrency violation (because modifying record twice) -
Hello, i'm a newbie in vb.net and i have a problem: I wanted to make a program that by clicking a button. walks trough a table a and creates another table b with fields from table a and other fields => table b (autonumber, date-in, date-out, date-handled,a-id) when this ta

[2005] Concurrency Problem (SQL Server 2005) -
Hi I'm working on a project using C# and MS SQL 2005 and a portion of my DB has two tables: Expenses (which is Master) Expense_Items(which is Detail) and I built a trigger in the detail table to calculate and set the TotalPrice column in the master. the debugger is work

drawing to desktop -
hi, i'd like to be able to draw to my desktop, and i can't seem to be able to get the handle of the window correct. i tried using GetDesktopWindow, but when i blitted to the dc of that handle, nothing appeared. then i used spy++ and i told me my handle was something different, but u

concurrancy -
i am working a web site i am using datareader for fetching records how to control concurrency

Window handle and close window -
Hello everybody, I try to get a handle on a window which is popped up by a special remote library. The programm stops as long as I have pressed the O.K. button on the window. After this I would get the handle, but this is to late. I want to get the handle when the window pops up. I

Sqlserverexpress -
Hi: Need some advice. Here is the scenario: There are 17 Client PC connected to a Server with SQLExpress 2005. 17 Client will do verification of identity before sending data to display at server in first in first out basis using Datagridview ( the earliest data received wil

Concurrency Problem -
I have an Access table in which I'm trying to change a field. I can connect to the database using the wizard, select the table field(s) and everthing goes very smoothly. When I try and do the update it gags and gives me the concurrency violation. I initially had this table related to a

[2005] UserControl Handle -
I have been searching on how to do this to no avail as I need to get the handle of a UserControl that I am writting. So for example in the UserControl1_Load event I would like to retrieve its handle for use use in my control. I see there is the HandleCreated and HandleDestroyed b

What is MY handle -
i have 2 applications. the first is the main app. the second is an Updater that i want to sometimes control the first. the only thing the Updater needs is the handle of the first, which can be retreived by FindWindow()... i know that. but i dont want it to work that way, for few r

Closing programs using TerminateProcess... -
handle = OpenProcess(PROCESS_ALL_ACCESS, False, uProcess.th32ProcessID) GetExitCodeProcess handle, lpExitCode TerminateProcess handle, lpExitCode CloseHandle handle is that all i need?