MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Pobierz pdf (Strona 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

Komentarze do niniejszej Instrukcji

Brak uwag

MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Strona 677

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie MATLAB DATABASE TOOLBOX RELEASE NOTES