Good day, I having a problem where creating my setting table as condition below column User_id setting effective_date effective_end_date Row 1: 1 ABC 2017-03-01 2018-02-28 Row 2: 1 DEF 2018-03-01 2019-03-01 I wish to add a constraint to block if same user add in a setting with the effective_date or effective_end_date between existing setting. Is that posible? I had searching and trying for a few days now without succeed to archive what I trying to do. Please kindly guide me through this. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 1

I want my combo box's value to be .Items[i]. Item is of type DataRowView. My combo boxes are binded by database. Value member of cmbx is IDplayer in database. Selected value is playersBindingSource - IDplayer. This is the error: Column 'IDplayer' is constrained to be unique. Value '2' is already present. //cmb = Combo Box; //cmbPlayers = Binding List of combo boxes int i = 0; foreach (ComboBox cmb in cmbPlayers) { cmb.SelectedItem = cmb.Items[i]; // ERROR HAPPENS i++; }

Member Avatar
Member Avatar
+0 forum 3

This is homework. I have to create two tables with certain constraints. However, I keep getting syntax errors, and I really have no clue exactly how to format it because there are so many different 'templates' out there. Here is what I have so far. [CODE] create table Departments (Department_ID number PRIMARY KEY, Dept_Name varchar2(25) NOT NULL UNIQUE, City varchar2(50) NOT NULL, Budget_Code char(5) NOT NULL UNIQUE, Mailstop char(3) NOT NULL);[/CODE] The constraints are in all caps. Also, I need to know how to do multiple constraints. Can someone help me on this? The second table I have:[CODE] create table …

Member Avatar
Member Avatar
+0 forum 3

I would like to know if I drop a constaint on a column whether Oracle will automatically change other constraints that involve that column? The reason I ask is because for two days in a row when I dropped constaints on a column that related constraint had the very same field removed. I asked the db admin if this is possible and she says no, but I don't see any other explanation for the changes. If it is possible I would appreciate a source I could read in order to see what the rules are.

Member Avatar
Member Avatar
+0 forum 1

The End.