While Running the application through Setup it is not stroring the values in tables

Question

0.00/5 (No votes)

See more:

Hi,
I have one windows application and one web application through windows application inserting a quickbooks records to tables with the help of web application.

While running the application it is working fine and it strong the values into table but i created a setup for that windows application ,while running setup it is not storing the values in to table only one table values it storing, after that it will some exception like .
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__CustomerP__Class__618671AF". The conflict occurred in database "FISOFTSP", table "dbo.CustomerPortal_ClassCode", column 'ClassID'.

what is the pls help me for this one ..
Advance thanks.

Posted 6-Sep-12 20:39pm

BalaMahesh

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fixthebugg · Answer 1 · 2012-09-07T05:31:00

You are inserting wrong data.If the primary key column doesn't have this data , it is not going to accept it from insert statement. If you have SQL Server Management Studio, open it up and use sp_help to see which column that FK is on, and which column of which other table it references.

Also have a look on this..
http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/0ba0501d-bc2e-4afc-824e-b75f18a8b491/[^]

Vinod Viswanath · Answer 2 · 2012-09-07T08:17:00

Hello,

SQL

The error is pretty clear.

ClassID is in a foreign key relationship with another table, which does not contain the ID you are trying to insert. Insert the value in the dbo.CustomerPortal_ClassCode master table first, or check and correct the value you are inserting in ClassID in child table

Thanks!!!!!!!!!

While Running the application through Setup it is not stroring the values in tables

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0