11/26/2024 3:25:15 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!
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
|
|
|
|
Setting Grid SQL.TEXT results with Grid Recordset as Nothing
Posted: 19 May 10 9:06 AM
|
We have an interesting issue on an upgraded database to SLx 7.5.2 LAN.
On this particular database there are some custom Data Grids which are performing ridiculously slow when sorting be column header. We located the post(s) by RJ Samp (Thanks RJ) and applied to a grid. Also on these grids we have some filters which work by altering the SQL and refreshing the Grid (I know that the refresh is not necessary). Now we found that after sorting, when a filter is applied the Grid has a Recordset of Nothing when the grid's SQL.Text is changed.
We have narrowed it down to being down to when a variable is set to the Grid's recordset and then the grid recordset being set to that variable, so...
set rsGrid = Grid.recordset
Grid.Recordset = rsGrid
Grid.SQL.Text = strSQL ' (at which point the Grid.RecordSet = Nothing)
Has anybody seen this behaviour, or can suggest how to fix/avoid?
Many thanks in advance
James
|
|
|
| |
| |
| |
|
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!
|
|
|
|
|
|
|
|