Alpha Video Training
Results 1 to 7 of 7

Thread: What are files that begin with $$

  1. #1
    Member
    Real Name
    Jack DeBoer
    Join Date
    Oct 2006
    Location
    Houston, TX
    Posts
    457

    Default What are files that begin with $$

    Right now got about 17 files that start wtih $$ & end with DDD, DDM, DDX, DBF, or FTP. The number of these files keeps getting bigger. Are these temporary files and can they be deleted?

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: What are files that begin with $$

    Quote Originally Posted by turbojack View Post
    Right now got about 17 files that start wtih $$ & end with DDD, DDM, DDX, DBF, or FTP. The number of these files keeps getting bigger. Are these temporary files and can they be deleted?

    Alpha Five File Types

    Scroll down to the context "Other".

  3. #3
    Member
    Real Name
    Jack DeBoer
    Join Date
    Oct 2006
    Location
    Houston, TX
    Posts
    457

    Default Re: What are files that begin with $$

    Thanks. I did a search on the message board and could not find an answer I then did search on PDF of help but did not see it there either but just went back and there it is.

  4. #4
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    Location
    S.E. Michigan
    Posts
    5,763

    Default Re: What are files that begin with $$

    "Alpha Five should delete them when exiting."

    The key word it "should". Unfortunately it doesn't always happen. Here's a function I call from my autoexec script in almost every app. just to be sure: (as you can tell, I've been using it for a long time without modification. I know the original was done a long time before 2004 even.)
    Code:
    'Date Created: 22-Oct-2004 01:30:40 PM
    'Last Updated: 22-Oct-2004 11:20:32 PM
    'Created By  : Cal
    'Updated By  : Cal
    FUNCTION Del_dollar AS C ( )
    'Description: Deletes all files in the database that start with "$$".  This includes the Data path (local path if running network optimized), Private path, and Executables path.  Nothing returned.
    '-----------------------------------------------------------------------
    ' THIS SCRIPT DELETES ALL FILES IN THE DATABASE THAT START WITH "$$".
    ' THIS INCLUDES THE DATA PATH (start-in), PRIVATE PATH, AND EXECUTABLES PATH.
    '-----------------------------------------------------------------------
    ' SET THE PATH NAMES TO AN ARRAY FOR LOOPING.
    '-----------------------------------------------------------------------
    DIM path[10] as c
    path[1] = a5.get_path() + chr(92)
    path[2] = a5.get_private_path() + chr(92)
    pcount = 2
    IF a5.get_private_path() <> a5.get_exe_path()
     path[3] = a5.get_exe_path() + chr(92)
     pcount = 3
    END IF
    '--- DON'T BOTHER WITH THE SHARED PATH or MASTER PATH BECAUSE IT SHOULD
    '--- NEVER PUT THESE FILES THERE.
    '-----------------------------------------------------------------------
    ' NOW DELETE ANY "$$*.*" FILES THAT ARE NOT LOCKED.
    '-----------------------------------------------------------------------
    fcount = 0
    FOR x = 1 to pcount
     type_of_files = 0 + FILE_FIND_ARCHIVE + FILE_FIND_READONLY + FILE_FIND_HIDDEN
     dfiles = filefind.get( path[x] + "$$*.*", type_of_files, "PN" )
     FOR qx = 1 to line_count( dfiles )
      fname = word( dfiles, qx, crlf() ) '*** GET THE FILE NAME.
      ON ERROR goto Continue_next '*** FIND OUT IF THE FILE IS LOCKED.
      fp = file.open( fname, file_rw_exclusive )
      ON ERROR goto 0
      fp.close() '*** FILE IS NOT LOCKED SO CLOSE IT AND REMOVE IT.
      file.remove( fname )
      fcount = fcount + 1
     '---------------
     Continue_next:
     '---------------
      ON ERROR goto 0
      statusbar.robot()
     NEXT
    NEXT
    trace.writeln( ltrim(str( fcount )) + " '$$' files deleted" )
    Del_dollar = ltrim(str(fcount))
    END FUNCTION

  5. #5
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,212

    Default Re: What are files that begin with $$

    Cal,

    OUTSTANDING!!!! Thank you, very much for that gem.

    Mike W

  6. #6
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    Location
    S.E. Michigan
    Posts
    5,763

    Default Re: What are files that begin with $$

    Let me clarify "it doesn't always happen."

    If Alpha doesn't shut down cleanly, those files probably won't be removed.

  7. #7
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: What are files that begin with $$

    Quote Originally Posted by CALocklin View Post
    Let me clarify "it doesn't always happen."

    If Alpha doesn't shut down cleanly, those files probably won't be removed.
    Agreed, and to possibly extend the discussion, it seems the temporary files are somehow tied to the current session. I believe I have noticed that if the sequence of events is

    open application
    perform activities requiring queries to be run, etc
    close application
    temporary files will be deleted, per appropriate setting

    open application
    perform activities requiring queries to be run, etc
    application hangs or is abnormally terminated
    temporary files will not be deleted

    open application
    perform activities requiring queries to be run, etc
    close application
    not all temporary files will be deleted, those from previous session will remain

    So it is not just a proper application exit but rather a proper exit of the session in which the temporary files were created.

Similar Threads

  1. Enter must begin first????
    By Robert Rough in forum Alpha Five Version 7
    Replies: 7
    Last Post: 12-08-2006, 12:22 AM
  2. "Enter must begin first" error message
    By pjfrisch in forum Alpha Five Version 7
    Replies: 2
    Last Post: 05-04-2006, 01:16 PM
  3. Change Begin Invalid Record Number
    By forskare in forum Alpha Five Version 7
    Replies: 0
    Last Post: 01-09-2006, 01:19 AM
  4. enter must begin first
    By Mike Sonntag in forum Alpha Five Version 6
    Replies: 2
    Last Post: 08-17-2005, 02:00 PM
  5. HH:MM begin-end derivation
    By catplus in forum Alpha Five Version 6
    Replies: 4
    Last Post: 08-05-2005, 11:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •