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

100

101

7 Functions — Alphabetical List

7-168

Select and display the data from the yearlySales table.

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

curs = fetch(curs);

curs.Data

ans =

Month salesTotal Revenue

--------- ---------- -------

'January' 130 1200

'Feb' 25 250

Store the column names of yearlySales in a cell array.

colnames = {'Month','salesTotal','Revenue'};

Store the data for the insert in a cell array, data. The data contains Month equal to

'March', salesTotal equal to $50, and Revenue equal to $2000.

data = {'March',50,2000};

Insert the data into yearlySales.

tablename = 'yearlySales';

insert(conn,tablename,colnames,data)

Display the data from yearlySales again.

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

curs = fetch(curs);

curs.Data

ans =

Month salesTotal Revenue

--------- ---------- -------

'January' 130 1200

'Feb' 25 250

'March' 50 2000

A new row appears in yearlySales with the data from data.

After finishing with the cursor object, close it.

close(curs)

1 2 ... 593 594 595 596 597 598 599 600 601 602 603 ... 683 684

Commentaires sur ces manuels

Pas de commentaire

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

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel MATLAB DATABASE TOOLBOX RELEASE NOTES