PdcDBTable.Locate

Declaration

Locate(KeyFields as String,KeyValues as Variant) as Boolean

Description

Returns true or false whether a record could be found

Notes

This method locates a record in a table by its key column(s).

Code example

This code locates an invoice line identified by both the invoice number and the line's position number.

dim PosNr

  PosNr = fstrCTxt(TblFACEXP.GetField("EX_POS"))
  if tblFACREGEL.Locate("FR_NR;FR_POS", Array(FacNr, PosNr)) then
    if not tblFACREGEL.GetField("FR_EXTRA") then
      if tblDO_ORDER.Locate("DO_ORDNR", tblFACREGEL.GetField("FR_CALCNR")) then
        dblLevFaktor = tblFACREGEL.GetField("FR_LEVTAL") / tblDO_ORDER.GetField("DO_SERGR")
      end if
    end if
  else
    'Not found
  end if

Availability

Available since June 2008 (from version 3.8)