Wrote

I am trying to upload the plugin to the extension manager.
http://smath.info/upload/Extensions.aspx redirects me to http://smath.info/ReleaseManager/ which unfortunately results in a Server Error for me ExtensionManagerError.zip (1 KiB) downloaded 102 time(s).
Would anyone happen to know how to get around this?

Wrote

Hello.

SQLLite Plug-in can be installed using Extensions Manager only starting from SMath Studio 0.98.6089. Previous versions of the program cannot install this plug-in correctly. I would highly recommend you to upgrade.

BTW: If you see error message with "GUID: 00000000-0000-..." then you are using old version of the plug-in. Please delete it and install latest one using Extensions Manager with SMath Studio 0.98.6089 or higher.

Best regards.

1. Have the plugin installed from the Extensions Manager
   
2. Open the worksheets created with old versions of the plugin
   
3. Skip the error messages
   
4. Recalculate
   
5. Save & close the worksheet (program restart not required)
   
6. Open it again

Wrote

Thanks, Davide. That does eliminate the zero GUID error on subsequent opens of those worksheets,

Wrote

although the "Unable to open database file" error is still present. Recalculating, saving and reopening, changing variable names, nothing I've tried seems to help.

Wrote

Please note that if you double-click the .sm, then SMath opens with the directory where the .sm located as current path; so all subsequent relative paths will be searched under this directory. But if you start SMath from, say, desktop shortcut, and then open the .sm from it, then current directory will be that was specified in the shortcut. The same will happen if you opened SMath by double-clicking one .sm, (and its path is now current directory), and then from that SMath open another .sm from another directory: the second directory won't be current one.

So, using relative paths in SMath is error-prone. If SMath for each .sm would make its own current path as one where the file is, regardless of opening method, then it would be good. For now, I wouldn't advise anyone to use relative paths.

1. Check if path is rooted (absolute); if yes go to step 3, otherwise go to step 2;
   
2. If the path is relative, build an absolute path;
   
3. Use the output path

string path = "whatever";
// internal checks: a filename is specified, etc, etc, ...
path = Environment.ExpandEnvironmentVariables(path);
if (!String.IsNullOrEmpty(context.FileName) && !Path.IsPathRooted(path))
   path = Path.Combine(Path.GetDirectoryName(context.FileName), path);
// use path

Wrote

Please note that if you double-click the .sm, then SMath opens with the directory where the .sm located as current path; so all subsequent relative paths will be searched under this directory. But if you start SMath from, say, desktop shortcut, and then open the .sm from it, then current directory will be that was specified in the shortcut. The same will happen if you opened SMath by double-clicking one .sm, (and its path is now current directory), and then from that SMath open another .sm from another directory: the second directory won't be current one.

So, using relative paths in SMath is error-prone. If SMath for each .sm would make its own current path as one where the file is, regardless of opening method, then it would be good. For now, I wouldn't advise anyone to use relative paths.

Wrote

SQLLite Plug-in can be installed using Extensions Manager only starting from SMath Studio 0.98.6089 Previous versions of the program cannot install this plug-in correctly.

Wrote

But this is even poor implementation in the plugin and can be solved easily (fix the same issue yesterday in my WriterRegion)

string path = "whatever";
// internal checks: a filename is specified, etc, etc, ...
path = Environment.ExpandEnvironmentVariables(path);
if (!String.IsNullOrEmpty(context.FileName) && !Path.IsPathRooted(path))
   path = Path.Combine(Path.GetDirectoryName(context.FileName), path);
// use path