Comments by apple blue (Top 12 by date)

Oh, now I know. Thanks for your explanation Advay Pandya =)

Ouh yaa ! Thanks a lotttttt for helping me =)

Hi Advay Pandya :)

Thanks! Your solution works :)

Both this query can be used on my program. I've alter my query and also try your given query. Both works :)

But for my query, i've alter to do this query :

SELECT M_C FROM [dbo].[TPATH]
WHERE M_C IN (SELECT M_C FROM [dbo].[TTENS])
and M_C = @M_C

Hi Sascha Lefèvre and ArunRajendra Smile ! :)

This code are use for manage my database transactions.

Hide Copy Code
Dim DHHConn As New DRConnection("", "")

Actually, i has another class namely as DRConnection that stored all the function for this DRConnection to open and close the connection. I don't has any idea where to fixed this error.

Actually, this program works like this :

1. user will choose path ID (retrieve all this data from table TPATH) that they want to delete.

2. before the path ID would be delete, it will compare this path ID from table TTENS of database SDO and table TPATH of database SDO where this two table share the same column namely as M_C.

3. this comparing method was write in Stored Procedure(SP).

Hide Copy Code
CREATE PROCEDURE [dbo].[sp_Path_ID] @M_C varchar(20)

AS
BEGIN
SELECT M_C FROM [dbo].[TPATH]
WHERE M_C NOT IN (SELECT M_RTE_C FROM [dbo].[TTENS])
and M_C = @M_C
END

and here the line where i'm call my SP

Hide Copy Code

ds = DHHConn.RunSPReturnDS("sp_Path_ID", New SqlParameter("@M_C", DeletePathID)


4. after done compared, then if path ID that user choose are not in table TTENS so, the path ID can be delete. But if path ID choose by user are in table TTENS, so the path ID cannot be delete.

example :

[IMG]http://i59.tinypic.com/10ct029.png[/IMG]

My problem now :

1. i'm not be able to compare this data
2. i get this error Fill: SelectCommand.Connection property has not been initialized.