Confused about volumes and drive names

Getting Started
1

Using a Mac Pro with Big Sur and a MacBook Pro with Mojave.

I have a portable USB drive with a SQLite database on it that I need to use with a Xojo application that I have on both computers.

What is the easiest way to create a folderitem without a complicated process to find the volume number of the drive since it won’t be the same (probably) between the 2 machines. Or can I somehow create a folderitem with just the drive name? The drive is named CSS for example.

Or am I missing something obvious - which is usually very possible.

2

You are missing the obvious: on macOS volume numbers never mattered. Select the drive by name. Finished.

3

We usually loop over volumes and look for the one with right name.

4

Then you reference it as /Volumes/CSS

5

What is CSS ?
(Instead of Cascading Style Sheet, of course)

Also, beware, usually (built-in) disks names are “Macintosh HD” while USB drive can be anything (and all of these can be renamed).

6

The example name of the drive in the OP

7

Thank you.