Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Debt stored procedure

    OK...You are exactly right...I have reorganized parantheses and problem solved...

    Thank you very much..

  • RE: Debt stored procedure

    Thank for your attention.

    The original code is like this:

    ------------------------------------------------------------------------

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_NULLS ON

    GO

    ALTER       PROC ml_goldEntrance2

     @FISNO int,

     @HESAP_NO int,

     @TARIH smalldatetime,

     @SATIRNO int,

     @STOK_KODU varchar(15),

     @STOK_KODU2 varchar(15),

     @GIRILEN_MIKTAR decimal(9),

     @GIRILEN_MILYEM int,

     @GIRILENISCILIK float

    AS

    BEGIN TRAN

    INSERT INTO Islem_ana (fisno,hesap_no,tarih,satirno,islem_kodu,stok_kodu,stok_kodu2,miktar,tutar,hasborc)

      VALUES(@FISNO,@HESAP_NO,@TARIH,@SATIRNO,'AG',@STOK_KODU,@STOK_KODU2,@GIRILEN_MIKTAR,(@GIRILEN_MIKTAR*@GIRILENISCILIK)

    UPDATE Islem_ana

    set...

  • RE: connection string problem

    Thanks for your attentions...

    I have solved the problem by using "\\" instead of "\"

    I have also modified by connedtion string with all of your guidance as follows:

    --------------------------------------------------------------------

    public

    ...

  • RE: connection string problem

    Thanks for your reply.But When I put a semicolon then I will get the same error message:

     

    -----------------------------------------------------------

    public

    static string connectionString...

Viewing 4 posts - 1 through 4 (of 4 total)