MATLAB DATABASE TOOLBOX RELEASE NOTES User's Guide download pdf (Page 576)

7 Functions — Alphabetical List

7-146

conn = database.ODBCConnection('MySQL','username','pwd');

Select all products from the productTable table and sort them in ascending order

by product number. Create a scrollable cursor using the name-value pair argument

'cursorType'.

curs = exec(conn,'select * from productTable order by productNumber',...

'cursorType','scrollable');

Import the data for two products in the middle of the data set. Use the row limit 2 to

import data for two products. Use the absolute position offset 3 to import data starting

from the third product in the data set.

curs = fetch(curs,2,'absolutePosition',3);

Display the data for the two products.

curs.Data

ans =

[3] [400999] [1009] [17] 'Slinky'

[4] [400339] [1008] [21] 'Space Cruiser'

The columns in curs.Data are:

• Product number

• Stock number

• Supplier number

• Unit cost

• Product description

Display the position of the cursor.

curs.Position

ans =

3

The position of the cursor stays at the absolute position offset 3.

After finishing with the cursor object, close it.

1 2 ... 571 572 573 574 575 576 577 578 579 580 581 ... 683 684

Comments to this Manuals

No comments

Energizer CAPP2BODE Scheda Tecnica (1 pagine)

Marchio: Energizer | Categoria: Flashlights | Dimensione: 0.07 MB |

Inglese

Indice

CAPP2BODECAPP2BODE

1

Più prodotti e manuali per Torce Energizer

Modelli	Tipo di Documento
627462	Scheda Tecnica Energizer Booklite, 1 pagine
ENSHH31L	Scheda Tecnica Energizer ENSHH31L flashlight, 1 pagine
625700	Scheda Tecnica Energizer Princess, 1 pagine
ENSHL11L	Scheda Tecnica Energizer ENSHL11L flashlight, 1 pagine
628909	Scheda Tecnica Energizer ATEX 2D Intrinsically Safe LED, 1 pagine
HDL1AAE	Scheda Tecnica Energizer HDL1AAE flashlight, 1 pagine
628908	Scheda Tecnica Energizer ATEX 2AA Intrinsically Safe LED, 1 pagine
WRRCNM3G	Scheda Tecnica Energizer WRRCNM3G flashlight, 1 pagine
WR2A3ACE	Scheda Tecnica Energizer WR2A3ACE flashlight, 1 pagine
EDMCC42E	Manuale Utente Energizer EDMCC42E flashlight, 1 pagine
HD33A3CE	Manuale Energizer HD33A3CE flashlight, 2 pagine
HDL33A2E	Manuale Energizer HDL33A2E flashlight, 1 pagine