Using Win32 functions in Visual FoxPro Image Gallery
Handle and Object
..msdn
CloseHandle
DuplicateHandle
GetHandleInformation
SetHandleInformation
Code examples:
Comparing file times
Copying files as a transacted operation (Vista)
Creating a console window for Visual FoxPro application
Creating a file, then moving it to another destination
Creating a mailslot
Enumerating Processes -- Win9*
Enumerating Processes -- WinNT
How to check whether the system is 32-bit or 64-bit
How to convert a bitmap file to monochrome format (1 bpp)
How to enable the SE_SHUTDOWN_NAME privilege for the application
How to find when the application started
How to make application automatically close all documents it opened
How to prevent users from accessing the Windows Desktop and from switching to other applications
How to run FoxPro application under different user name (impersonating user)
How to set Creation Date/Time for a folder (WinNT)
How to Start a Process as Another User (NT/XP/2K)
How to suspend or hibernate your system
HOWTO: Use the Win32 API to Access File Dates and Times
Locking and unlocking file of a VFP table
Monitoring changes occurring within a directory
Moving shortcut to a specified position on the Windows Desktop
Obtaining I/O counts for the current process
Obtaining names and positions for shortcuts located on the Windows Desktop
Obtaining physical parameters for a drive: sectors, clusters, cylinders...
Passing data records between VFP applications via the Clipboard
Peer-to-peer LAN messenger built with Mailslot API functions
Reading and setting system access privileges for the current process
Reading and setting the priority class values for the current process and thread
Retrieving file information for the VFP executable running
Running MSDOS Shell as a child process with redirected input and output (smarter RUN command)
Setting the date and time that a file was created
Starting external program from VFP and waiting for its termination
Storing content of the Clipboard to a bitmap file
Storing screen shot of a form to bitmap file
Subclassing CommandButton control to create BackColor property
Terminating all running applications from a VFP program
Testing serial ports
Using File Mapping for enumerating files opened by Visual FoxPro
Using GetFileSize
Using InternetSetFilePointer when resuming interrupted download from the Internet
Using mailslots to send messages on the network
Using named pipes for interprocess communication
Using shared memory to exchange data between two FoxPro applications
Using the CreateFile
Using the DeleteFile
Using the Semaphore object
Using the Semaphore object to allow only one instance of VFP application running
Vertical Label control
Locking and unlocking file of a VFP table

User rating: 10/10 (1 votes)
Rate this code sample:
  • ~
More code examples    Listed functions    Add comment     W32 Constants      Translate this page Printer friendly version of this code sample
 
DO decl
 
#DEFINE GENERIC_READ 0x80000000
#DEFINE GENERIC_WRITE 0x40000000
#DEFINE cret  Chr(13)
#DEFINE dcret Chr(13)+Chr(13)
 
    LOCAL lcPath, lcAlias, lcFile, hFile, lnHeader, lcBuffer
    lcPath  = GetTmpPath()
    lcAlias = "Test"
    lcFile  = lcPath + lcAlias + ".dbf"
 
    * creating a testing table
    IF USED (lcAlias)
        USE IN (lcAlias)
    ENDIF
 
    IF Not FILE(lcFile)
        SET SAFETY OFF
        CREATE TABLE (lcFile) (dt T)
        SET SAFETY ON
        INSERT INTO (lcAlias) VALUES (datetime())
    ELSE
        USE (lcFile) ALIAS (lcAlias) SHARED
    ENDIF
 
    lnHeader = HEADER()
    USE IN (lcAlias)
 
    lcBuffer = REPLI (Chr(0), 250)
    hFile = OpenFile (lcFile, @lcBuffer, GENERIC_READ)
 
    IF LockFile (hFile, 0,0, lnHeader,0) <> 0
        = MessageB ("File " + lcFile + " is locked." + dcret +;
            "At this point do not close this Dialog " +;
            "and start another VFP instance." + dcret +;
            "Use another instance to open " + lcFile + cret +;
            "or just try to read the tables on " + lcPath + " " + ;
            "using regular DIRECTORY command." + dcret +;
            "After that click Ok to unlock the target file.", 64, "Locking a file")
 
        = UnlockFile (hFile, 0,0, lnHeader,0)
    ELSE
        * 6 = ERROR_INVALID_HANDLE - already in exclusive use
        ? "Error code:", GetLastError()
    ENDIF
    = CloseHandle (hFile)
 
