Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 07, 2012 12:11 PM by masterdineen
Nov 04, 2012 09:25 PM|LINK
i am using VB
Is there a way i can have a SQL Stored Proc execute 2 seconds once the user clicks a button.?
Nov 05, 2012 03:15 AM|LINK
Just add the below statement in your SP, or sleep call in .net before SP call.
WAITFOR DELAY '00:00:02'
Nov 05, 2012 08:11 PM|LINK
My idea of delaying a stored proc has not worked.
The reason why thought of this is because i am experiencing a foreign key constraint error.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_FKColumn_aspnet_Users". The conflict occurred in database "database", table "dbo.aspnet_Users", column 'UserName'. The statement has been terminated.
I understand why this is happening. what is the best way around this.?
Nov 05, 2012 08:12 PM|LINK
Also for more information i am using a create user wizard on my webpage.
Nov 07, 2012 12:11 PM|LINK
Ive worked this one out now.
all i did was create an After Insert Trigger on aspnet_users table to update my related table afterwards.