I see this FSTATUS as being very useful! Thanks Regards Lena
Lena Dammstrom Software Developer Email:[email protected] Toll Free:800-446-2500 International: 01 630-529-7111 Extension: 1037 www.qmiusa.com This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -----Original Message----- From: [email protected] <[email protected]> On Behalf Of A. Razzak Memon Sent: Thursday, August 22, 2019 8:05 AM To: [email protected] Subject: [RBASE-L] - Tip of the Day: Using the New FSTATUS Function Thursday, August 22, 2019 Tip of the Day: Using the New FSTATUS Function Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) Build.........: 10.5.1.30822 or higher Sections......: Functions Keywords......: File, Folder, Hidden, Read Only, Open Did you know you can check to see if a file exists, and also the file status? The new FSTATUS function has been implemented to check if a file or folder exists, and also returns the status for the file. The read only, opened, available, and hidden file status can be retrieved. If no path is specified, the function checks for the file or folder name in the current directory. Otherwise, the function checks for the file or folder name in the specified location. The function returns following possible values: 0 = file/folder does not exist 1 = file/folder exists, but cannot be read or written to. Folders will return this value, as well as file name searches with wild cards. 2 = file is marked as a read only file 3 = file is not marked as read only, but can only read it at this time (the file is opened by another program) 4 = file can be read and written to If the file is marked as hidden, the return value will be incremented by 10; 12 = read only and hidden, 14 = can read and write and hidden Example (The brates.xlsx file exists, is marked hidden, and is opened): SET VAR vFileStatus INTEGER = (FSTATUS('brates.xlsx')) SHOW VAR vFileStatus 13 In many applications, the ability to know if a file is open is quite important. For example, when using the GATEWAY command and verifying a spreadsheet is not already open is very beneficial. Very Best R:egards, Razzak. https://www.rbase.com http://www.facebook.com/rbase/ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/201908221304.x7MD4q5t119367%40atl4mhob23.registeredsite.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BL0PR16MB23232CAEFD3F9C8E73783AD7B9A50%40BL0PR16MB2323.namprd16.prod.outlook.com.
