Re: Foreign key constraints problem in SNC SQL Native client
- From: Charles Calvert <cbciv@xxxxxxxxx>
- Date: Fri, 04 Apr 2008 18:26:12 -0400
On Tue, 1 Apr 2008 06:48:37 -0700 (PDT), brijeshjmishra@xxxxxxxxx
wrote in
<f858477a-396e-4639-b5d7-fe3206b5a1fb@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>:
On Mar 28, 7:21 pm, Charles Calvert <cb...@xxxxxxxxx> wrote:
On Tue, 25 Mar 2008 22:07:22 -0700, Brijesh Mishra
<brijeshjmis...@xxxxxxxxx> wrote in
<#S9AH9vjIHA.4...@xxxxxxxxxxxxxxxxxxxx>:
Can you please help me to out from this problem?
You've posted it on the wrong group. This group is for connection
issues, not data issues. I suggest that you repost in a more
appropriate group.
Problem detail:
We have two table A and B (e.g.). Table A is parent of Table B. In PB,
system deleting one row from table B using datawindow control, who
parent data present in Table A and in the same transaction system is
calling one stored procedure before calling dw_1.update method. In that
stored procedure system is trying to delete parent data from Table A.
We are getting referential integrity error since we started using PB 11
with SNC SQL Native client. It was working fine upto PB 9.0 version.
Okay, what is "PB"? PowerBuilder? You should post this in a group
for the tool that you are using, since it sounds like it might be
related to that. I will tell you, however, that you must delete the
rows from table B before deleting the related rows from A.
I think, I would not give clear idea about this issue. let me puting
it in differant way.
As I mentioned in my first post, in same scenario the application is
running in PB 9 with MSS driver.
What is "PB"? You haven't answered that question. Even if you do
answer that question, you're still posting in the wrong group. This
is a problem with the tool you're using, not a problem connecting.
I have migrated same code in PB 11, I
am getting error message as i have mentioned above. could please let
me whether any Parameter is required set so that this issue get solve?
I have no idea. I still don't know what PB is, and I have no idea
what parameter you're talking about. You can't delete the parent
records until all children have been deleted. As Scott pointed out,
this can be handled by the RDBMS in several ways (triggers, cascading
deletions, etc.), but you still need to ask people in the right place.
They're much more likely to know the answer.
--
Charles Calvert | Software Design/Development
Celtic Wolf, Inc. | Project Management
http://www.celticwolf.com/ | Technical Writing
(703) 580-0210 | Research
.
- References:
- Re: Foreign key constraints problem in SNC SQL Native client
- From: brijeshjmishra
- Re: Foreign key constraints problem in SNC SQL Native client
- Prev by Date: Re: Using SQL Server Express on Shared PC
- Next by Date: Re: Connecting to MS SQL Express from other PC
- Previous by thread: Re: Foreign key constraints problem in SNC SQL Native client
- Next by thread: Re: Connection Established Successfully..Error during the log proc
- Index(es):
Relevant Pages
|
Loading
