MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur télécharger pdf (Page 677)

100

101

update

7-247

ans =

[ 1] [ 1700] [14.5000] '2014-10-20 00:00...'

[ 2] [ 1200] [ 9.3000] '2014-10-20 00:00...'

[ 3] [ 356] [17.2000] '2014-10-20 00:00...'

...

Define a cell array for the new price of the first product.

data(1,1) = {30.00};

Define the WHERE clause for the first product.

whereclause = 'where productNumber = 1';

Update the Price column in the inventoryTable for the first product.

tablename = 'inventoryTable';

colname = {'Price'};

update(conn,tablename,colname,data,whereclause)

Display the data in the inventoryTable table after making the update.

curs = exec(conn,'select * from inventoryTable');

curs = fetch(curs);

curs.Data

ans =

[ 1] [ 1700] [ 30] '2014-10-20 00:00...'

[ 2] [ 1200] [ 9.3000] '2014-10-20 00:00...'

[ 3] [ 356] [17.2000] '2014-10-20 00:00...'

...

The first product has an updated price of 30. Though the data is updated, the change has

not committed to the database.

Roll back the update.

rollback(conn)

Display the data in the inventoryTable table after rolling back the update.

curs = exec(conn,'select * from inventoryTable');

1 2 ... 672 673 674 675 676 677 678 679 680 681 682 683 684

Commentaires sur ces manuels

Pas de commentaire

MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur Page 677

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel MATLAB DATABASE TOOLBOX RELEASE NOTES