Difference between revisions of "Other handles (file, sql)"

From Team Developer SqlWindows Wiki
Jump to: navigation, search
m (Corrected VisFileError codes (in real they are negative values))
m
Line 30: Line 30:
 
Number: ERROR_SHARING_VIOLATION = -32
 
Number: ERROR_SHARING_VIOLATION = -32
 
Number: ERROR_LOCK_VIOLATION = -33
 
Number: ERROR_LOCK_VIOLATION = -33
Number: ERROR_WRONG_DISK = -34
+
Number: ERROR_WRONG_DISK <span class="plainlinks">[http://www.mycaal.com/ <span style="color:black;font-weight:normal; text-decoration:none!important; background:none!important; text-decoration:none;">loan modification]    = -34
 
Number: ERROR_HANDLE_EOF = -38
 
Number: ERROR_HANDLE_EOF = -38
 
Number: ERROR_HANDLE_DISK_FULL = -39
 
Number: ERROR_HANDLE_DISK_FULL = -39
Line 43: Line 43:
 
<pre>
 
<pre>
 
   If SalFileOpen( hFile, sFile, OF_Share_Exclusive )
 
   If SalFileOpen( hFile, sFile, OF_Share_Exclusive )
       ! File was not open, now it is and it is locked by this process
+
       ! File was not open, now it is and <span class="plainlinks">[http://www.bestpills4weightloss.com/ <span style="color:black;font-weight:normal; text-decoration:none!important; background:none!important; text-decoration:none;">weight loss pills for women</span>] it is locked by this process
 
       ! ... do file stuff ...
 
       ! ... do file stuff ...
       ! Dont forget to close the file
+
       ! Dont forget to close the <span class="plainlinks">[http://www.proposable.com <span style="color:black;font-weight:normal; text-decoration:none!important; background:none!important; text-decoration:none;">proposal software] file  
 
       ! Call SalFileClose( hFile )
 
       ! Call SalFileClose( hFile )
 
   Else
 
   Else
 
       ! File is opened by this or another process
 
       ! File is opened by this or another process
 
</pre>
 
</pre>

Revision as of 19:42, 9 September 2011

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 <span class="plainlinks">[http://www.mycaal.com/ <span style="color:black;font-weight:normal; text-decoration:none!important; background:none!important; text-decoration:none;">loan modification]    = -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 <span class="plainlinks">[http://www.bestpills4weightloss.com/ <span style="color:black;font-weight:normal; text-decoration:none!important; background:none!important; text-decoration:none;">weight loss pills for women</span>] it is locked by this process
      ! ... do file stuff ...
      ! Dont forget to close the <span class="plainlinks">[http://www.proposable.com <span style="color:black;font-weight:normal; text-decoration:none!important; background:none!important; text-decoration:none;">proposal software] file 
      ! Call SalFileClose( hFile )
   Else
      ! File is opened by this or another process