Results 1 to 5 of 5

Thread: Stored Procedure ? double parameters

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2007
    Posts
    4

    Red face Stored Procedure ? double parameters

    Hello guys;
    I am Turkish people. Why ? Because my question is not %100 english language ok?

    Now my question..

    i'm using VB6 and database is MSSQL

    my Stored Procedure is
    Code:
    create procedure dbo.AracYuklemeProc 
    @personel varchar(10),
    @guntarih datetime
    AS
    SELECT     SUM(hesaptoplami) AS AracPerToplam, perkodu, tarih, SUM(ISNULL(paramiktari, '0')) AS ToplamTutar,
    SUM(ISNULL(personelbakiye, '0')) AS PerKalan, 
                          SUM(ISNULL(tutar, '0')) AS BorcTutar
    FROM         dbo.AracYukleme
    WHERE     (hesapkapat_flag IS NULL) and perkodu=@personel and tarih=@guntarih
    GROUP BY perkodu, tarih
    GO
    
    tarih =date
    perkodu=personel code
    hesapkapat=close the acount
    others is others :-)
    now..

    in VB DAtaenvironment name=Sigara
    connection(OBDC) name = baglanti
    commandname=AracYukle

    tarih from -> dtpicker1.value
    perkodu from ->text10.text

    and Question

    how can i this procedure (double parameters) use in my forms

    Please.. I need your help ?

    Pardon .. VB to MSSQL Database connection
    ADODC1 (ODBC)
    Last edited by Hack; Nov 25th, 2007 at 04:40 AM. Reason: Added Code Tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width