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 Thread

View: Search:

Author

Thread: LAN Grid: Displaying non SLX data (a recordset): Operation is not allowed when the object is closed. Error

RJ Samp
Posts: 973

LAN Grid: Displaying non SLX data (a recordset): Operation is not allowed when the object is closed. Error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 10 Jun 09 3:37 PM

Am retrieving a recordset and applying it to a grid that I'm building the columns for. Data displays just fine. When I click on the grid, I get an error. Same kind of error when you try to inline edit a mutiple table joined row using left outer join.

I have a unique rowid (1,2,3,4,5,6,7,8...).....have tried to place the field name into KEYFIELD with no luck. I can look at each row in the datagrid recordset, add up fields, fire off OnCustomDrawCell, etc.

Basically I think SLX is looking for a key table and key field based on SalesLogix tables.....when I've done this in the past, I've been able to start with the A1 base table pointing at Opportunity Product, etc. Here the A1 table could be Account, keyfield AccountID and simply repeat the row ID Valuess.....SLX ignoring SecondaryKey Field not in the A1.Table.....but I'm still getting the error.

Tried setting ActiveConnection to Nothing, which works fine as a disconnected recordset, but still get the error on the grid.

Basically rs.Open "Select RowNo, B, C, D, F from AARDVARK "
SET Grid.RecordSet = RS

RowSelect is true, don't post changes, readonly is true.....no events other than OnCustomDrawCell (and was getting the error prior to that).

Any ideas?

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: LAN Grid: Displaying non SLX data (a recordset): Operation is not allowed when the object is closed. Error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 10 Jun 09 4:07 PM

What is the actual error that you are getting?
Also, it may be because SLX is expecting a String to be used as the Unique Row ID, I seem to recall running into a similar issue in the past.
Also, did you copy the Columns definition from Somewhere else? Is it possible that there is something on the Column definition that is leading to this error?

[Reply][Quote]

RJ Samp
Posts: 973

Re: LAN Grid: Displaying non SLX data (a recordset): Operation is not allowed when the object is closed. Error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Jun 09 2:42 PM

Looked into both of those issues, still couldn't resolve. Finally stopped closing the underlying data set and all is fine.

So basically:
Set Grid.RecordSet = RS
RS.Close

gave me the error when you clicked on the grid.

I thought that the set made a 'copy' of the recordset and mapped it into the grid.

[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/26/2024 11:41:50 AM