Difference between revisions of "Other handles (file, sql)"
From Team Developer SqlWindows Wiki
DaveRabelink (Talk | contribs) m (Corrected VisFileError codes (in real they are negative values)) |
GeorginaWall (Talk | contribs) 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 | + | 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 |
What are the errorcodes returned by VisFile functions 
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
How to check if a file is already opened
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
