|
Swaps the file to another key. |
|
 |
VARIANT_BOOL SwapKey ( SHORT sKeyNum ) |
|
|
Parameters | sKeyNum | [in] The number of the key by which you want the file positioned. | | Return value |
True if the file was positioned according to the given key, otherwise false (e.g. if the current record is a null value for the given key or if an invalid sKeyNum was supplied). |
|
See Also |
|
|
|
Samples |
|
 |
C++ |
|
// Browse for a sales order detail line, which positions the file by a key that is unknown
pSOrderDet->Browse (VARIANT_FALSE);
// Swap the key to 'SRD_LNE' (1), positioning by document
pSOrderDet->SwapKey (1);
// Navigate through the file using the key 'SRD_LNE'
while (pSOrderDet->GetDBStatus () == 0)
{
// Process record data
pSOrderDet->GetNext ();
}
|
|
 |
C# |
|
// Browse for a sales order detail line, which positions the file by a key that is unknown
oSOrderDet.Browse (false);
// Swap the key to 'SRD_LNE' (1), positioning by document
oSOrderDet.SwapKey (1);
// Navigate through the file using the key 'SRD_LNE'
while (oSOrderDet.GetDBStatus () == 0)
{
// Process record data
oSOrderDet.GetNext ();
}
|
|
 |
VBS |
|
' Browse for a sales order detail line, which positions the file by a key that is unknown
Call oSOrderDet.Browse(False)
' Swap the key to 'SRD_LNE' (1), positioning by document
Call oSOrderDet.SwapKey(1)
' Navigate through the file using the key 'SRD_LNE'
While oSOrderDet.GetDBStatus() = 0
' Process record data
Call oSOrderDet.GetNext()
Wend
|
|
 |
VB.NET |
|
' Browse for a sales order detail line, which positions the file by a key that is unknown
oSOrderDet.Browse(False)
' Swap the key to 'SRD_LNE' (1), positioning by document
oSOrderDet.SwapKey(1)
' Navigate through the file using the key 'SRD_LNE'
While oSOrderDet.GetDBStatus() = 0
' Process record data
oSOrderDet.GetNext()
End While
|
|