<<snip>>> > Thanks for sharing the code. What's version of firebird do you use? > Is it your own table Mac$Tokens? > > -- > Best regards, > Alexander >
Alex, This routine is independent of Firebird version. Table Mac$Tokens is a single column table that is my own table. I use a convention that tables that I use internally are prefaced Mac$ and user data tables are called - Invoices, Customers etc. This helps me to segregate tables during design. It also allows me to have db templates that I can build on for new projects. The boundary is flexible, for example Mac$Folders holds my root folder set and also holds details of user created folders. And user data normally refers to user created and system folders. Each of my deliverables has a control panel (like windows) and the tools available (User manager, function manager, group manager, backup and restore, some db sanity tools, etc) vary by user. Now I am developing ways to add tools without delivering the whole program set including ways to allow approved 3rd party extensions. Then I expect a recycle bin/unerase and auditing tools will be simple. All of my product is gui including controlled drag and drop, delete and undelete. Mick
