SQL Server :: After Delete Trigger Not Working Properly
Nov 14, 2010
I have Header & LineItem Tables. Header Table :
HId, PONo, Dated, ....
LineItem Table :
LId, HId, ItemId, .....
Header Table has a trigger for Delete i.e. when a record from Header Table is deleted, all records from LineItem Table having that HId also gets deleted. Every thing works fine till here, now LineItem table also has a trigger for Delete which Updates/Deletes few other tables.
The problem I am facing is if 5 record having HId = 1 gets deleted from LineItem table the LineItem Delete trigger only runs for first record. Why trigger is not working for all the deleted LineItem records?
View 5 Replies
Similar Messages:
Aug 5, 2010
i made a after delete trigger on a table1 and in this trigger i insert the deleted data in another table name tab2.
when i execute the delete stored procedure of table1 from sql server 2005 then trigger working fine but when i execute delete stored procedure of table1 from c# then it is not working properly.
View 1 Replies
Oct 11, 2010
ALTER Proc [dbo].[Usp_CheckUserLogin]
(
@Username varchar(20),
@Password varchar(20)
)
as
begin
Declare @RowCount int
Declare @RowCount1 int
set @RowCount = (select distinct UsrId from UserMast where username=@username COLLATE SQL_Latin1_General_Cp1_CS_AS )
set @RowCount1=(select distinct UsrId from UserMast where [password]=@password COLLATE SQL_Latin1_General_Cp1_CS_AS)
if(@RowCount > '0' and @RowCount1 > '0')
if (@RowCount=@RowCount1)
begin
-- select U.UsrId,U.FirstName,U.LastName,U.Email,U.companyId,U.role,R.RoleName from UserMast U join rolemast R on U.Role=R.RoleId
-- where usrid=@RowCount
select 'success'
end
if(@RowCount > '0' and @RowCount1 = '0')
begin
select 'username exist'
end
if(@RowCount= '0' and @RowCount1 > '0')
begin
select 'password exist'
end
if(@RowCount= '0' and @RowCount1 = '0')
begin
select 'both not exist'
end
--return @RowCount1
end
my procedure not give me result i think my syntax is not correct
View 4 Replies
Jun 3, 2010
we are running into an issue with our ASP server. If you try to access a password protected page it does a security check and redirects you if you are not logged in, retaining the URL (ie. Members/MemberLogin.aspx?doc=/PodCast/Default.aspx) The vb script places the "/PodCast/Default.aspx" in a variable and holds it until the login process is complete. Once the user types in their username and password it is suppose to do a Response.Redirect(strRedirectURL) and go to the "/PodCast/Default.aspx" but instead it goes to the default.aspx page for logging in successfully.
The kicker is, I know the code is 100% correct becuase it was working on our previous server, but when we pushed all the data onto this server, everything works BUT that piece.
View 1 Replies
Apr 27, 2010
UpdatePanel Won't Properly Trigger If Time Passes?
View 4 Replies
Nov 13, 2010
Data from the server subscription cannot trigger table trigger
View 2 Replies
May 13, 2010
I have created a custom user control and place Ajax editor and override the class of ajax editor to disable few buttons in editor ,
i am getting the following error
unknown server tag on the design time, and iat runtime it is working properly,
View 2 Replies
Apr 4, 2011
I a webproject in asp.net my project worked fine in my pc but after uploading it to a iis server it is not working.My webproject is to delete a file,
string s;
int i;
s = Environment.GetEnvironmentVariable("temp"); ;
[code]...
View 1 Replies
Apr 3, 2010
I have 3 gridviews in one of my web page. I have simplified the system structure in the image below(further description will be stated below the image): As shown in the image above, the web site(presentation layer) will work closely with the Business Logic layer(BLL) and Data Access Layer(DLL). ObjectDataSource control will be the middle man to select, update, insert and delete the data in the gridviews. During Select, returned data from the database at DAL will be stored in a datatable and return to BLL and then the website itself.
The data in the returned datatable will be filetered by type using RowFilter method and stored into the 3 dataviews. Each dataview will act as the datasource for the 3 GridViews respectively, and therefore I specified the datasource programatically instead of setting the datasourceid for each gridview.
dataview1 = New DataView(dtSelectedTable)
dataview1.RowFilter = "Type='1'"
GridView1.DataSource = dataview1
GridView1.DataBind()
dataview2 = New DataView(dtSelectedTable)
dataview2.RowFilter = "Type='2'"
GridView2.DataSource = dataview2
GridView2.DataBind()
dataview3 = New DataView(dtSelectedTable)
dataview3.RowFilter = "Type='3'"
GridView2.DataSource = dataview3
GridView2.DataBind()
However, the Update(command button) and Delete(template field) doesn't work, the RowUpdating and RowDeleting event wasn't trigger when I click on the button, but it works if I set the gridviews' datasourceid to the objectdatasource. I couldn't figure out why, hope that someone who have come across the same problem couldn't provide some guidance.
View 5 Replies
Mar 13, 2010
I have a ListBox1 on the Form that I read in the same Directories: "GetS" as in the code below.
Now I select the first index wich is 0 in the listBox with the mouse and press Button1.
What the code below does is to find that specific folder that also contains a .BMP file and a file: File1.txt
So I will first delete the .bmp file and the File1.txt and at last the directory.
My problem is as follows. When I press Button1 the First time, nothing at all was deleted but the second time I press the Button1, the .BMP file and the File1.txt were delete fine.
But the code breaks at this line and says that the directory isnīt empty. But the directory is empty as I can see when open it manually.
So initially my problem is why the .BMP, File1.txt and the directory arenīt deleted at the first press of Button1 ? (ListBox1 has AutoPostBack set to TRUE and everything is put inside an updatepanel)
[Code]....
View 7 Replies
Apr 3, 2010
I have 3 gridviews in one of my web page, each of which will display different data based on the typeid. I have simplified the system structure in the image below(further description will be stated below the image):
As shown in the image above, the web site(presentation layer) will work closely with the Business Logic layer(BLL) and Data Access Layer(DLL). ObjectDataSource control will be the middle man to select, update, insert and delete the data in the gridviews.
During Select, returned data from the database at DAL will be stored in a datatable and return to BLL and then the website itself.
[code]....
However, the Update(command button) and Delete(template field) doesn't work,the RowUpdating and RowDeleting event wasn't trigger when I click on the button, but it works if I set the gridviews' datasourceid to the objectdatasource.
View 6 Replies
Aug 26, 2010
I am trying to create an Abstract class that looks like the following (note that I coded it right inline here so it may not compile):
[Code]....
I want to (in my edmx design) be able to inherit from EntityBase and have each of those 6 columns be added to the physical database table representing the object that inherits it. So, for example, I have a class called Test that would look like this:
[Code]....
That Test class should have its physical data store mapping based on the other "stuff" plus the properties inherited from EntityBase. Thus, the database table for Test needs to also include those 6 columns from EntityBase. However, I'd like for it to be set up in a way so that they get mapped such that in the edmx design (what is that designer called anyway) when an entity inherits from the EntityBase, I don't need to do any further work to propogate those 6 columns over to the underlying database table. Am I making sense in how I am explaining this? how to accomplish this?
On a side note (and this can be answered separately or not at all) assuming this mapping is in place, NHibernate has a concept called an Interceptor. I'd like to add an "interceptor" to the delete function of any entity that is inherited from EntityBase so that it updates DeletedAt with the current time and DeletedBy with the current user and the same would be true for any updates with UpdatedAt/By. With NHibernate, you can test inside of this interceptor whether or not the object is of a certain type (e.g. object is EntityBase). Any ideas on how to get this with EF 4.0?
View 1 Replies
Apr 20, 2010
I am using following setting for customError.
< customErrors mode="On" defaultRedirect="GenericErrorPage.aspx" >
< error statusCode="403" redirect="NoAccess.aspx" />
< error statusCode="404" redirect="FileNotFound.aspx" />
< /customErrors>
I have a folder "Admin" having access to administrators role. When someone other than administrators tries to access the pages inside admin folder, it is redirected to login page. My expectation is to display "NoAccess.aspx". Whats wrong with this code? Or is there other meaning to statusCode=403.
View 1 Replies
Nov 24, 2010
I have the following situation:
Updatepanel
dynamically loaded Usercontrol
Button
UpdatePanel2
I am loading a Usercontrol with another Updatepanel inside of it. Now in this usercontrol, i have a button which is registered as an async postback trigger for the 2nd Updatepanel. However when I click the button, nothing happens. While debugging, it does not even step into the Click event of the Button which sits in the usercontrol of course. The Parent Updatepanel ist set to Updatemode conditional and hildrenAsTriggers="false". The nested UpdatePanel2 is set to Updatemode=Conditional. I just want the Parent Updatepanel to do nothing and the button to fire its event so that I can load some data in the nested updatepanel.
View 1 Replies
Feb 16, 2011
I have develoed a vb.net application for my client. I have been using datareport for that. The Data report get the output from the dataset file with the parameter. Now we need to show the value order by. For this i have added the order by in sql query which is generated by .xsd file. But still the output does like,...................
View 1 Replies
Feb 15, 2010
I have added a new route to Global.asax in order for me to create some nice seo friendly URLs for some news items I am displaying
routes.MapRoute(
"News",
// Route name
"{controller}/{action}/{id}/{title}",
// URL with parameters
new { controller =
"News", action =
"Story", id =
"", title =
"" }
// Parameter defaults );
routes.MapRoute{"Default",
// Route name
"{controller}/{action}/{id}",
// URL with parameters
new { controller =
"Home", action =
"Index", id =
"" }
// Parameter defaults );
The problem I have is that when I now hit my home page I am getting [URL] displayed in my URL rather [URL] which is what I used to get. I think the news route is picking up everything. Has anyone any ideas on what constraint I could put on the news route above so that it only ever processes requests from the news route. I was thinking of doing a reg ex on the title and excluding anything with the '-' character in it but I coud not get that to work
View 1 Replies
Apr 18, 2010
I am using accordin menu in my site, placed in Master Page, It has 4 pane, each pane have multiple links. it was working fine previously. But suddenly it is displaying this error message There is no source code available for the current location.
It's is asking for show assembly. When I clicked on that I got a stopage at the stack
0000001a mov eax,dword ptr [ebp-0Ch]
I am really not sure what does it means. Also, there are several links in accordin menu, after clicking on anyone of the link I am not able to click the other link, might be because of the above reason.
View 1 Replies
Jun 8, 2010
I am trying to use the ASP.NET regularexpressionvalidator to apply a password policy that enforces the following policy:
Password should include at least 6 characters, at least one small letter, at least one Capital letter, at least one number, and at least one special character. Here is the expression:
^.(?=.{6,})(?=.d)(?=.[a-z])(?=.[A-Z])(?=.[@#$%^&+=!-_()?]).*$
The strange thing I found is that it works fine except with the following scenario, If I use all the required combination without special character such as Hello123" it finds it as valid password. below is the controls used for testing.
View 3 Replies
Jun 11, 2010
I have developed a ASP.Net Server custom control in C# for 3.5. named "myCheckBoxList" inherited from CheckBoxList web control. Working is very simple. It just works as a two option buttons. I have taken a CheckBoxList which will show two fixed checkboxes always. When I check one checkbox then another will uncheck as vise versa. This control works perfectly only when I have placed only one instance of that control on web page. If I place more than one instance of control then it doesnt works.
I need solution from expert minds from developers as stackoverflow users.
View 2 Replies
Oct 18, 2010
I have created a simple app with a page having a server side form, three fields and a button that submits and performs two operations - 1) adds the form fields to the database table 2) sends an email. Now everything works fine on the web browser on my machine but when I access the app through my mobile, the page does not seem to work. the UI and all are set but the button click functionality doesnt seem to be working and also the label which is set after a successful submit is already visible and showing the "thank you" message. Am i doing something wrong here? I have checked the app on Nokia Smartphone browser, android phone, and iphone simulator.
View 2 Replies
Jan 24, 2011
I have VS 2010. But IDE Not Working Properly like some times breakpoints are not applied, auto complete text is not showing etc.,
How can I get VS 2010 IDE right.
I have done Devenv /ResetSkipPkgs also...and resettes all the settings.
View 1 Replies
Mar 7, 2011
I have to show some functionality similar to accordion that is of jquery so i made a custom function of jquery to produce the effect. there is a grid view in which there are two div's here is the code.
<asp:GridView ID="grdAccordion" runat="server" AutoGenerateColumns="false" Width="200px">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<div class="myFirstDiv" onclick="testToggle(this)">
<%#Eval("Name")%>
<div class="mySecondDiv" style="display:none">
<%#Eval("Person_Name")%>
</div>
</div>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
The second div has style property display none. by default all the div are closed.
than i have made a js function that uses the toggle function to perform the action code.
function testToggle(testDiv) {
debugger
var sntHdnValue = $('#hdnSetFlag').val();
if (sntHdnValue == 1) {
$(testDiv).find('div:first').show().attr('isOpen', 'true');
}
else {
$(testDiv)
.parents('table:first')
.find('div[isOpen=true]').removeAttr('isOpen').toggle('slow');
$(testDiv).find('div:first').show().attr('isOpen', 'true');
}
sntHdnValue++;
$('#hdnSetFlag').val(sntHdnValue);
}
here i have made use of the hidden field that let's me know that it is the initial state every thing is closed i am adding a custom attr isopen for my identification
1)the current situation is this At load everty thing should be closed.
2)than at a time only single div should be open. this is working fine. The problem is if i click on the same div that i clicked to open than it has two custom attr isopen now it breaks the second case. how to solve it.
View 1 Replies
Jan 21, 2011
I am using JQuery Table Sorter...Its working fine for all the fields except the year field in my grid view...Year Field is not sorted properly
This is my code:
$(function()
{
$("table[id$='gvInvoiceDetails']").tablesorter({ headers: { 4 : {sorter :
"currency"}},textExtraction:"complex", widgets: ['zebra']
}).tablesorterPager({container: $("#pager")});
});
View 1 Replies
Dec 3, 2010
dear all, my requiredfieldvalidator is screwing up my ok button in my modalpopup and I dont know why. In otherwords, once I include my requiredfieldvalidator and the user clicks ok in the modalpopup, the ok doesnt get fired. see my code below.
[Code]....
View 6 Replies
Jul 1, 2010
i have written the foolwong code to show/hide the panels but it is not working properly can any one tell why..
private void button1_Click(object sender, EventArgs e)
{
panel1.Visible = true; [code]....
But only for first button it is working properly...
View 6 Replies
