|
This example shows the use of the
EditHideFields property.
If you either click the add button or the update or the delete button,
you can note that the Picture field is not displayed.
|
1 |
Beverages
|
Soft drinks, coffees, teas, beers, and ales
|
|
2 |
Condiments
|
Sweet and savory sauces, relishes, spreads, and seasonings
|
|
3 |
Confections
|
Desserts, candies, and sweet breads
|
|
4 |
Dairy Products
|
Cheeses
|
|
5 |
Grains/Cereals
|
Breads, crackers, pasta, and cereal
|
|
|
|
This is the code implementing the example:
<!--#include file="VBSdb/inc.asp"-->
<%
VbsDbNew objVbsDb
objVbsDb( "MdbPath" ) = "data/nwind.mdb"
objVbsDb( "Sql" ) = "select * from Categories"
objVbsDb( "ViewNavigationButtons" ) = "first;next;prev;last;search;add;update;delete"
objVbsDb( "GridHideFields" ) = "CategoryId;Picture"
objVbsDb( "FormHideFields" ) = "Picture"
objVbsDb( "EditTableName" ) = "Categories"
objVbsDb( "EditKeyFields" ) = "CategoryId"
objVbsDb( "EditHideFields" ) = "Picture"
%>
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.
|
