Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, August 23, 2025 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Scripting & Customization | New ThreadView:  Search:  
 Author  Thread: Problems with main view - but only certain users
Alec Denholm
Posts: 23
 
Problems with main view - but only certain usersYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 13 Mar 08 12:04 PM
Hi,

I've got a problem with a main view I've made. It's based on the userinfo table, so when you log in you're essentially seeing only your record. The problem is that although the main view works fine for existing users, it shows 'No Records to display' for any of the 7 new users I created to test it with. At the moment there is very little on the form, as I've only just started developing. i.e. there are no bound fields apart from one for userid and username, both based off the userinfo table so obviously they exist for both users.

Can anyone suggest why my new users can't see this screen but the old ones can?

Thanks,

Alec D
QGate Software
[Reply][Quote]
Matt Dockins
Posts: 159
 
Re: Problems with main view - but only certain usersYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 13 Mar 08 1:00 PM
how did you add the users, through Administrator I hope, correct?

Generally you get the 'No Records to display' message when you've used an inner join to bind a field when there is no data in the corresponding table - I know you said there are only 2 controls on the form though so this might not be it.

You should also check and make sure that those 7 new users have an address, the nature of the address relationship can also cause this if an address is missing.
[Reply][Quote]
Alec Denholm
Posts: 23
 
Re: Problems with main view - but only certain usersYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Mar 08 4:46 AM
Thanks for the reply Matt.

I added the users through SLX Administrator, yes; as in Add Users, Network Users x7 (which gives me "Newuser000[1-7]"). After that I changed their Title to 'Test User' and gave them usernames/passwords.
They appear to have addresses - at least, running this SQL...
"select * from address where addressid in (select addressid from userinfo where title = 'Test User')"
...returns 7 address for my 7 users' entityIDs, though the addresses are blank of course - does this matter?
I still doubt this is a bound field issue as userid and username are of course present; but to remove any possibility of doubt I've unbound all fields, and commented out what little code their was from the detail view. Still no luck getting it to show though...
Because of the now absolute simplicity of the main view, I think it can only be an issue with the users I've created.
[Reply][Quote]
Matt Dockins
Posts: 159
 
Re: Problems with main view - but only certain usersYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Mar 08 10:58 AM
I just thought about this - do you have a group setup? What fields are in the group? It may be that a join in the fields in the group are causing this issue and not a bound field on the screen.
[Reply][Quote]
Alec Denholm
Posts: 23
 
Re: Problems with main view - but only certain usersYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Mar 08 11:48 AM
It was a group issue! Thanks, great suggestion.

I'd have saved myself a lot of trouble if I hadn't hidden the mainview's caption bar this early in the development; I'd have seen I was looking at a group with no one in it...

Thanks again,

Alec
[Reply][Quote]
Matt Dockins
Posts: 159
 
Re: Problems with main view - but only certain usersYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Mar 08 11:50 AM
Always glad to help.
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 8/23/2025 6:24:49 AM