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 Thread

View: Search:

Author

Thread: problems when using a datareader with SLX

Shane
Posts: 38

problems when using a datareader with SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Dec 07 5:54 PM

sO I was trying to implement pagination with SLX and noticed that for some reason everytime I changed pages the data wouldn't change...until I got to like page 6 or 7.. Well I was really confused so I went through a SQL Provider instead and it worked FINE.. Finally I boiled the problem down to:

1) you have to read data from the data reader in order for it to move on
so just doing for() reader.Read()

Won't move on to the next record you have to read a piece of data from the reader
for() { Response.Write(reader["data"]); reader.Reader() };
does work

2)
or if you iterate across it like 50 times it causes it to finally move
That's why pages 1 through 5 would show the same data but 6 and on would finally change

is that just what I have to do? Or is there a setting missing?

shane

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: problems when using a datareader with SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Dec 07 10:09 AM

What version of SLX is this? This will likely work in v7.2 as I was told that changes were made to the provider to better support pagination from the SLX web client as well.

[Reply][Quote]

Shane
Posts: 38

Re: problems when using a datareader with SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Dec 07 11:02 AM

is there anywhere this is documented so I can read up on it?

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: problems when using a datareader with SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Dec 07 4:04 PM

AFAIK.. Not Documented..
--
rjl

[Reply][Quote]

Shane
Posts: 38

Re: problems when using a datareader with SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Dec 07 5:30 PM

"Not Documented"
i've found that to be a big problem in general

and upgrading stuff to 7.2 fixed the pagination problem
yay

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: problems when using a datareader with SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Dec 07 9:52 PM

Quote:

Originally posted by Shane

"Not Documented"
i've found that to be a big problem in general

and upgrading stuff to 7.2 fixed the pagination problem
yay

Documentation. That's always been a problem with SLX. Glad to hear that the upgrade to 7.2 fixed the problem.

-Ryan

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

page cache (param): 11/22/2024 9:55:19 PM