Other handles (file, sql)

From Team Developer SqlWindows Wiki
Revision as of 10:56, 17 November 2008 by DaveRabelink (Talk | contribs)

Jump to: navigation, search

This page covers handle datatype (Sql, file etc) tips & tricks.

Contents


Pointer2.png What are the errorcodes returned by VisFile functions Pointer.png

The following list are VisFile return codes. They can be found in
SAL Extension V2.04 library.

Number: ERROR_FILE_NOT_FOUND 		= 2
Number: ERROR_PATH_NOT_FOUND 		= 3
Number: ERROR_TOO_MANY_OPEN_FILES 	= 4
Number: ERROR_ACCESS_DENIED 		= 5
Number: ERROR_INVALID_HANDLE 		= 6
Number: ERROR_NOT_ENOUGH_MEMORY 	= 8
Number: ERROR_BAD_FORMAT 		= 11
Number: ERROR_OUTOFMEMORY 		= 14
Number: ERROR_INVALID_DRIVE 		= 15
Number: ERROR_CURRENT_DIRECTORY 	= 16
Number: ERROR_NOT_SAME_DEVICE 		= 17
Number: ERROR_NO_MORE_FILES 		= 18
Number: ERROR_WRITE_PROTECT 		= 19
Number: ERROR_NOT_READY 		= 21
Number: ERROR_BAD_COMMAND 		= 22
Number: ERROR_OUT_OF_PAPER 		= 28
Number: ERROR_WRITE_FAULT 		= 29
Number: ERROR_READ_FAULT 		= 30
Number: ERROR_SHARING_VIOLATION 	= 32
Number: ERROR_LOCK_VIOLATION 		= 33
Number: ERROR_WRONG_DISK 		= 34
Number: ERROR_HANDLE_EOF 		= 38
Number: ERROR_HANDLE_DISK_FULL 		= 39
Number: ERROR_NOT_SUPPORTED 		= 50


Pointer2.png How to check if a file is already opened Pointer.png

Use this to check if a file is already opened.

   If SalFileOpen( hFile, sFile, OF_Share_Exclusive )
      ! File was not open, now it is and it is locked by this process
      ! ... do file stuff ...
      ! Dont forget to close the file
      ! Call SalFileClose( hFile )
   Else
      ! File is opened by this or another process