Write conflict in ADP on updating table including triggers

L

Lxocram

Summary of the problems surrounding ADP SQL and TRIGGERS

Every trigger starts with

AS
SET NOCOUNT on
DECLARE @identity int, @strsql varchar(128)
SET @identity=@@identity

And ends with

SET @strsql='select identity (int, ' + cast(@identity as varchar(10))
+ ', 1) as id into #tmp'
EXECUTE(@strsql)
SET NOCOUNT OFF

Other possibilities of failure too look into:
*Updatability issues (mainly on views, best way is too work directly
on tables where possible)
http://msdn2.microsoft.com/en-us/library/bb188204.aspx#optaccsql_topic3
*Does your table contain bit values? make them non-nullable and give
them a default value
 
T

Tom Wickerath

what's your point

do you know how to write triggers?
I don't see this crap that you're talking about having to do anything with
triggers

do you kow how to write TSQL?

what are you really trying to do?

using a trigger like this won't ever work for mulitple records at a time,
for example
 
T

Tom Wickerath

every note that gunny is a stupid MDB crybaby


'69 Camaro said:
Everyone please note that Aaron Kem.pf is attempting to impersonate one
of our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
Click to expand...
 
B

Baz

You only need to perform the @@identity trick where the trigger inserts
record(s) into a table with an identity field. Furthermore, the @@identity
trick doesn't resolve write conflicts, it simply ensures that the bound form
displays the correct record after an insert.

Does this happen on just one table? If so, what exactly do the triggers on
that table do? Is there a timestamp column on the table?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

KB275090 Alternative workaround 2
Workaround: ...because it doesn't satisfy the criteria in the underlying record source 2
Write conflict in ADP on updating table including triggers 10
Problem with @@IDENTITY in replicated table with triggers 2
adodb.command execute crash 3
Transaction deadlock on inserting into a table 49
ADP code hangs while running the same query in query analyser works 3
SQL Paging with VS2005 1

Top