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!

Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New Thread

View: Search:

Author

Thread: [7.5.1] Refresh quickform after a synchorinzation with 3th party database

dl@megabyte.be
Posts: 14

[7.5.1] Refresh quickform after a synchorinzation with 3th party database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Apr 09 4:28 AM

Hi,

I have developed a synchro between my SQL SLX Database and an Access database.
Purpose is to regularly update some Opportunity fields in SLX.

My problem is: when a user makes a F5 just after a synchro, the new datas are not visible (the previous data are still showned).
The user has to wait several minutes.

How can I force a real refresh of all fields of my entity?

Thanks
Damien

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: [7.5.1] Refresh quickform after a synchorinzation with 3th party database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Apr 09 10:13 AM

If the data isn't reloading in the entity after an F5 then something else is wrong, or maybe the timing is different than what you're expecting. If the F5 isn't showing the changed data then nothing will.

As far as programatically reloading an entity, you could just do a Response.Redirect to navigate back to the same page they are on, basically reloading the page. That should reload what the entity currently has, I've never seen any kind of caching that would make the entity not show the current data right away with a page reload. If you wanted to just refresh a part of the page then you could use the PanelRefreshService - something like this (to refresh the Tab workspace)

Sage.Platform.WebPortal.Services.IPanelRefreshService refresh = 
        PageWorkItem.Services.Get();

refresh.RefreshTabWorkspace();

[Reply][Quote]

dl@megabyte.be
Posts: 14

Re: [7.5.1] Refresh quickform after a synchorinzation with 3th party database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Apr 09 11:16 AM

I already tried this code but unsuccessfully.
I made a simple test.

I modified the field "fax" in the database (contact) and then I have pressed F5. The new data wasn't showed.

Maybe something in IIS or web.config to change?

Thanks

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: [7.5.1] Refresh quickform after a synchorinzation with 3th party database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Apr 09 11:29 AM

Quote:

Originally posted by dl@megabyte.be

Maybe something in IIS or web.config to change?

Could be. It doesn't work this way on any of my SLX web systems (I hit F5 and the new data shows immediately, even if edited outside of SLX).

How exactly are you updating the data?

[Reply][Quote]

dl@megabyte.be
Posts: 14

Re: [7.5.1] Refresh quickform after a synchorinzation with 3th party database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Apr 09 3:49 AM

My query in SQL server management studio is : update sysdba.account set fax='1111' where accountid='A6UJ9A0000NN' (via slx oledb provider)

I press F5 in my browser and I sill got my old value.
After several minutes (and refresh) I got the new value

I have observed with the slxprofiler that the query who is getting the data’s back is not executed every time it should

Thanks

[Reply][Quote]

Timmus Agersea
Posts: 328

Re: [7.5.1] Refresh quickform after a synchorinzation with 3th party database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Apr 09 10:35 AM

Do you have your broswer set to "Check for newer versions of stored pages: Every Time I Visit the Page"?

Timmus

[Reply][Quote]

dl@megabyte.be
Posts: 14

Re: [7.5.1] Refresh quickform after a synchorinzation with 3th party database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Apr 09 11:44 AM

Yes it is.

I created a workaround to avoid this problem (Business rules + external assemblies) but I would like to find the right solution.

[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 \|

page cache (param): 8/18/2025 10:43:10 PM