秋月巌ソリューション事務所
秋月 巌 AKIZUKI,Iwao
| Microsoft Access 2000 |
|---|
| ベータ版の悲劇は起こるのか? |
|---|
| 今回はテスト専用環境で… |
|---|
| 最大のトピックはWeb対応 |
|---|
| しかし、Access 2000のC/S開発対応はすばらしい |
|---|
| 旧バージョンは何が問題だったのか? |
|---|
SELECT titles.title, publishers.pub_name FROM publishers INNER JOIN titles ON publishers.pub_id = titles.pub_id
SELECT "dbo"."publishers"."pub_id","dbo"."titles"."title_id"
FROM "dbo"."titles","dbo"."publishers"
WHERE ("dbo"."publishers"."pub_id" = "dbo"."titles"."pub_id" )
go
SELECT "pub_id","pub_name"
FROM "dbo"."publishers"
WHERE "pub_id" = '1389' OR "pub_id" = '1389'
OR "pub_id" = '0736' OR "pub_id" = '1389'
OR "pub_id" = '0877' OR "pub_id" = '0877'
OR "pub_id" = '0877' OR "pub_id" = '1389'
OR "pub_id" = '1389' OR "pub_id" = '1389'
go
SELECT "title_id","title","pub_id"
FROM "dbo"."titles"
WHERE "title_id" = 'BU1032' OR "title_id" = 'BU1111'
OR "title_id" = 'BU2075' OR "title_id" = 'BU7832'
OR "title_id" = 'MC2222' OR "title_id" = 'MC3021'
OR "title_id" = 'MC3026' OR "title_id" = 'PC1035'
OR "title_id" = 'PC8888' OR "title_id" = 'PC9999'
go
SELECT "pub_id","pub_name"
FROM "dbo"."publishers"
WHERE "pub_id" = '0877' OR "pub_id" = '0736'
OR "pub_id" = '0736' OR "pub_id" = '0736'
OR "pub_id" = '0736' OR "pub_id" = '0877'
OR "pub_id" = '0877' OR "pub_id" = '0877'
OR "pub_id" = '0877' OR "pub_id" = '0877'
go
SELECT "title_id","title","pub_id"
FROM "dbo"."titles"
WHERE "title_id" = 'PS1372' OR "title_id" = 'PS2091'
OR "title_id" = 'PS2106' OR "title_id" = 'PS3333'
OR "title_id" = 'PS7777' OR "title_id" = 'TC3218'
OR "title_id" = 'TC4203' OR "title_id" = 'TC7777'
OR "title_id" = 'TC7777' OR "title_id" = 'TC7777'
|
| ODBC Directやパススルークエリーの限界 |
|---|
sp_cursoropen 0, _ "SELECT titles.title, publishers.pub_name" & _ "FROM publishers INNER JOIN titles ON publishers.pub_id = titles.pub_id" , 4, 1, 1 go sp_cursorfetch 19225392, 2, 1, 100 go sp_cursorfetch 19225392, 2, 1, 100 go sp_cursorclose 19225392 |
SELECT titles.title, publishers.pub_name FROM publishers INNER JOIN titles ON publishers.pub_id = titles.pub_id |
| (旧バージョンは)フォームとの連結は困難だった |
|---|
| OLE DBを使用したリモートデータベースアクセスが飛躍的に進歩 |
|---|
| Microsoft SQL Serverにアクセスするには、MDBでない別のプロジェクトファイルを作成する |
|---|

| ADPプロジェクトはMicrosoft SQL Server専用ではない |
|---|
rs.Open "Select * From Employees", _
con, adOpenKeyset, adLockOptimistic
Set Forms("Employees").Recordset = rs
EmployeeID.ControlSource = "EmployeeID" LastName.ControlSource = "LastName"
Private Sub Form_Open(Cancel As Integer)
Set con = New ADODB.Connection
con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=SANTIAGO"
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open "Select * From Employees", con, adOpenKeyset, adLockOptimistic
Set Forms("Employees").Recordset = rs
EmployeeID.ControlSource = "EmployeeID"
LastName.ControlSource = "LastName"
End Sub
|
| Microsoft Access 2000は巨大な入出力コントロール |
|---|
| Microsoft SQL Serverと統合された環境 |
|---|
| これまで、Microsoft AccessはC/Sシステム開発ツールではなかった |
|---|
| ならば、C/Sシステム開発ツールなら話は簡単なのか? |
|---|
| AccessはType x DB Serverクライアントになり得るか? |
|---|