Venice
Sales::GetDBStatus
 
Gets the last database status.
 
LONG GetDBStatus ()
 
Return value
A LONG containing the last status of the database, 0 meaning the last database action was successfull.
 
Remarks
The following codes can be returned:
-98: (PosBlockCorrupt) The memory check of the position block failed. This is caused by a programming error.
-97: (MultipleOpen) A file that was already open, is opened again. This is caused by a programming error.
-96: (WrongSeekMode) The supplied seek mode is invalid. This is caused by a programming error.
-95: (RecLenOverflow) While inserting or updating a record, the record length supplied is greater than the physical record length. This is caused by a programming error.
-94: (WrongFileVersion) The version of the .btr-file is different from the version of the corresponding .cld-file. This can be caused by a faulty conversion or by a selective restore of a backup.
-93: (WrongCrc) The CRC check of a record failed. This can be caused by modifying records without using Venice or by hardware problems.
-92: (BadFileInit) The corresponding .cld-file is faulty or missing. This can be caused by a programming error or by deleting the .cld-file.
-90: (CopyFailed) Copying a file failed. This can be caused by a programming error or by problems with rights.
-89: (RWOwnerExpected) The owner of the file is invalid. This can be caused by a programming error or by a selective restore of a backup.
-88: (EncryptionExpected) The owner of the file is invalid. This can be caused by a programming error or by a selective restore of a backup.
-87: (InvalidLobs) The definition of the LOBs (Large Objects) in the .cld-file is invalid. This is caused by a programming error.
-86: (MaxDataBases) The maximum number of databases has been exceeded. This can be caused by creating lots of objects, each with their own dialogs and browses. Try cleaning up unused objects as soon as possible.
Others: See Actian Zen/Pervasive PSQL documentation ('Status Codes').
 
See Also
CreateSales
GetNext
SeekBySysNum
 
Samples
 
C++
 
// Navigate through the file
pSales->SeekBySysNum (smFirst, 0);
while (pSales->GetDBStatus () == 0)
{
    pSales->GetNext ();
}

C#
 
// Navigate through the file
oSales.SeekBySysNum (eSeekMode.smFirst, 0);
while (oSales.GetDBStatus () == 0)
{
    oSales.GetNext ();
}

VBS
 
' Navigate through the file
Call oSales.SeekBySysNum(smFirst, 0)
While oSales.GetDBStatus() = 0
    Call oSales.GetNext()
Wend

VB.NET
 
' Navigate through the file
oSales.SeekBySysNum(eSeekMode.smFirst, 0)
While oSales.GetDBStatus() = 0
    oSales.GetNext()
End While