|
-
Nov 25th, 2007, 04:13 AM
#1
Thread Starter
New Member
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
-
Nov 25th, 2007, 04:40 AM
#2
Re: Stored Procedure ? double parameters
Moved to Database Development
-
Nov 25th, 2007, 05:45 AM
#3
Thread Starter
New Member
Re: Stored Procedure ? double parameters
ok. i'm happy for read my post. but ask ? because i need your help
-
Nov 25th, 2007, 05:51 PM
#4
Re: Stored Procedure ? double parameters
I tried to comprehend what you are asking but I cannot.
Please try to reword what you are trying to accomplish. Don't write a book - a couple of sentences to see if we can better communicate.
-
Nov 26th, 2007, 11:31 AM
#5
Thread Starter
New Member
Re: Stored Procedure ? double parameters
ok. i'm not writing this message, you to think. Thanks All.
but i want to just help. if you dont understand my message. you can write "i dont understand your messages, more explanation".
but! no problem. thanks all again..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|