Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 



















ect
CursorType
Updatable Property of Connection Object
N/A
N/A

Methods :
AddNew
Cancel
CancelUpdate
Clone
Close
CopyQueryDef
Delete
Edit
FindFirst, FindLast, FindNext, FindPreviou
GetRows
Move
MoveFirst, MoveLast, FindNext, FindPrevious
NextRecordset
OpenRecordset
Requery
Seek
Update

Methods :
AddNew
Cancel
CancelUpdate
Clone
Set Rs = Nothing
N/A
Delete
A Recordset is updatable if the connection allows ir
Seek with option (adSeekFirstEQ, adSeekLastEQ...)
N/A
Move
MoveFirst, MoveLast, FindNext, FindPrevious
NextRecordset
Open
Requery, Resync
Seek
Update

Command and QueryDef

Using QueryDefs in Access permits the reexecution of queries and the use of parameters. The ADO equivalent is the Command. Here's how to move from QueryDefs to Commands.

DAO (for Jet)

ADO

Dim Qd As QueryDef

Dim Cm as New ADODB.Command

Set Qd = Db.QueryDefs("MyQuery")

Cm.CommandText = "SQL Query or Stored Procedure"

Property:
Connect
DateCreated, DateUpdated
LogMessages
Name
RecordsAffected
Replicable
ReturnsRecord
SQL
Type
Updatable

Property:
ActiveConnection
N/A
N/A
Name
N/A
N/A
Some values of CommandType
CommandText
CommandType
Updatable Property of Connection Object

Methods :
Cancel
Close
CreateProperty
Execute
OpenRecordset

Methods :
Cancel
Set Cm = Nothing
N/A
Execute
Open Method of a Recordset Object

Dim Pa as Parameter

Dim Pa as New ADODB.Parameter

Qd.Parameters(Name) = value

Set Pa = Cm.CreateParameter (Name, Type, Direction)
Pa.Value = value

Ou

Cm.Parameters.Refresh
Cm.Parameters(1).Value = value

Property:
Direction
Name
Type
Value

Property:
Direction
Name
Type
Value

In the next article, I will give you some examples of code transformation to speed up your migration and enhance the performance of your application.




MS SQL Archives

0 Comments (click to add your comment)
Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM