Code Executes Perfectly in Developer NOT in Client...

The following code works perfectly in Developer, not a hitch. I’ve watched it execute line by line.

It will not work at all Client.

It’s part of my security system…

Any ideas?

var x = security.getUserName()

forms.users.controller.find()
forms.users.security_name = security.getUserName()
var found = forms.users.controller.search()

if(forms.users.passwords == ‘Yes’)

//if I’m logged in then show my working fields and labels
{
elements.lbl_user_profiles.visible = true;

}
else
//otherwise, hide my admin:password labels
{
elements.lbl_user_profiles.visible = false;

}

I notice that the client is much pickier than the developer.

I had similar issues on my solution in the past. I also used to put my repository in the same database as my data connection. I had to reboot the servoy apps server and the glitch fixed itself.

However, after speaking with Bob Cusick, I separated my repository and data connections and haven’t had much probelm since. I’m using MS SQL server 2000.

sammyzheng:

I’m also using MS SQL 2K as one of the backend databases with a third party driver, Sprinta.

Turning on Java Web Start Console let me look at what the errors are in Client, however, it did not tell me why, say, a field on a form was recognized in a method in developer and not when that method executed in Client.