It's a long, complicated tale, full of terror and woe. Basically, I have no idea where to put the files (the documentation is no help with this question; it mentions building a library of code but doesn't say where to put it, or offer any guidance on naming conventions), so I stuck with naming them like sbasic_include.sbas, with underscores and a .sbas extension, and then tried putting them in different places, in this folder, in that. Eventually I hard coded paths into my programming (for example
#include "F:\Sesame\Includes\SUBROUTINE_CustomerDiscount_Include.sbas"
which seemed to work fine from a workstation client but crashed the app with sbasic errors when a client was run run on the server, of course, because the server doesn't know where F is.
I tried changing my "Start In" folders, did this and that, and so on. Finally after the seventh or eighth db lockup (requiring unloading at the server before I could unlock; the dsr locked up a couple of times as well, though that didn't need unloading, of course) I decided to go back to the app that worked 2 days ago, whose only #include is sbasic_include.sbas, which I have littered
everywhere.
I think I still have my Start In settings messed up. All my lookups and @Inserts stopped working for a while. My current personal workstation client Start In folder is F:\Sesame\Miara and on the server (for my client on the server) it's C:\Sesame\Miara, and this seems to be working. However, my 3 other workstation clients, which only access Employee.db (which has no lookups) start in C:\Sesame, and
they seem to be working OK too.
After my headache goes away I think I'll try removing sbasic_include.sbas from all the folders that it's in, then putting it back into one folder at a time, testing the app each time to find out which one works. I think if I can do that I'll know where to put the .sbas files I've made from my functions and subroutines.
Meanwhile, while all this was going on our Verizon FIOS was down and they couldn't give me any idea what the problem was or when it would be fixed, so not only did I have no way of asking for help here I also had to put up with calls from everyone in my company about
that "When is the internet going to be up? I have to send payroll withholding figures to the Federal Government/look up a phone number for an important client/send my mother an email asking her if the cat is still wheezing/surf the web looking for naughty pictures of librarians, etc." Sigh. I need a vacation.
OK. Rant over. I'll bet you're sorry you asked, huh?