GenericFileFind Method

Find a record from the database table. No data is returned.

Syntax

public static int GenericFileFind( 
   int channel,
   string keyValue,
   int keyNumber
)

Parameters

channel: The channel number.
keyValue: The key value to locate the required row in the database table.
keyNumber: The key number to use to determine the key to search on.

Return Value

A value of zero (0) is success otherwise an error code.

Remarks

Enables file style managment of a database table. The Generic* methods allow easy migraiton from ISAM style processing to database managment within your application. The GenericFileFind allows you to map the FIND operation on an ISAM file to locate the data within a database table. The GenericFileFind method does not return the row data but positions the table such that the next GenericFileReads operation would return the row data.

Example

;;Check if we are accessing data from a database
if (Symphony.dB.DBAccess.GenericDBCheck(channel))
begin
	keyNumber = 0

	if (^passed(key_no)) then
		;;use the passed key number
		keyNumber = key_no
	else
		;;find the key number given the key value
		keyNumber = Symphony.dB.DBAccess.GenericFileKeyCheck(channel, ^argtype(key), ^size(key))

	keyNumber = key_no
	
	err = Symphony.dB.DBAccess.GenericFileFind(channel, key, keyNumber)
	
	xreturn
end

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DBAccess Class
DBAccess Members