Click here to Skip to main content
15,882,315 members

Comments by apple blue (Top 12 by date)

apple blue 4-Jun-15 23:07pm View    
What kind of language do you speak? Weird
apple blue 29-May-15 4:35am View    
Oh, now I know. Thanks for your explanation Advay Pandya =)
apple blue 29-May-15 2:05am View    
Ouh yaa ! Thanks a lotttttt for helping me =)
apple blue 29-May-15 2:05am View    
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
apple blue 27-May-15 20:49pm View    
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.