Apollo API Listing > sx

VB Declaration

Declare Sub sx_SetDeleted Lib "Apollo9.dll"

(ByVal uiDeleted As Integer)

C Declaration

VOID FAR PASCAL sx_SetDeleted

(USHORT uiDeleted);

Description

Makes deleted records either transparent or visible to record positioning functions.

Setting sx_SetDeleted to TRUE incurs certain performance penalties. Instead of using sx_SetDeleted TRUE, consider creating conditional index files with a condition of .not. deleted.

Parameters

If True, deleted records will be invisible to all record positioning functions except sx_Go .

VB Example

Sub Form_Load ()

' main form initialization routines

sx_CloseAll

sx_SetDateFormat ANSI

sx_SetCentury True

sx_SetDeleted True

iRetVal = sx_SetHandles(30)

If Dir$("c:\data\sxcust.dbf") = "" Then

MsgBox "Test file missing. Aborting!"

End

End If

End Sub

C Example

// Standard initialization

sx_SetStringType(1); // C strings

sx_SetCentury(TRUE); // dates to display century

sx_SetDateFormat(AMERICAN); // date format MM/DD/CCYY

sx_SetDeleted(TRUE); // filter deleted records

sx_SetDeleted