MATLAB DATABASE TOOLBOX RELEASE NOTES Guida Utente Scaricare il pdf (Pagina 497)

hasdata

7-67

hasdata

Determine if cursor in DatabaseDatastore contains more data

Syntax

tf = hasdata(dbds)

Description

tf = hasdata(dbds) returns logical 1 (true) if additional data exists in the cursor

object of the DatabaseDatastore object dbds. Otherwise, it returns logical 0 (false).

For JDBC drivers, hasdata uses the driver to check if the cursor position is located at

the end of the data set. For the native ODBC interface, hasdata checks the Data field in

the cursor object for remaining data in the data set.

Examples

Determine the Presence of More Data in DatabaseDatastore

The default output data type of any datastore is a table. Set the database preference

for the data return format 'DataReturnFormat' to table for consistency across data

types.

setdbprefs('DataReturnFormat','table')

Create a database connection conn using the native ODBC interface with Windows

Authentication. This code assumes you are connecting to a Microsoft SQL Server

database with the data source named MS SQL Server Auth. MS SQL Server Auth

contains the table named productTable with 15 product records.

conn = database.ODBCConnection('MS SQL Server Auth','','');

Create a DatabaseDatastore object dbds using the database connection conn and

SQL query sqlquery. This SQL query retrieves all products from the product table

productTable ordered by product number.

1 2 ... 492 493 494 495 496 497 498 499 500 501 502 ... 683 684

Commenti su questo manuale

Nessun commento

List of brands for manuals category Car alarm

all
0-9
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
r
s
t
u
v
w
x

Brands	Top models
Pandora	RX-151 DXL 3700 RX-155 DXL 2500	Other categories
Pantera	SLK-85 XS-1500 CLK-500 SLK-500RS	Other categories
Pharaon	V20 x150 V16i SCS-4000	Other categories
Phantom	Voyager Page FREEROAD I488 Bi-Drive	Other categories
Python	Model 902 702 871XP 436 Series	Other categories
Partisan	i200 RX-5 RX-3 S1	Other categories
PUTHON	460HP 5206P	Other categories
PYLE Audio	car security system Parking Sensor System PLPSE8WL	Other categories
Pioneer	HIGH DEFINITION PLASMA TELEVISION PRO1130HD Car Stereo Receiver DEH-P5200	Other categories
Prestige-portraits	APS-20B	Other categories
Prime Security	Prime AMX 38	Other categories
Pro-tec	Automobile Alarm	Other categories
Protec	Loop Commisioning 6400	Other categories
Pyle	PWD201	Other categories

1