Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Tuesday, November 26, 2024 
 slxdeveloper.com
 Community
 Members
 General
 Architect
 External
 Web
 Downloads
 Resources
11/26/2024 7:26:01 AM







 
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!
 External Development Forums - SalesLogix OLEDB Provider
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix OLEDB Provider | New ThreadView:  Search:  
 Author  Thread: To Use or Not To Use the Provider
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
To Use or Not To Use the ProviderYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jun 07 10:57 AM
We are looking to create a data store/warehouse of opportunity stats (changes to amounts, close dates, etc...) Is there any need to use the provider? Is GMT going to be an issue if I don't use the provider?

Thanks,
John G.
[Reply][Quote]
Frank Chaffin
Posts: 475
 
Re: To Use or Not To Use the ProviderYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jun 07 11:22 AM
Are the store/warehouse tables going to be in the SalesLogix database?

How are users going to view the information?
[Reply][Quote]
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Re: To Use or Not To Use the ProviderYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jun 07 12:48 PM
Currently a skeleton table is residing in the SalesLogix database. Hmm.. now thinking about it I'm wondering if using the provider would be best for security purposes. If I have the seccodeid and accountmanagerid in the custom table, will the provider automatically filter the data based on the logged in user?

Thanks,
John G.
[Reply][Quote]
Frank Chaffin
Posts: 475
 
Re: To Use or Not To Use the ProviderYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jun 07 12:56 PM
I don't think you need the accountmanagerid. I believe you just need the seccodeid (and maybe accountid).
[Reply][Quote]
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Re: To Use or Not To Use the ProviderYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jun 07 1:54 PM
I think you're right, the seccodeid is the only field necessary to apply security.

Would datetime fields be an issue if the provider weren't used?

Thanks,
John G.
[Reply][Quote]
Frank Chaffin
Posts: 475
 
Re: To Use or Not To Use the ProviderYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jun 07 7:20 PM
If users are going to view date information from the custom table via a SalesLogix screen then you should use the provider. However, if that is not the case then don’t use the provider.

In essence, the provider stores date/time information as if the user was sitting in TZ GMT-0. When dates are displayed in the UI the provider adjust the dates based on the TZ on the displaying PC.
[Reply][Quote]
John Gundrum
Posts: 632
Top 10 forum poster: 632 posts
 
Re: To Use or Not To Use the ProviderYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Jun 07 6:12 AM 
the provider stores date/time information as if the user was sitting in TZ GMT-0

If I were to pull the data without using the provider the date/time would be GMT 0 and unadjusted. Any reporting on that data would have to account for the TZ of the PC it is being run on.

Using the provider is sounding more and more likely.

Thanks,
John G.
[Reply][Quote]
Frank Chaffin
Posts: 475
 
Re: To Use or Not To Use the ProviderYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Jun 07 9:04 AM
If you store the date/time information without going throught the provider and view the date/time information without using the provider would will see whatever value you stored.

I am in EST (GMT -5), If it is 6:01:30 AM and I store the current time through the provider what gets written to the database in 11:01:30 AM. When I view the date/time in the UI I will see 6:01:30 AM. Someone setting in PST (GMT -8) will see 3:01:30 AM.
[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 8:24:57 AM