RE: [AccessDevelopers] Re: ADO parameters for action query

Mon, 18 Jul 2005 14:34:03 -0700

What was the issue with the ADO code?
 

Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
713.583.7091 (F)



From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bryant
Sent: Monday, July 18, 2005 1:35 PM
To: [email protected]
Subject: [AccessDevelopers] Re: ADO parameters for action query

Hi Dawn,

I'd just gotten that to work before you posted that!  :) It's more
lengthy than DAO, but at least it works.

I'll post something I was doing with ADOX and which failed silently,
to see if I can get some guidance on it ... maybe the prob with
different values being returned from ADO and DAO will solve that one
as well.

Thanks,
Bryant

--- In [email protected], "Crosier, Dawn"
<[EMAIL PROTECTED]> wrote:
> I am able to use this type of code for a parameter query in SQL
> 
> Dim cmd As ADODB.Command
> Dim rst As ADODB.Recordset
> Set cmd = New ADODB.Command
>
> 'Retrieve all the Customers associated with a specific Client
> With cmd
>     .CommandText = "qryClientAddress"
>     .CommandType = adCmdStoredProc
>     .ActiveConnection = CurrentProject.Connection
>     .Parameters.Append .CreateParameter("@ShortCaseCaption", adVarChar,
> adParamInput, _
>     100, strShortCaseCaption)
>     Set rst = .Execute
> End With
>
> I don't know if it will help you or not, but.....
> 
> Dawn Crosier
> Application Specialist
> "Education Lasts a Lifetime"
>
>
> ________________________________
>
> From: [email protected]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tom Oakes
> Sent: Monday, July 18, 2005 2:21 PM
> To: [email protected]
> Subject: RE: [AccessDevelopers] Re: ADO parameters for action query
>
>
> Yeah, I'm having the same problem when testing this.  I tried manually
> appending the parameter object, but it doesn't seem to take it.  If you
> can get around using the saved query, you can do it in ADO by building
> your SQL statement and using adCmdText.  If not, I'd stick with DAO or
> ADOX, assuming they get the job done.
> 
> What does your ADOX code look like?
> 
> Tom Oakes
> Personal PC Consultants, Inc.
> [EMAIL PROTECTED]
> 503.230.0911 (O)
> 402.968.6946 (C)
> 713.583.7091 (F)
>
>
>
> ________________________________
>
> From: [email protected]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bryant
> Sent: Monday, July 18, 2005 12:00 PM
> To: [email protected]
> Subject: [AccessDevelopers] Re: ADO parameters for action query
>
>
> That gave an error 3265 (Item cannot be found in the collection
> corresponding to the requested name or ordinal.) It makes sense to
> have tried that, since it's the way to do it with SQL Server. Having
> gotten that error previously, and being stuck on the
> adCmdStoredProc/adCmdText area, is where I headed out to ADOX.
>
> Bryant


Please zip all files prior to uploading to Files section.


YAHOO! GROUPS LINKS



Reply via email to