1 / 8

The Tip of the ADO-burg

The Tip of the ADO-burg. Francisco H Tapia. Command Connection Error Parameter. Property Record RecordSet Stream. Ado Objects. Who’s your provider?. Connection providers…. OLEdb providers JET SQL TEXT XML mySQL Etc…. What’s in a command?.

zamir
Download Presentation

The Tip of the ADO-burg

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Tip of the ADO-burg Francisco H Tapia

  2. Command Connection Error Parameter Property Record RecordSet Stream Ado Objects

  3. Who’s your provider?

  4. Connection providers… • OLEdb providers • JET • SQL • TEXT • XML • mySQL • Etc…

  5. What’s in a command? • Excute stored procedures or queries where a result is not expected back • .Execute , , adExecuteNoRecords • Pass multiple parameters • .Parameters.Append .CreateParameter("CompanyName", _ adVarWChar, adParamInput, 50, sCompanyName) • .Parameters.Append .CreateParameter("ContactFirstName", _ adVarWChar, adParamInput, 30, sContactFirstName) • .Parameters.Append .CreateParameter("ContactLastName", _ adVarWChar, adParamInput, 50, sContactLastName) • Receive a return a single pice of data instead of a recordset… •     .Parameters.Append .CreateParameter("RETURN_VALUE", _ adInteger, adParamReturnValue, 0) •     ' Print new identity value Debug.Print .Parameters("job_id").Value  ' New Identity http://www.able-consulting.com/ADO_Faq.htm

  6. Recordsets… • Conn.stp_MyStoredProcedure Param1, rs • Store Access queries in MDB BE • Create an updateable recordset on the fly OR • Use the Command object to execute the procedure. • Set rs = cmd.execute

  7. Dispelling myths…

  8. LINKS!!! • http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadoprogrammersguide.asp • http://www.able-consulting.com/ADO_Faq.htm • http://www.devguru.com/technologies/ado/quickref/ado_index.html • http://www.vbsquare.com/databases/begado/\ • www.google.com

More Related