SQL Server :: Relationship Which Allows NULL Entry / Error 'FK_Table_Contracts_Table2_PONo' On Table 'Table_Contracts'?
Nov 29, 2010
I have two tables as below.
I tried to establish a relation between two tables in such a way that Table_Contracts will still accept NULL values for [PO_No], but [PO_No] on TableContract will be automatically updated when [PO_No] on Table2_PONo changed. Moreover, if you want to delete a record on Table2_PONo, it needs to be stopped if there is a related data in Table_Contracts.
I set a relation with these parameters:
Check existing data on creation or re-enabling>
No
Enforce for replication>
No
Enforce foreign key constraint>
No
Delete Rule>
No Action
Update Rule>
Cascade
I got this error
Introducing FOREIGN KEY constraint 'FK_Table_Contracts_Table2_PONo' on table 'Table_Contracts' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Table2_PONo
[PO_No]
(primary key)
[Project_ID]
[SupplierID]
[Description]
[TotalPrice]
[PO_Currency]
[VATpercent]
[CostCode]
[Notes]
[PO_Date]
[Reality]
[UpdatedBy]
[FromAccess]
Table_Contracts
[ContractID]
[ProjectID]
[PO_No]
(accepts null values)
[ContractNo]
[ContractDate]
[ContractValue_woVAT]
[ContractCurrency]
[SupplierID]
[ContractDescription]
[ContractType]
[LinkToTemplatefile_DOC]
[SentToSupplier]
[SignBySupplier]
[SignByMercury]
[CollectionBySupplier]
[LinkToPDFcopy]
[ArchivedByMercury]
[UpdatedBy]
[Retention]
[Note]
View 2 Replies
Similar Messages:
Mar 17, 2011
i m developing an inventory module in which i have a GRN(Goods Received Note) form, the user opens the form and enter the items which are coming from itemMaster table. I want to add the grn entry in a table named GRN and all its respective item details in other table and also want to update the instock quantity in item Master table. how can i achive this there are multiple items in a grid in grn form which are to be stored in a table and only 1entry of grn in grn table and also update the instock Qty in the itemMaster Table,,...i ned write my logic using Stored procedures and ADO.NET i m totally confused
View 1 Replies
Oct 15, 2010
I have 2 tables:
- Salesmen with Pk.SalesmenID
- Appointments with Fk.SalesmenID and busy(bit)
How can I check if every salesmen has at least one appointment
Am I on the right way with statement below, though I got syntax problems
[Code]....
View 5 Replies
Oct 29, 2010
I have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
View 5 Replies
Mar 17, 2011
I've just taken over looking after a website and well to be honest the way it's been put together is not the best, but I have to make do as the client does not have the money to make major changes.Anyway currently there is data stored in a MsSQL database and some in an XML file. The xml file does have a ContentID attribute which matches the ContentID in a table.Not really done much with XML as I tend to use a database and LINQ.What would be the best way to tie these two together so I could output the results in a gridview for example.
View 2 Replies
Oct 2, 2010
I have 2 table Table A, Table B.
Table A - Parent Table
ID - Uniqueidentifier not null(PK)
Table B -Child Table
ID - uniqueidentifier null(FK, TableA)
I have a stored procedure to insert data into Table B, but when I tried to insert a null value into column ID of table B, this error came up:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableB_tableA". The conflict occurred in database "database name", table "table A", column 'ID'.
The statement has been terminated.
The insert statement in asp.net is like so:
sqlcommand.parameter.add(New Sqlparameter("ID", Nothing))
I am guessing adding nothing to the null value column is the problem, but i don't know how to fix it... The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableB_tableA". The conflict occurred in database "database name", table "table A", column 'ID'.
View 5 Replies
Jul 29, 2010
if It is okay to delete entry directly in any aspnet_* table ? because i screwed something.
View 3 Replies
Sep 9, 2011
i made an upgrade to an existing application (still developed by me), while testing on my development machine, everything worked fine. After migrating to a Test Server(windows 2003 server), users can not test the application, it periodically crashes their session and redirected them to the login page (Forms Authentication). No error is generated and no entry is logged in the windows event veiwer on the server. I also noticed this also happens when they try to access a particular page in the application.
The page contains 50 instance of a user-control. Each of the user-control contains 8 textboxes, 2 labels,1 hidden field and 12 asp.net validation controls. I tried saving a copy of this page from Internet explorer (IE8) on my development machine,its about 2.2MB in size.What may be wrong and what tracing tools can i use on my development machine (since it generates no errors). How can i also reduce the size of the page (noting that the asp.net validation controls generated alot of HTML codes)
View 4 Replies
Jan 19, 2011
How to make the linq throw error, when not null columns are there in the table.
Why I am saying, it is. I tried to add to column in the table. Linq throwed error os some sort. I could not understand. it was like some innner table etc.
I had to resort to native sql, which showed the error, as the not null fields are there in the table.
View 5 Replies
Apr 8, 2010
how can i insert 'null' value in numeric column if no record is there.when i pass record to BLL like
MyCollegeAddmissionMst.GraduationYear = IIf(txtGrdyear.Text = String.Empty,
"", txtGrdyear.Text.Trim())
datatype is numeric(4,0) then error is Conversion from string "" to type 'Integer' is not valid. no record is in this textbox and i need to entry null value.so how can i do the same.
View 27 Replies
Feb 15, 2010
I think I'm just after advice on best practice with this! I have a database which has 2 tables. The first table has ID, Name, Address and the second table has ID and JobType. Table 02 can list multiple types of JobType so we could have
Table01:
1. D Smith. Address01
2. S.Jones. Address02
Table02
1. Accounts
1. Sales Ledger
1. Chartered Accountant
2. IT
2. Web Design
2. Graphic Design
2. 1st line support
A join gets them together and all works perfectly.However, the content will be updated when some one fills in a web form. Do get the form to send results to both tables, I assume I have to open the database twice or can I open it once and open each table one at a time? I know I could practice this and not ask the question but I am interested to know what is the most efficient way. I would also need to know what ID to use. So when I populate Table02 it uses the correct ID from Table01. At the moment Table01 ID field is incremented automatically. Would you suggest I always assign the ID myself, or would I need to query the database, find out what ID number is currently in use and then increment it by 1 and assign the new number to an ID variable which then populates the Table's Field? In which case, am I opening the database again or trying to perform all 2/3 stages in one go?
View 3 Replies
Apr 18, 2010
I working on website and i have ready database from the company database. I have a table Location has only two fields : city andtate.I tried to get select the * city where state = something , but i think it is wrong,Is it a Many-to-Many realtionship
View 4 Replies
Jun 26, 2010
I have my membership provider configured and working on my web host.
I´d like to create a table, for example, table ARTICLES, and i´d like that the user logged in, his ID or his NAME, was inserted into my ARTICLES database.Which one is the best table i could get for doing that ?
I was checking the table aspnet_users, but its Primary Key has a uniqueidentifer type.This won´t be a problem in the future ?Or is there a better way to relate my table with the membership provider ? Maybe another table OR another field.
View 1 Replies
Oct 29, 2010
I have this table structure, and I can pull ot all I want like product details, color, size and so on. Now I want it to work like this. When I select a color only sizes avalible in that color should be returned from the database, and same thing when I select a size only colors avalible for that size should be returned. NOw it works like price and quantity sets to zero, but it should have been better if it was impossible to choose a combination that don't exists.
Then I have one more. SizeId and ColorId can be null in db. That is not good when I try to receive those rows.
[Code]....
View 12 Replies
Jun 4, 2010
I want to be able to display the entries in this table based on the date and time of recorded in the entry.
So as an example:
Entry A only appears on Mondays at time X.
Entry B appears on Tuesdays at time X and Sundays at time X.
Entry C appears every day of the week at time X.
Entry D appears every day of the week but twice on each day at time X and y respectively.
View 2 Replies
Feb 12, 2010
I have a control that renders different children according to a property value. All works great until I add a rating control in the mix. I get the following:
Page cannot be null. ensure that this operation is being performed in the context of an ASP.NET request.
[Code]....
View 4 Replies
Jul 29, 2010
Is it possible to setup the CreateUserWizard to check for a duplicate entry in the aspnet_profile table (for a custom field) before the new user is created? For example, if I added a phone number field and wanted to make sure nobody else could create an account using that same phone number if a user already has an account with that phone number in the aspnet_Profile table's PropertyValuesString row?
View 10 Replies
Dec 17, 2010
i am working with multiple table with some same columns, so here i want to use the concept of primary key and foreign key.primary key is very easy to put on any fields but, i dont know how to give foreign key and how to create relationship between same fields of two table.
View 2 Replies
Mar 18, 2011
I've used aspnet_Profile and I add new values​​. In the field "PropertyNames" I added value "DomainId". In the field "PropertyValuesStrings" I added value I get from the table "tbl_Domain.
How do I connect aspnet_profile table, column "PropertyValuesStrings"with tbl_Domain, column 'Id' primary key.
View 1 Replies
Oct 11, 2010
I've been working on this project which requires me to insert data into a database. Due to the complexities of the function that I am doing, it is more complex to use SqlDataSource and hence I've used the traditional method of inserting to the database. The codes are as follows:
[Code]....
I am not too sure why, but even though I've debugged numerous times and the data gets inserted into the database through the form view, I get this error on the page after everything is executed: Cannot insert the value NULL into column 'reviewDate', table 'ProrsumDB.dbo.Review'; column does not allow nulls. INSERT fails. The statement has been terminated. reviewDate wasn't null when I tried and there are no exception thrown.
View 13 Replies
Jan 22, 2011
The following datatype or size property of <Tablename>.<Columnname> doesn't match <Tablename>.<Columnname>. When creating a foreign key relationship, the data types and other properties of selected columns must match. Select a column with the same data types and other properties as the related column. The properties that must match are Data type, Length, Precision, Scale, and Collation.
I am trying to add a constraint to my database and I keep get the above error. I can find Data type, length, and Collation in the properties. What are precision and scale in this context. I don't see such settings. Specifically I am trying to add a relationship from the aspnet_Membership table to a table that I added. I have put a relationship on aspnet_Users.UserName to another table, so I am baffeled.
View 1 Replies
Aug 7, 2010
I am using SSRS 2005 and Windows Server 2003, when i try to access my SSRS report from Direct url i.e from browser it is shown but if i try to access it from asp.net page through report viewer it displays "Entry point was not found." Error Message.
some days before it was working properly.
I have also reinstall OS and SSRS.
Please tell me the solution if any body faced the same issue or somebody knows the problem.
View 1 Replies
Oct 25, 2010
One day I was developing my MVC app in Visual Studio 2010 and my computer crashed (flaky hardware - now fixed).But ever since then,in my app,whenever I have a view page or control editor up, the <%@ Page ... %> statement was squigley-underlined in blue with an tool-tip error message like:
/.../page.aspx: ASP.NET runtime error: Could not load file or assembly 'StructureMap, Version=2.6.1.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxx' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT:0x80070057 E_INVALIDARG))
I deleted and re-added the reference to StructureMap in the References in the solution explorer,deleted and re-copied the actual StructureMap DLL, but the error doesn't go-away.I deleted the output directories and rebuilt,but still have the problem.
The application still builds and runs okay, but while in the editor, though I continue to have IntelliSense for the HTML stuff,for any C# code inside <% %>'s, the IntelliSense is gone.
If I copy the application tree to another disk or directory,or rename the root directory to a different name,the problem goes away.But if I use the same name or disk,the problem appears.Maybe it's some corrupted registry entry?
View 3 Replies
Nov 17, 2010
I am creating a sql server database table and when i save the table and give the name to a table "i.e. USER" and then see in the property of that table then the name changes to "[USER]". I have tried lot of time but every time it gets.Plz help mei am also attaching the screen shot of this.
View 4 Replies
Mar 31, 2011
I have a confusing question, I have a user table and it stores all the usual data for a user that you would expect but im trying to figure out how a user could add another user?
Sounds strange but each user in the User table has his own UI which is UserID how could I add another table where UserID can have a relationship with another UserID?
i.e how would I right the syntax for the above question if I wanted to display all the UserIDs friends on a page. How would I add a friend.
View 4 Replies
