Maple Professionel
Maple Académique
Maple Edition Étudiant
Maple Personal Edition
Maple Player
Maple Player for iPad
MapleSim Professionel
MapleSim Académique
Maple T.A. - Suite d'examens de classement
Maple T.A. MAA Placement Test Suite
Möbius - Didacticiels de mathématiques en ligne
Machine Design / Industrial Automation
Aéronautique
Ingénierie des véhicules
Robotics
Energie
System Simulation and Analysis
Model development for HIL
Modélisation du procédé pour la conception de systèmes de contrôle
Robotics/Motion Control/Mechatronics
Other Application Areas
Enseignement des mathématiques
Enseignement de l’ingénierie
Enseignement secondaire et supérieur (CPGE, BTS)
Tests et évaluations
Etudiants
Modélisation financière
Recherche opérationnelle
Calcul haute performance
Physique
Webinaires en direct
Webinaires enregistrés
Agenda des évènements
Forum MaplePrimes
Blog Maplesoft
Membres Maplesoft
Maple Ambassador Program
MapleCloud
Livres blancs techniques
Bulletin électronique
Livres Maple
Math Matters
Portail des applications
Galerie de modèles MapleSim
Cas d'Etudes Utilisateur
Exploring Engineering Fundamentals
Concepts d’enseignement avec Maple
Centre d’accueil utilisateur Maplesoft
Centre de ressources pour enseignants
Centre d’assistance aux étudiants
Result:-UpdateData - set the value to which an element will be changed
Calling Sequence
result:-UpdateData( index, data )
Parameters
result
-
Result module
index
string or integer; the column to be updated
data
the new value
Description
UpdateData sets the value that the element stored in the row (indicated by the row cursor) and the column (indicated by index) will be changed to on a call to UpdateRow. The value the element will be changed to is data.
To update a row, set the new values by by calling UpdateData and then submit these updates by calling UpdateRow. Changing the current row discards any values set with UpdateData.
Maple can automatically determine the type of the column and convert data; however, this requires querying the type of the column. To avoid this overhead the type can be specified using an explicit cast. For more information, see conversions.
An element can be set to SQL NULL by passing 'SQLNULL' for data.
Not all Result modules can be updated. Only Result modules representing tables containing data from a single table (no joins) and a column of primary keys are guaranteed to be updatable. Particular JDBC Drivers and databases may allow a wider range of updatable tables and thus Result modules.
Examples
Create a Result to be updated.
Get the current values.
Set the update values.
The new values are not sent to the database yet.
Update the row.
Check the values.
See Also
Database, Database[Result], Database[Result][GotoRow], Database[Result][Last], Database[Result][Next], Database[Result][Previous], Database[Result][UpdateRow], Database[usage]
Download Help Document