# Introducing Clarion FileManager

**URL:** <https://clarionhub.com/t/introducing-clarion-filemanager/5760>\
**Category:** tips\
**Tags:** c11, filemanager\
**Created:** [December 19, 2022, 3:36pm UTC](https://clarionhub.com/t/introducing-clarion-filemanager/5760 "2022-12-19T15:36:07Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![DonnEdwards](https://clarionhub.com/user_avatar/clarionhub.com/donnedwards/32/1047_2.png) [@DonnEdwards](https://clarionhub.com/u/DonnEdwards)\
**Post date:** [December 22, 2022, 2:29pm UTC](https://clarionhub.com/t/introducing-clarion-filemanager/5760/8 "2022-12-22T14:29:37Z")

</div>

Thanks for the feedback, everyone.

I agree that .Init and .Kill will cause problems when run from a FORM. I mentioned that in the article when doing an example of a button on the form. You only use this when using standalone code, which I was calling from the Menu, not a form which is already using the table in question.

I wasn’t aware of the other SET option, which I will check out.

The help file says that .UseFile should be used before the file is opened.

> The **UseFile** method notifies ABC Library objects that the managed file whose opening was delayed by the LazyOpen property is about to be used. UseFile returns a value indicating whether the file is ready for use. A return value of Level:Benign indicates the file is ready; any other return value indicates a problem. **UseFile** should always be called _before_ a file is opened.

I added a button to the Customer browse, and used an action to call the standalone procedure as a new thread. I didn’t get any errors or exceptions in debug mode. maybe because it was a separate thread?

> [@How does MSSQL organize Record Data on disk in the database?](https://clarionhub.com/t/how-does-mssql-organize-record-data-on-disk-in-the-database/5766/4):
>
> Here is a free class/video on the concepts. If you are working with MSSQL, it is well worth your time, IMO.

Brent Ozar is brilliant. He wrote a [series of tests](https://www.brentozar.com/sql/sql-server-performance-tuning/) you can run on MSSQL Server to make sure it is running well. Saved me a lot of trouble.

---

_[View the full topic](https://clarionhub.com/t/introducing-clarion-filemanager/5760)._
