Filter
Top Products
Using stored procedures to update the database
200 DataWindow .NET
If a stored procedure for a particular SQL update method is not defined, the
DataWindow control submits the appropriate SQL syntax in the same manner
it always has.
Data
Using Describe and
Modify
You can use the DataWindow Describe and Modify methods to access
DataWindow property values including the stored procedures associated with
a DataWindow object. For information, see the DataWindow object property
Table.property in the DataWindow Object Reference.
Restrictions on the
use of Modify
Since a database driver can only report stored procedure names and parameter
names and position, it cannot verify that changes made to stored procedures are
valid. Consequently, if you use
Modify to change a stored procedure, be careful
that you do not inadvertently introduce changes into the database.
In addition, using
Modify to enable a DataWindow object to use stored
procedures to update the database when it is not already using stored
procedures requires that the type qualifier be specified first. Calling the type
qualifier ensures that internal structures are built before subsequent calls to
Modify. If a new method or method arguments are specified without a preceding
definition of type,
Modify fails.