[AccessD] Executing Stored Procedures in a A2K ADP?

Hi Brett

Oops, missed that. I understood the choice was

 .Parameters.Append .CreateParameter("@RANum", adVarChar,adParamInput, 25)
 .Parameters("@RANum") = RANum

versus

 .Parameters.Append .CreateParameter("@RANum", adVarChar,adParamInput,
 25, RANum)

Need some beer.

/gustav


>> That's because you can't count while drinking beer at this Happy Hour
>> of Friday; it's 9 towards 8 - or at least 7 towards 6.

> Huh?!  Not counting the With blocks,

> He said :

> 1  Set com = New ADODB.Command
>    With com
> 2      .ActiveConnection = CurrentProject.Connection
> 3      .CommandText = "dbo.sp_DeleteRAs"
> 4      .CommandType = adCmdStoredProc
> 5      .Parameters.Append .CreateParameter("@RANum", adVarChar,adParamInput, 25)
> 6      .Parameters("@RANum") = RANum
> 7     .Execute
>     End With

> I said:

>     With CurrentProject.Connection
> 1       .sp_DeleteRAs RANum
>     End With

> Thus, 7 vs. 1 (or 9 vs. 3 with the blocks), and that doesn't count the code
> you need to dim the command object and destroy it afterwards.

> I'm sorry, who's been been drinking here? <vbg>


> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk]
> Sent: Friday, May 07, 2004 1:12 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Executing Stored Procedures in a A2K ADP?


> Hi Brett

>> Hmm...  This really is the first time I've heard multiple people saying that
>> 7 lines of code were easier to read than 1.

> That's because you can't count while drinking beer at this Happy Hour
> of Friday; it's 9 towards 8 - or at least 7 towards 6.

> /gustav