MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka stáhnout pdf (Strana 447)

100

101

columnnames

7-17

'SupplierNumber','SupplierName','City','Country','FaxNumber'

columnlist contains one long string with the column names in the suppliers table in

quotes and separated by commas.

After finishing with the cursor object, close it.

close(curs)

Close the database connection.

close(conn)

Return Column Names as a Cell Array

Create a database connection conn using the dbtoolboxdemo data source.

conn = database('dbtoolboxdemo','','');

Working with the dbtoolboxdemo data source, use fetch to import all data into

Database Cursor Object curs. Store the data in a cell array contained in the cursor

object field curs.Data.

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

curs = fetch(curs);

Return the column names in the suppliers table as a cell array.

columnlist = columnnames(curs,true)

columnlist =

'SupplierNumber'

'SupplierName'

'City'

'Country'

'FaxNumber'

columnlist contains a cell array of the column names in the suppliers table. The cell

array has five rows for each column name.

After finishing with the cursor object, close it.

close(curs)

Close the database connection.

1 2 ... 442 443 444 445 446 447 448 449 450 451 452 ... 683 684

Komentáře k této Příručce

Žádné komentáře

MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka Strana 447

Komentáře k této Příručce

Související produkty a manuály pro Software MATLAB DATABASE TOOLBOX RELEASE NOTES