Hello, I'm trying to use @GetLocalEnvVar(evar) and it doesn't seem to be working right.

Here is/was my working code:

var vName as String
var vUser as String
var vFolder as String

If @Mode() = 0 or @Mode() = 1
{
	vName = Record_ID
	vUser = @Del(@GetLocalEnvVar("HOMEPATH"), 1, 7)
	vFolder = "C:\Users\" + vUser + "\Google Drive\AAction Photos\" + vName
}
 

As you can see, I'm using the Windows Environment Variable HOMEPATH which returns:

 \Users\{username}
 

What's strange is that it worked the first few times I used it, everything was working perfectly. Even used WriteLn() to check it to make sure it was returning the string I wanted. However, I ran into Sesame crashing and locking a record when I ran the program (@Shell()) so I closed it out, and ran Sesame as administrator by default, but now it won't run at all. Either in Sesame Designer or Sesame Client. Not sure what went wrong.

Turns out, it works fine running on the local computer on Sesame Designer, but when running it through the Server environment on a client it doesn't work. I'm not sure why this is, but I think the code is looking at the Server Environment and not the Local Environment. In which case, I need a way to force it to look at the Local environment at least for some aspects of the code.

One of the things that caused it not to work in my previous post, is I changed the shortcuts for Sesame and Sesame Designer to run as administrator thinking that would help, but all kinds of weird things happened. Word Merge didn't work right, it would open Word without my settings or Macros. When I printed HTML preview reports it would open in a different version of Google Chrome rather than my default user. And etc. I'm not sure why that is. But I changed both shortcuts back to how they were, to run as regular. Now trying to figure it out from the code side.

actiontech wrote on Mar 14^th, 2018 at 2:11pm:


What do you mean by "Server environment on a client"? Sbasic runs on the client side with the exception of programmed retrieve specs, Mass Update on the Engine, and maybe another very specialty case that I can not recall. The command @GetLocalEnvVar() gets the Client or Standalone environment variable and @GetServerEnvVar() gets the named  environment variable from the Server.

Quote:

I'd be willing to bet it was because Sesame was not running as You(Your User Account) so when Sesame asks the OS for things such as the default .HTM handler, what's returned would not necessarily be the same as Your default .HTM handler.

-Ray

That is because Image boxes(and Static image elements) are pathed from the Server.

-Ray