<Source>.NbRec (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Managing databases

HFSQL functions

Prefix syntax

NbRec

Presentation

Example

Limitations

xBase

Number of records processed by the INSERT/UPDATE/DELETE updates

See also

CloseConnection

FileExist

InfoFile

OpenConnection

RefreshView

SetIntegrity

CopyEnreg

ExportJSONString

ActivateAutoFilter

ActivateFilter

Add

Alias

Backward

BuildKeyValue

CancelDeclaration

CancelSeek

ChangeConnection

ChangeDir

ChangeKey

ChangeLocation

ChangeLogDir

ChangeName

CheckIndex

CheckMemo

CheckStructure

CheckUnaltered

CompareItem

CreateView

Creation

CreationIfNotFound

Cross

DeactivateAutoFilter

DeactivateFilter

Declare

DeclareExternal

Delete

DeleteAll

DeleteView

DescribeFile

DuplicateRecord

EndNoModif

ErrorModification

ErrorStatusModification

ExecuteQuery

ExecuteQueryAsynchronous

ExecuteSQLQuery

ExecuteSQLQueryAsynchronous

ExecuteView

ExportCSV

ExportJSON

ExportXLS

ExportXML

ExtractMemo

FTListWord

FileExist

Filter

FilterContains

FilterIdentical

FilterIncludedBetween

FilterStartsWith

First

Flush

Forward

Found

Free

FreeQuery

GetCurrentPosition

HistoryModification

ImportHF55

ImportJSON

ImportText

ImportXLS

ImportXML

Index

IndexingInProgress

InfoFile

InfoMemo

InitSubscriber

JSONToRecord

Last

LinkMemo

ListFullTextIndex

ListItem

ListKey

ListLink

ListQueryParameter

ListStopWord

ListSynonym

LockFile

LockRecNum

MergeView

MigrateLinkedCompositeKey

Mode

Modify

ModifyStructure

NbRec

NoModif

OnError

Open

Optimize

Out

Password

PrepareQuery

PrepareSQLQuery

Read

ReadFirst

ReadLast

ReadNext

ReadPrevious

ReadSeek

ReadSeekFirst

ReadSeekLast

RecNum

RecordDate

RecordToJSON

RecordToString

RecordToXML

Reset

RestorePosition

RetrieveItem

RetrieveRecord

Save

SavePosition

Security

Seek

SeekFirst

SeekLast

SetDuplicates

SetMemo

SetPosition

SortView

State

ToFile

ToItem

UnlockFile

UnlockRecNum

Version

ViewToFile

Write

Limitations
xBase
Number of records processed by the INSERT/UPDATE/DELETE updates

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Source>.NbRec (Function)

In french: <Source>.NbEnr

Not available

Not available with this kind of connection

Returns the number of records in a data file, query or HFSQL view: active records, crossed records, deleted records, etc.

Caution: <Source>.NbRec ignores the current filter.

Example

// Active records in "Customer" data file
NbCustomerRec = Customer.NbRec()

Syntax

<Result> = <Source>.NbRec([<Options>])

<Result>: Integer

Number of records found,
-1 if an error occurred. HError returns more details about the problem.
Native XML Connector: the number of records depends on the use of <Source>.ActivateAutoFilter/<Source>.DeactivateAutoFilter:
If the filtering is enabled, only the records belonging to the current parent are taken into account.
If the filter is not active, the records found in the XML file are taken into account.
The filtering is enabled by default.

<Source>: Type corresponding to the specified source

Name of data file, HFSQL view or query used.

<Options>: Optional constant (or combination of constants)

Configures the type of record to count.
hBrowsableNonBlocking Number of records in the view or query that can currently be read (no record locking).
This constant is available for the views and queries in HFSQL Classic or Client/Server.
This constant has no effect for the data files and for the Native Connectors
hNonBlocking Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To knwo if the execution of the view or query is completed, use the ExecutionCompleted property.
This constant is available for the views and queries in HFSQL Classic or Client/Server.
This constant has no effect for the data files and for the Native Connectors
hStateActive
(default value) Number of active records (not crossed or deleted).
hStateAll Total number of records in the data file (hStateActive + hStateCrossed + hStateDel).
hStateCrossed Number of crossed records.
This option is not available.
hStateDel Number of deleted records (does not include the crossed records).

This parameter is ignored. The number of records calculated by <Source>.NbRec always corresponds to the total number of records in the table, in the database.
This number can differ from the number of displayed records if records have been added or deleted by another user. To view these new records, reinitialize an iteration by using one of the following functions: <Source>.ReadFirst, <Source>.ReadLast, <Source>.First, <Source>.Last.
Access by JDBC
This parameter is ignored. The number of records calculated by <Source>.NbRec always corresponds to the total number of records in the table, in the database.
This number can differ from the number of displayed records if records have been added or deleted by another user. To view these new records, reinitialize an iteration by using one of the following functions: <Source>.ReadFirst, <Source>.ReadLast, <Source>.First, <Source>.Last.

Remarks

Limitations

<Source>.NbRec does not return the number of records modified by an UPDATE query.
<Source>.NbRec does not work with queries that use the hWithFilter constant.

xBase

<Source>.NbRec with the hStateActive or hStateAll constant also returns the number of crossed or deleted records (backward compatibility).

However, you can get the number of crossed or deleted records by using <Source>.NbRec with the hStateDel or hStateCrossed constant.

Number of records processed by the INSERT/UPDATE/DELETE updates

When running an INSERT/UPDATE/DELETE query on HFSQL data files, the number of added, modified or deleted records is returned by the H.NbRecModificationQuery variable.

Business / UI classification: Business Logic

Component: wd270hf.dll