|
Hi there - it has been a long time since I have posted here. I work on a database that is Access based, but our DBAs don't support Access (yeah, that's what I said). So no one knows the answer to my question.
The database our company uses allows us to...
Started by lmnop7854 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at access-programmers):
BUT, always make field....
This error usually requires deleting the specific record from the table where the "#deleted" resides.
This is often generated in a Form field.
In a field such as a null in a number field.
|
|
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....
|
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.
|
|
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 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.
|
|
Hi everyone.
As you know there is no x64 driver for dBase.
"http://msdn.microsoft.com/en-us/vfoxpro/bb190289.aspx"
I tried to make one.
It is extremely faster than ODBC.but there is only one problem.
I cannot determine if a row is deleted or not.
Started by Behrooz on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Fields D3, D4, D5 0x00 ignored FS, Fb, Fp, CL 24 7 0..0 reserved all 31 1 0x01 Field is in .mdx (not header or field description, but actual record data) will contain an asterisk ("*") if the record is deleted, or a blank ....
|
|
I have a coworker who is planning a database for a new app that will have several tables with over 30 fields each. Is this excessive? Maybe I'm just not enterprisey enough to understand.
Edit: Also, a lot of the fields are option-type sort of things (...
Started by franzferdinand on
, 13 posts
by 13 people.
Answer Snippets (Read the full thread at stackoverflow):
A table with that many fields could actually make quite a lot of sense of these fields will be NULL? ....
You include the city, state, and zip code fields in that table? Or, do you only include one field answer is it depends .
|
|
I have defined a Delphi TTable object with calculated fields, and it is used in a grid on a form. I would like to make a copy of the TTable object, including the calculated fields, open that copy, do some changes to the data with the copy, close the copy...
Started by Bill Seven on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The online help has.
(untested, but should work properties indicate the datasets whose records are added, deleted, or copied.
Since the calculated fields are read only, they are not affected.
To the TTable.
|
