This example shows the use of the
GlobalPagePositioning property.
As you can see, the grid is well below the bottom of this page.
Hit page down or drag your page cursor to see the VBSdb object below the page bottom.
Please, note that when you click a link in the VBSdb object, your browser does not
jump at the top of the page,
the next time the page is displayed. It keeps focused on the VBSdb object, instead.
|
1 |
Chai
|
10 boxes x 20 bags
|
18
|
|
2 |
Chang
|
24 - 12 oz bottles
|
19
|
|
3 |
Aniseed Syrup
|
12 - 550 ml bottles
|
10
|
|
4 |
Chef Anton's Cajun Seasoning
|
48 - 6 oz jars
|
22
|
|
5 |
Chef Anton's Gumbo Mix
|
36 boxes
|
21.35
|
|
|
|
This is the code implementing the example:
<!--#include file="VBSdb/inc.asp"-->
<%
VbsDbNew objVbsDb
objVbsDb( "MdbPath" ) = "data/nwind.mdb"
objVbsDb( "GlobalPagePositioning" ) = "VBSdb"
objVbsDb( "Sql" ) = "select ProductName,QuantityPerUnit,UnitPrice from Products"
objVbsDb( "ViewNavigationButtons" ) = "first;prev;next;last;search;removeFilter;add;update;delete"
objVbsDb( "EditTableName" ) = "Products"
objVbsDb( "EditKeyFields" ) = "ProductID"
VbsDb objVbsDb
%>
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.
| 