I'm using a web service and every time I change something on the dataset, it erases all my parameters. The weird thing is, I can execute the web service call from the data tab and it prompts for all my parameters, but if I click to edit the data the list is empty or if I try to preview the report it blows up because parameters are missi...
Hello all, I have the following command which deletes files that are one day old and that are of mp3 file type. find /home/get/public_html/audio -daystart -maxdepth 1 -mtime +1 -type f -name "*.mp3" |xargs rm -f The problem with this is when i run it, it sometimes says "fork": resource xargs not available. Does this mean, t...
Today, I have seen some legacy code. In the destructor there is a statement like "delete this". I think, this call will be recursive. Why it is working? I made some quick search on Y!, I found that if there is a need to restrict the user to create the stack object, we can make destructor private and provide an interface to delete the in...
Problem I want to securely delete a file in windows XP. Context I need to delete my input file securely once i have finished with it, at the moment i am over writing all the data with zero, this is messy as my temp folder becomes full of old files also the name of the files is a security issue, rather than just moving them to the recycl...
My user is able to select multiple items in a ListView collection that is configured to show details (that is, a list of rows). What I want to do is add a Delete button that will delete all of the selected items from the ListViewItem collection associated with the ListView. The collection of selected items is available in ListView.Sele...
Suppose a long-running process writes to a log file. Suppose that log file is kept open indefinitely. Suppose that a careless system administrator deletes that log file. Can the program detect that this has happened? Is it safe to assume that fstat() will report a link count of zero for a deleted file? Truncation, it seems to me, is...
In testing, the user on a db i've used was a big jefe. in production, he only has Execute. When i called Membership.DeleteUser(user) in testing, it worked. I try the same in production, and i get this: The DELETE statement conflicted with the REFERENCE constraint "FK__aspnet_Us__UserI__37703C52". The conflict occurred in database ...
Situation: table TBL has ~10k entries for deletion table TBL has 14 child tables with delete rule "no action" I want to delete 10k entries and referenced entries in child tables Procedure: delete records in child tables disable constraints (if constraints are not disabled deletion in next step takes forever) delete records in TBL t...
lets say I have this array int[] numbers = {1, 3, 4, 9, 2}; how can I delete an element by "name"? , lets say number 4? even arraylist didn't help to delete? string strNumbers = " 1, 3, 4, 9, 2"; ArrayList numbers = new ArrayList(strNumbers.Split(new char[] { ',' })); numbers.RemoveAt(numbers.IndexOf(4)); foreach (va...
I have stored procedure: ALTER PROCEDURE [dbo].[k_ShoppingCart_DELETE] @cartGUID nvarchar AS DELETE FROM [dbo].[k_ShoppingCart] WHERE CartGUID = @cartGUID When I execute this sp; exec dbo.k_ShoppingCart_DELETE '32390b5b-a35a-4e32-8393-67d5629192f0' result: 0 row (s) affected Actually when I try this query: Delete FROM k_S...
I don't think I am the only person wondering about this. What do you usually practice about database behavior? Do you prefer to delete a record from the database physically? Or is it better to just flag the record with a "deleted" flag or a boolean column to denote the record is active or inactive? ...
Hi, I have an application with 2 directories (books and export). If we create a book or a page of a book in the application a directory is added with the id of the page (this is for uploading resources). If we delete a page, the page (and it's directory) is removed from the database and the filesystem. However this resulted in a session...
I have this code showmessage('C:\TEMP\'+openfiles[openfilelist.ItemIndex].ID); if removedir('C:\TEMP\'+openfiles[openfilelist.ItemIndex].ID) then showmessage('Removed') else showmessage('Failed'); the message shows 'C:\TEMP\0' and this directory does exist as the program created it earlier and used files inside it and then later d...
I want to do something like: DELETE FROM student WHERE student.course, student.major IN (SELECT schedule.course, schedule.major FROM schedule) However, it seems that you can only use one column with the IN operator. Is that true? Seems like a query like this should be possible. ...
Hi, Reading the bottom of this document, specifically: "You can still retrieve properties of deleted objects, but you cannot save deleted objects." what the heck? how?...is it only if you enable a setting? http://propel.phpdb.org/docs/user_guide/chapters/ManipulatingObjects.html#ManipulatingObjects.Deleting explanation would be appr...
Hello, I've deleted some records from a table in a Sql Server db. Now the Ids go from 101 to 1200. I want to delete the records again, but I want the id's to go back to 102. Is there a way to do this in Sql Server? ...
I have a database of components. Each component is of a specific type. That means there is a many-to-one relationship between a component and a type. When I delete a type, I would like to delete all the components which has a foreign key of that type. But if I'm not mistaken, cascade delete will delete the type when the component is dele...
Let's say I have a resource that can have two different behaviors when delete is called The resource is deleted. The resource is moved to the recycle bin. How would model it in a REST compliant way? I thought about the following solution: DELETE /myresource moves the resource to the recycle bin (default behavior) DELETE /myreso...
I have a master table A, with ~9 Million rows. Another table B(same structure) has ~28K rows from table A. What would be the best way to remove all contents of B from table A. The combination of all columns(~10) are unique. Nothing more in the form a of a unique key ...
I can easily select all comments from XML by select @XML.query('comment()') but can't find how to delete them. Is there appropriate syntax for @XML.modify('delete ...')? ...