Re: Foreign key constraints problem in SNC SQL Native client

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.
--
Charles Calvert             |  Software Design/Development
Celtic Wolf, Inc.           |  Project Managementhttp://www.celticwolf.com/ ;|  Technical Writing
(703) 580-0210              |  Research

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. 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?
Please help me
.

Relevant Pages

  • Re: Foreign key constraints problem in SNC SQL Native client
    ... calling one stored procedure before calling dw_1.update method. ... stored procedure system is trying to delete parent data from Table A. ... rows from table B before deleting the related rows from A. ...
    (microsoft.public.sqlserver.connect)
  • Re: DBD::Sybase and $sth->{syb_result_type} v. DBD::ODBC (Sql Server)
    ... write output parameters and return a value. ... individual operations in the procedure by calling odbc_more_results. ... Things get a little more complex for what I guess Sybase calls CS_MSG_RESULT ... the status from a stored procedure was ...
    (perl.dbi.users)
  • Re: xplog70.dll
    ... What extended stored procedure are you calling from ... >I have a job that executes a DTS-package which in turn call a store procedure ...
    (microsoft.public.sqlserver.security)
  • Re: ntext/>8K as OUTPUT param
    ... You can create a temporary table in the calling stored procedure, ... > very complex and needs to EXEC some sql which cannot be done in a UDF. ... > I have found some references to calling a COM .dll using sp_OA*, ...
    (microsoft.public.sqlserver.programming)
  • Re: Best practice
    ... > Best coding strategies for calling stored procedures from ASP.NET. ... > objOracleParameterSTATUS = new System.Data.OracleClient.OracleParameter ... > So on the whole we are setting 9 properties for a single parameter and if ... > this stored procedure accepts 10 parameters, then this process has to be ...
    (microsoft.public.dotnet.framework.aspnet)