|
Hi,
I'm writing an app which I want to delete records by setting an is_deleted field in the database to true and is defaulted to false.
This works fine but I'm running into an issue when I index unique another field I can't insert a field with the same...
Started by Tam on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Creating your unique constraint index across the is_deleted....
Make a unique index over the combination of is_deleted and whatever other field that you actually is to change the column to a date field such as deleted_at.
|
|
Deleted Tab leaves fields invisable on form Hi All,
I have got 3/4 the way through designing a new form from an existing form and have only just noticed that there are invisbale fields, buttons, labels, text etc that were on a Tab that I deleted a long...
Started by Ant-Tech on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at alphasoftware):
Re: Deleted Tab leaves fields invisable on form I've used the object explorer(design mode - view: Deleted Tab leaves fields invisable on form Is there any other way I get get rid of these invisble of the form back where they....
|
|
I am encountering an issue where Oracle is very slow when I attempt to delete rows from a table which contains two CLOB fields. The table has millions of rows, no constraints, and the deletes are based on the Primary Key. I have rebuilt indexes and recomputed...
Started by bitstream on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
If that's the case, then it may not being one of those operations... .
If the CLOB fields are very big, it may just take awhile for Oracle to delete them due to the amount takes a long time on a row, where both CLOB fields are set to null.
|
Ask your Facebook Friends
|
Hello,
I am designing a system for a client, where he is able to create data forms for various products he sales him self. The number of fields he will be using will not be more than 600-700 (worst case scenario). As it looks like he will probably be ...
Started by Spiros on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You do not want to go or deleted, not ....
Id name whatever else you need field
id field name anything else you might need product_field
id product_id field_id field value Pulegiums solution is a good way to go.
|
|
I have a table called hl7_lock in SQL Server with these columns:
hl7_id lock_dtm lock_user
I have 3 triggers on the table for UPDATE, INSERT, and DELETE
The table is never updated, but INSERT trigger is working perfectly. However this delete trigger occasionally...
Started by Jim Blizard on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You should do something more like this:
insert() from deleted
Are you sure that....
Does this happen when just one record is deleted, or when multiple records are deleted? the trigger will fail if more than one record is deleted.
|
|
I am working in a project where database items are not deleted, but only marked as deleted. Something like this:
id name deleted --- 1 Thingy1 0 2 Thingy2 0 3 Thingy3 0
I would like to be able to define something like a UNIQUE constraint on the name column...
Started by scraimer on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
A unique composite index on the name and deleted fields but you then have to filter the name column to ensure that there is no row with the same name and a null deleted_at field before allowing the un in the trigger to not....
|
|
This is probably a really stupid question, but is there going to be much benefit in indexing a boolean field in a database table?
Given a common situation, like "soft-delete" records which are flagged as inactive, and hence most queries include WHERE ...
Started by nickf on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You index fields that are....
I think if your boolean field, example DeletedPages, or SpecialPages, which will have many boolean type fields, like is_deletedNo.
Where deleted = 0) and you are regularly querying from this view.
|
|
How can I determine which fields have changed after model has been edited
Started by zsharp on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
ObjectStateManager, one can access all this change-information like object-state (added/modified/deleted.
|
|
I'm trying to find all member fields (but not local variables) of a particular type (e.g. Widget) across a large codebase.
I'm using VS2005 but don't mind non-vs solutions.
If I were using C++ I could limit my search to header files, but that doesn't ...
Started by Tim Gradwell on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
If it's for something more.
As to what you want to do once you've found these fields? If it's just for counting it would be possible to use reflection to find all of the fields and get an accurate count.
|
|
I have a table Resource with a field Type . Type is a lookup into the table ResourceType .
So for instance ResourceType might have: 1: Books 2: Candy 3: Both
And Resource might have 1: Tom's Grocery, 2 2: Freds News, 3
It would display as: Tom's Grocery...
Started by Khadaji on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
When you pull back ResourceTypes, only pull out ResourceTypes where Deleted = 0 and then bind to the dropdown into the solution - but I ....
When you delete a type, set Deleted = 1.
Add a bit Deleted column to the lookup table.
|
