|
This example shows the use of the
GlobalId property.
|
1 |
Chai
|
18
|
39
|
|
2 |
Chang
|
19
|
17
|
|
3 |
Aniseed Syrup
|
10
|
13
|
|
4 |
Chef Anton's Cajun Seasoning
|
22
|
53
|
|
5 |
Chef Anton's Gumbo Mix
|
21.35
|
0
|
|
|
|
|
1 |
Chai
|
18
|
39
|
|
2 |
Chang
|
19
|
17
|
|
3 |
Aniseed Syrup
|
10
|
13
|
|
4 |
Chef Anton's Cajun Seasoning
|
22
|
53
|
|
5 |
Chef Anton's Gumbo Mix
|
21.35
|
0
|
|
|
|
This is the code implementing the example:
<!--#include file="VBSdb/inc.asp"-->
<%
VbsDbNew objVbsDb1
objVbsDb1( "MdbPath" ) = "data/nwind.mdb"
objVbsDb1( "Sql" ) = "select ProductName,UnitPrice,UnitsInStock from Products"
objVbsDb1( "GlobalId" ) = 1
VbsDb objVbsDb1
VbsDbClose objVbsDb1
VbsDbNew objVbsDb2
objVbsDb2( "MdbPath" ) = "data/nwind.mdb"
objVbsDb2( "Sql" ) = "select ProductName,UnitPrice,UnitsInStock from Products"
objVbsDb2( "GlobalId" ) = 2
VbsDb objVbsDb2
VbsDbClose objVbsDb2
%>
This demonstrative program connects to
Nwind.mdb, the well known Microsoft Access sample database: the names of companies,
products, people,
characters, and/or data mentioned herein are fictious and are in no way
intended to represent any real individual, company, product, or event.
To download a copy of Nwind.mdb, please visit
Microsoft's site.
| 