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 - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Using a DataGrid on an modified Insert Opportunity form?

John Hogan
Posts: 13

Using a DataGrid on an modified Insert Opportunity form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Sep 08 12:24 PM

Is there any mechansim for using a DataGrid on a modified insert Opportunity form or to at least mimic the functionality (i.e. let users add items to a datagrid and then update an extension table when the form is saved)? On the Insert Opportunity form, the BindID cannot be set. How are forms created without a base table?

Is the other option to create the "Insert Opportunity" form as a dataform from scratch, or is this not possible?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Using a DataGrid on an modified Insert Opportunity form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Sep 08 12:55 PM

IIRC The Insert Opp form is a manage form, meaning it has no base table and therefore no data binding. Everything on it is scripted. So, if you want a datagrid on it, you write the code to load it at runtime and save whatever changes when it closes.

[Reply][Quote]

John Hogan
Posts: 13

Re: Using a DataGrid on an modified Insert Opportunity form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Sep 08 1:06 PM

Thank you. Is it possible to script a datagrid initially with no entries?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Using a DataGrid on an modified Insert Opportunity form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Sep 08 1:30 PM

Quote:

Originally posted by John Hogan

Thank you. Is it possible to script a datagrid initially with no entries?

Just create your query (with all the fields etc) with a condition like "where 1=0" so no rows load, but you still get the schema from the query.

[Reply][Quote]

John Hogan
Posts: 13

Re: Using a DataGrid on an modified Insert Opportunity form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Sep 08 3:57 PM

Great, thanks. Is there are way to then programmatically populate the grid with data? Without using a recordset? I'm attempting to use SetFieldValue (e.g. dgTeam.SetFieldValue strKeyField, "USERCODE", "JEH", True) but nothing actually appears in the grid.

[Reply][Quote]

Stephen Redmond
Posts: 190

Re: Using a DataGrid on an modified Insert Opportunity form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Sep 08 4:11 PM

Hi John,

When you set up your "dummy" datagrid with the Condition (like "CONTACTID" = "xxxx") and the Layout, clicking the View SQL button will show the SQL Query.

As long as you use the same Fields and names, you can craft your query to return whatever results and then do something like:

dgGrid.SQL.Text = strMyQuery
dgGrid.Refresh

Stephen
www.slxmaster.com

[Reply][Quote]

John Hogan
Posts: 13

Re: Using a DataGrid on an modified Insert Opportunity form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Sep 08 4:50 PM

I can't use SQL.Text. I dynamically create the grid but then would like to use the datagrid simply as a container for information; not read or write any data to the database until the form is closed.
I'm trying to use a datagrid on an insert opportunity form. I'd like to capture the data in the datagrid (and allow users to add, edit and delete rows) when the form is closed and then programmatically write it to the database.

[Reply][Quote]

Stephen Redmond
Posts: 190

Re: Using a DataGrid on an modified Insert Opportunity form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Sep 08 6:11 PM

Hi John,

The DataGrid is quite cool and can be pretty much totally scripted now. You can connect it to a disconnected recordset and use that.

See how the Form "System:Add Edit Sales Order" works. The Products grid there is totally scripted.

Stephen
www.slxmaster.com

[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/25/2025 12:56:10 PM