FUNCTION  GetTmpPath
    LOCAL lpBuffer, lnLength
    lpBuffer = SPACE(250)
    lnLength = GetTempPath (LEN(lpBuffer), @lpBuffer)
RETURN Iif (lnLength=0, "C:\Temp", PADR(lpBuffer, lnLength))
 
PROCEDURE  decl
    DECLARE INTEGER GetLastError IN kernel32
 
    DECLARE INTEGER GetTempPath IN kernel32;
        INTEGER nBufferLength, STRING @ lpBuffer
 
    DECLARE INTEGER LockFile IN kernel32;
        INTEGER hFile, INTEGER dwFileOffsetLow,;
        INTEGER dwFileOffsetHigh,;
        INTEGER nNumberOfBytesToLockLow,;
        INTEGER nNumberOfBytesToLockHigh
 
    DECLARE INTEGER UnlockFile IN kernel32;
        INTEGER hFile, INTEGER dwFileOffsetLow,;
        INTEGER dwFileOffsetHigh,;
        INTEGER nNumberOfBytesToUnlockLow,;
        INTEGER nNumberOfBytesToUnlockHigh
 
    DECLARE INTEGER OpenFile IN kernel32;
        STRING   lpFileName,;
        STRING @ lpReOpenBuff,;
        INTEGER  wStyle
 
    DECLARE INTEGER CloseHandle IN kernel32;
        INTEGER hObject
 
 

User rating: 10/10 (1 votes)
Rate this code sample:
  • ~
2194 bytes  
Created: 2001-09-18 12:00:00  
Modified: 2005-12-27 10:35:29  
Visits in 7 days: 132  
Listed functions:
CloseHandle
GetLastError
GetTempPath
LockFile
OpenFile
UnlockFile
Printer friendly API declarations
My comment:
After being locked in this way the table is not available to other VFP instances. You can lock it if the table is not in exclusive use.

In this example I use the HEADER() function to set the number of locked bytes. It is not critical, you may choose any reasonable number of bytes to lock.
Translate this page:
  Spanish    Portuguese    German    French    Italian  
FreeTranslation.com offers instant, free translations of text or web pages.
User Contributed Notes:
There are no notes on this subject.


Copyright © 2001-2013 News2News, Inc. Before reproducing or distributing any data from this site please ask for an approval from its owner. Unless otherwise specified, this page is for your personal and non-commercial use. The information on this page is presented AS IS, meaning that you may use it at your own risk. Microsoft Visual FoxPro and Windows are trade marks of Microsoft Corp. All other trademarks are the property of their respective owners. 

Privacy policy
Credits: PHP (4.4.9), an HTML-embedded scripting language, MySQL (5.1.55-log), the Open Source standard SQL database, AceHTML Freeware Version 4, freeware HTML Editor of choice.   Hosted by Korax Online Inc.
Last Topics Visited (107.22.156.205)
6 sec.Examples
Page 7
8.67 hrs.Function: 'GetFileAttributesEx'
Function group: 'File Management'
12.32 hrs.Example: 'Displaying printer-properties Property Sheet for the specified printer'
17.75 hrs.Function: 'ExtractIcon'
Function group: 'Icon'
 Example: 'Changing file attributes'
23.1 hrs.Function: 'DeleteUrlCacheEntry'
1 day(s)Example: 'Comparing file times'
 Example: 'How to display advanced Task Dialog (Vista)'
 Example: 'Reading and setting Environment variables'
 Function: 'CeMoveFile'
Google
Advertise here!