passing parameters

Tue, 19 Sep 2006 22:01:43 -0700

can someone help me on passing parameters to stored procedures in MSAccess using VB6?

for example, i have a stored procedure named "Addrec", which functions for inputting data. if i have parameters: name, address and email.. how can i do it in vb6 code using ADODB.. here are my incomplete sample of codes:

dim cnxn as new ADODB.connection
dim cmd as new ADODB.command

cnxn= (* connection string to database...... *)
cnxn.open

set cmd.ActiveConnection=cnxn

cmd.CommandType = adCmdStoredProc
cmd.CommandText = "Addrec"

'-----------------------------------------------------
* passing of parameters could be right here *
'---------------------------------------------------

cmd.Execute

--- thanks a lot!!!! ;p

Re: passing parameters

Tue, 21 Nov 2006 15:09:27 -0700

: can someone help me on passing parameters to stored procedures in MSAccess using VB6?
:
: for example, i have a stored procedure named "Addrec", which functions for inputting data. if i have parameters: name, address and email.. how can i do it in vb6 code using ADODB.. here are my incomplete sample of codes:
:
:
: dim cnxn as new ADODB.connection
: dim cmd as new ADODB.command
:
:
: cnxn= (* connection string to database...... *)
: cnxn.open
:
: set cmd.ActiveConnection=cnxn
:
: cmd.CommandType = adCmdStoredProc
: cmd.CommandText = "Addrec"
:
: '-----------------------------------------------------
: * passing of parameters could be right here *
: '---------------------------------------------------
:
: cmd.Execute
:
:
:
: --- thanks a lot!!!! ;p
:
:
hi,
you can search for your request at www.softricks.5u.com

'passing parameters' Thread RSS Feed

passing parameters

Re: passing parameters