Click here to Skip to main content
15,868,141 members
Home / Discussions / Database
   

Database

 
GeneralRe: How do I pass parameters from one jquery tab to another? Pin
samflex27-Apr-14 5:53
samflex27-Apr-14 5:53 
Questionscript to delete related rows without cascade Pin
Nico Haegens25-Apr-14 1:57
professionalNico Haegens25-Apr-14 1:57 
AnswerRe: script to delete related rows without cascade Pin
Mycroft Holmes25-Apr-14 13:16
professionalMycroft Holmes25-Apr-14 13:16 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens25-Apr-14 23:54
professionalNico Haegens25-Apr-14 23:54 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes26-Apr-14 0:33
professionalMycroft Holmes26-Apr-14 0:33 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens26-Apr-14 4:41
professionalNico Haegens26-Apr-14 4:41 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes26-Apr-14 13:46
professionalMycroft Holmes26-Apr-14 13:46 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens26-Apr-14 23:12
professionalNico Haegens26-Apr-14 23:12 
I have set my foreign key constraints to disallow cascade effects so there are no accidents in what gets deleted.
Here is how my application works:
- users can't delete, they can only archive, meaning I set a boolean field to true and the item in the database won't appear in anything in the application to the normal user.
- admins can delete, but the problem is that my client doesn't have any IT minded people, so I want to prevent them to accidentily delete a whole bunch of data. Your signature suggests to me, that you are familiar with people who aren't IT minded.
So what I basically want to do is:
- show the admin user what the object is connected to(the list of data connected to the object) so the admin knows exactly what he is deleting
- then let the admin delete the data if he is sure the data can be deleted from the database. Do you know a good solution for my problem?
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes27-Apr-14 12:44
professionalMycroft Holmes27-Apr-14 12:44 
QuestionExecute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8024-Apr-14 8:24
USAFHokie8024-Apr-14 8:24 
QuestionRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
ZurdoDev24-Apr-14 10:33
professionalZurdoDev24-Apr-14 10:33 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 1:21
USAFHokie8025-Apr-14 1:21 
SuggestionRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
ZurdoDev25-Apr-14 1:27
professionalZurdoDev25-Apr-14 1:27 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
thatraja25-Apr-14 2:15
professionalthatraja25-Apr-14 2:15 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 2:32
USAFHokie8025-Apr-14 2:32 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
thatraja25-Apr-14 2:48
professionalthatraja25-Apr-14 2:48 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 2:57
USAFHokie8025-Apr-14 2:57 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 2:59
USAFHokie8025-Apr-14 2:59 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
thatraja25-Apr-14 4:29
professionalthatraja25-Apr-14 4:29 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
Simon_Whale25-Apr-14 3:28
Simon_Whale25-Apr-14 3:28 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
USAFHokie8025-Apr-14 3:37
USAFHokie8025-Apr-14 3:37 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
Jörgen Andersson25-Apr-14 3:23
professionalJörgen Andersson25-Apr-14 3:23 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
GuyThiebaut25-Apr-14 3:32
professionalGuyThiebaut25-Apr-14 3:32 
QuestionRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
GuyThiebaut29-Apr-14 4:21
professionalGuyThiebaut29-Apr-14 4:21 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
thatraja29-Apr-14 23:30
professionalthatraja29-Apr-14 23:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.