I am working on a database with about twenty tables. In one of the tables "Customers" their is a column with
a primary key. Call it "CustomerNumber".
The problem is that we log customers from multiple vendors and so we might have the same customer number, but from different vendors. So really this would be a perfect situation where we could set up the primary key to be a composite key consisting of the Vendor and CustomerNumber combination.
The integrity of the database is not very well maintained because the Primary Key CustomerId is never used as a secondary key in any of the other tables.
So here is my question. Instead of making a primary composite key, can I just drop the primary key all together?
This is one of those questions I really hate to ask, because typically I would never lean tword this drastic of a measure to solve a problem. Because of other situations I can't discuss this might be the best alternative. So would it be okay to drop the primary key constraint all together?
I need to copy the records of a row to the next available row in the same table. I tried with "Insert ...Select " but it throws me a error since the pk is auto-increment. Also, i cant specify each and every column inside the insert...select statment cause i've almost 30 columns.
I am a rookie developer here and I have tried looking around for an answer but I am little confused. I have a stored procedure that calls multiple stored procedures when I go to create a new contact.[Code]....
I though I could use the OUTPUT Command to copy out the NewContactID but I am getting all kinds of syntax errors. I am confused as to what I am missing here.
There is one table which primary key is ID and its data type is Integer with auto increment. Gradually the value has increased and I want to change it to hold large amount of value.
So, Which in data type I have to change from Integer without effecting the previous values?
i get the following exception (missing primary key) in the line of using Find() method "Table doesn't have a primary key." I've rechecked the Database and all Primary Key columns are set correctly.
DataTable dt = p.GetAllPhotos(int.Parse(Id)); DataTable temp = new DataTable(); temp = dt.Clone(); temp = (DataTable)(Session["currentImage"]); DataTable dtvalid = new DataTable(); dtvalid = dt.Clone(); DataRow[] drr = new DataRow[1]; drr[0] = dt.Rows.Find((int.Parse(temp.Rows[0]["photoId"].ToString()))+1); foreach (DataRow dr in drr) { dtvalid.ImportRow(dr); } dtvalid.AcceptChanges();'
In the database one number like a 91-9685748596 and, 2nd number like 9122-9685748596 and another one is 9685748596 .when we are try to formate it using substring function it all are may be9685748596,9685748596,9685748596.Mobile number is assigned as a primary key.so its showing error "Primary key violation".We can not the remove primary key also and there are 50 lack data in our database.
How can we map a table without having primary key in nHibernate.I have a table which does not contain any primary key, so how can i map this table in .hbm.xml file.
I have a table with composite primary key and this key includes two values referring to two other tables. Now I need to implement Edit feature for this Original Table but I wanted to have dropdown lists while editing pointing to look up tables(composite key values are primary keys for two lookup tables). for eg.
I have a data connection to an existing MySQL database. The database has various tables. I am creating a new table, and want to set the ID field to be the primary key. I can not see a way of doing this inside Visual Studio. I saw one suggestion to right click on my ID field in either the Server Explorer or XSD and select Set As Primary Key (or something like that), but I don't have that option displayed.
I have a table that get populated via an external text file. I am not sure of the exact process as I'm relatively new to the company.
The table does not have a primary key as the entire table is dumped and re-loaded every quarter when there is a new text file.
Enter ASP.NET MVC. I need to display that table with checkboxes in a grid so the user can select some rows and send it back to the server. It sounds relatively easy, but I am really not sure what to put as the value for the checkboxes as I am pretty sure I'll need to use multiple columns to create a unique. Yep, I know, I know :).
Would something like this work? If I can create a key with a few fields, can I use those fields as the value in the checkbox? I realize my action will be a bit ugly as I'll have to split and parse each value in the array of values.
Using a very run-of-the-mill database, with identity int for primary keys, a Dynamic Data Entities Project (EntityFramework) displays the primary key for view and edit. When using Linq to Sql, the primary key fields are not displayed.
I would like to hide the primary keys and use Entity Framework (VS 2008, .Net 3.5 sp1).
I need to pass some info to a 3rd party (for tracking) and they require I provide a checksum value which is an md5 hashed amalgamation of some of the other values. This is my code :
[Code]....
They keep rejecting my checksum. When I have tested for the following value passed in preConvert - 300265215063.79 I get :
My code gives : ED4463C84DE9D21B54C4E62F2D72CE
An online MD5 hash gives : 0ed40463c84de9d21b54c4e62f2d72ce
Which apart from the case, is exactly the same apart from missing 2 zeroes.
I am currently working on an ASP.NET v4.0 project using VB Script for the server-side code. I have a number of session variables that I am using across multiple pages. My problem is that although I have set the session timeout to be 20 minutes or longer (programmatically, in Web.Config, and IIS), the Session variables are being dumped after exactly 2 minutes.
Web.config contents:
Code:
Session_Start routine:
Code: Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs) ' Fires when the session is started Session.Timeout = 1200 ' Setting to a very high number to ensure that whatever timeout value is set in IIS *should* stick Session("VariableNames") = VariableValues ' ... multiple values here End Sub
After exactly 2 minutes (120 seconds) from the last refresh, all the values retrieved using Session("") are blank. Here are a few screen caps to show the IIS settings.
Additionally because of this problem, I have created a generic dummy handle page called KeepSessionAlive.ashx and the following javascript is called using setInterval(KeepSessionAlive, 10000); (every 10 seconds) and I have confirmed that it is working, but the Session variables are still being dumped.
Code: function KeepSessionAlive() { //alert('testing'); $.post("KeepSessionAlive.ashx", null, function () { $("#result").append(" Session is alive "); }); }
Am I missing something? Why is it dropping my Session values?
