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
now..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 :-)
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)




Reply With Quote