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: Key field property on datagrid

Bill
Posts: 71

Key field property on datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 May 08 2:52 PM

I have a tab control that has two datagrids on the same tab. The first grid is a fee's grid and the second is a payments grid. The keyfield for the fee's grid is attendee_feeid and the keyfield for the payments grid is attendee_paymentid. When I open the screen the fee's grid is populated with the correct records and the payments table is empty. If I change the keyfield property on the payments table to attendee_feeid the payments grid populates with the correct data also. The keyfield of attendee_feeid does not exist in the table used to populate the payments grid. When I try to delete a record from the payments table I receive an error stating Invalid column name: attendee_feeid. The delete script I wrote fires on the OnDeleteRow event. The properties of the grid are identical to the fee's grid outside of the keyfield property and the fee's grid is working properly. Any ideas??

We are running v6.2.6.

Thanks.....

[Reply][Quote]

Snow Monkey
Posts: 214

Re: Key field property on datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 May 08 2:54 PM

code pls.

Or throw an error onrowdelete event and then step thru the code and see what happens.

[Reply][Quote]

Bill
Posts: 71

Re: Key field property on datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 May 08 3:33 PM

Const MB_YESNO = 4
Const IDYES = 6
Const IDNO = 7
Const MB_DEFBUTTON1 = 0
Const MB_ICONQUESTION = 32
Dim strAttendeePaymentId
Dim strDialog
Dim intResponse
Dim strMsg
Dim strSQL

strAttendeePaymentId = dgAssociatedPayments.GetCurrentField("tr_attendee_paymentid")
strMsg = ("Would you like to delete this Associated Payment record?")
strDialog = MB_YESNO + MB_ICONQUESTION + MB_DEFBUTTON1
intResponse = MsgBox(strMsg, strDialog)
If intResponse = IDYES Then
strSQL = "delete " & _
"from tr_attendee_payment " & _
"where tr_attendee_paymentid = '" & strAttendeePaymentId & "'"
End If
If intResponse = IDNO Then
dgAssociatedPaymentsDeleteRow = false
exit function
End If

[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/23/2025 6:03:41 PM