FetchByUid

<< Click to Display Table of Contents >>

Navigation:  Programming Mechworks PDM > DBWCommandShell > Commands Reference > Database >

FetchByUid

Description

Fetches a field value in a specified record, given the unique id.

Syntax

call DBWShell("FetchByUid DocUID FieldName [AddDecimals]")

Parameters

DocUID

document Unique id

FieldName

field name to fetch in the DBWorks database

AddDecimals

Optional.
0: default; returns data as YYYY/MM/DD HH:mm:ss (without decimals)
1: returns data as YYYY/MM/DD HH:mm:ss.zzz (with decimals)

Example

call DBWShell( "FetchByUid 354 Description" )

if (okDBW = False) then exit sub

call DBWShell( "FetchByUid 354 LAST_MODIFICATION_DATE 1" )

if (okDBW = False) then exit sub