Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Tuesday, November 26, 2024 
 
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 - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Controls | New ThreadView:  Search:  
 Author  Thread: Lookup is not showing data
gkraju
Posts: 21
 
Lookup is not showing dataYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 29 Oct 09 1:42 AM
i'm trying with senator example using lookup control.
even i have created an entity with table and setted properties of lookup control
(display mode Dialog, entity name senator,lookupbinding mode String, and databindings to primarysenatorid of account entity, display properties to FName and LName)
and added some data to Senator table in backend, but when i see the out put page dialog is appearing but with no data display ie Fname and LName even though data is there.
please any one help me where i have to check.
[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: Lookup is not showing dataYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 29 Oct 09 8:10 AM
Use SLX Profiler for troubleshooting.

It will show you if the SQL Statement couldn't be parsed. If it is parsed but it executes with no data, you will see how SLX built the Statement (Joins to tables, Security Joins, Conditions, etc) and from there you should be able to figure out what is causing it not to return the data you are expecting.

[Reply][Quote]
gkraju
Posts: 21
 
Re: Lookup is not showing dataYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 30 Oct 09 3:48 AM
Quote:
Originally posted by Raul A. Chavez

Use SLX Profiler for troubleshooting.

It will show you if the SQL Statement couldn't be parsed. If it is parsed but it executes with no data, you will see how SLX built the Statement (Joins to tables, Security Joins, Conditions, etc) and from there you should be able to figure out what is causing it not to return the data you are expecting.



i'm fetching data from one table only. i have done codeless customisation as there in developer guide.
[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: Lookup is not showing dataYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 30 Oct 09 8:47 AM
Understood, but with more reason I would suggest you run the SLX Profiler.

At the very least, you would be able to determine if the Lookup query is reaching the database. It may reach the profiler, but fail on parse (on which case it won't reach the DB). Or, it may reach the DB and parse, but the parse statement may not be retreiving data.

Or, the lookup may not be reach even the profiler....


Off course, I would assume that you have done a full rebuild, and deployed in debug mode. Also, that you are reviewing the Event Log for any error entries that may be present.
[Reply][Quote]
gkraju
Posts: 21
 
Re: Lookup is not showing dataYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 31 Oct 09 6:28 AM
Quote:
Originally posted by Raul A. Chavez

Understood, but with more reason I would suggest you run the SLX Profiler.

At the very least, you would be able to determine if the Lookup query is reaching the database. It may reach the profiler, but fail on parse (on which case it won't reach the DB). Or, it may reach the DB and parse, but the parse statement may not be retreiving data.

Or, the lookup may not be reach even the profiler....


Off course, I would assume that you have done a full rebuild, and deployed in debug mode. Also, that you are reviewing the Event Log for any error entries that may be present.



thanks for you kind help.
[Reply][Quote]
gkraju
Posts: 21
 
Re: Lookup is not showing dataYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 31 Oct 09 6:30 AM
Quote:
Originally posted by Gangaraju




thanks to you kind help, can u pls tell me why if i add a new pict list or any control it is giving error that does not impliment interface member with control name like (c:\Inetpub\wwwroot\SlxClient\SmartParts\Opportunity\OpportunityCompetitors.ascx(348): error CS0535: 'ASP.OpportunityCompetitors.OpportunityCompetitorsAdapter' does not implement interface member 'Sage.Form.Interfaces.IOpportunityCompetitors.btnnewcomp'
).
[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 © 2024 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): 11/26/2024 7:28:00 AM