MATLAB DATABASE TOOLBOX RELEASE NOTES Guia do Utilizador descarregar pdf (Página 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

Comentários a estes Manuais

Sem comentários

MATLAB DATABASE TOOLBOX RELEASE NOTES Guia do Utilizador Página 447

Comentários a estes Manuais

Manuais e produtos relacionados com Software MATLAB DATABASE TOOLBOX RELEASE NOTES