RE: [RBASE-L] - Determining Current Row in Enhanced DB Grid
Karen, Thank you SO MUCH. With your help and lots of caffeine I think I’ve got it. Paul From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: August 23, 2017 9:16 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Determining Current Row in Enhanced DB Grid Yeah, let's say your grid is based on a table called Clients and there's a PK column called ClientID. Just create a form variable: vClientID = ClientID So if they click anywhere in that row, the vclientID will hold the value of the PK column in that row. So if they click a button that then says "update" or whatever, you just grab the vClientID to see what row they had clicked in. I do that all the time. Just to verify, I always put a dialog box to the user something like: "Do you want to update the record for ClientID: mailto:p...@buckleyandassoc.com> > To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Wed, Aug 23, 2017 7:55 am Subject: RE: [RBASE-L] - Determining Current Row in Enhanced DB Grid Karen, I guess I haven’t had enough coffee yet, you said “then just create a form variable to capture the PK of the row they're on”. That’s what I’m struggling with. The user can click any cell in the grid in a given row. What I’d like to do is set a variable to the primary key column for that row. If they change anything in the row the dirty flag is set and I can update my tables accordingly. Thanks in advance for any assistance, Paul Buckley From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com?> ] Sent: August 22, 2017 5:34 PM To: rbase-l@googlegroups.com <mailto:l...@googlegroups.com> Subject: Re: [RBASE-L] - Determining Current Row in Enhanced DB Grid Are they clicking into a particular row in the Grid to change? If so, then just create a form variable to capture the PK of the row they're on Karen -Original Message- From: Paul C. Buckley <p...@buckleyandassoc.com <mailto:p...@buckleyandassoc.com> > To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Tue, Aug 22, 2017 3:44 pm Subject: [RBASE-L] - Determining Current Row in Enhanced DB Grid Good afternoon, I'm probably making this much harder than it needs to be but I can't figure out what to do. I'm using the latest R:BASE X Enterprise and I have an Enhanced DB grid based on a single table view. I have a column in the table/view that I want to set if the user changes anything in the row. There is an update button on the form that updates the data in an attached SQL table based on only the rows in the R:BASE table that have changed. I'm struggling with how to change the update flag column using the RBTI_DIRTY_FLAG. I'm looking for something like the "Where current cursor" option in Declare Cursor. Any suggestions would be greatly appreciated. Thanks, Paul Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Determining Current Row in Enhanced DB Grid
Yeah, let's say your grid is based on a table called Clients and there's a PK column called ClientID. Just create a form variable: vClientID = ClientID So if they click anywhere in that row, the vclientID will hold the value of the PK column in that row. So if they click a button that then says "update" or whatever, you just grab the vClientID to see what row they had clicked in. I do that all the time. Just to verify, I always put a dialog box to the user something like: "Do you want to update the record for ClientID: To: rbase-l <rbase-l@googlegroups.com> Sent: Wed, Aug 23, 2017 7:55 am Subject: RE: [RBASE-L] - Determining Current Row in Enhanced DB Grid Karen, I guess I haven’t had enough coffee yet, you said “then just create a form variable to capture the PK of the row they're on”. That’s what I’m struggling with. The user can click any cell in the grid in a given row. What I’d like to do is set a variable to the primary key column for that row. If they change anything in the row the dirty flag is set and I can update my tables accordingly. Thanks in advance for any assistance, Paul Buckley From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: August 22, 2017 5:34 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Determining Current Row in Enhanced DB Grid Are they clicking into a particular row in the Grid to change? If so, then just create a form variable to capture the PK of the row they're on Karen -Original Message- From: Paul C. Buckley <p...@buckleyandassoc.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Tue, Aug 22, 2017 3:44 pm Subject: [RBASE-L] - Determining Current Row in Enhanced DB Grid Good afternoon, I'm probably making this much harder than it needs to be but I can't figure out what to do. I'm using the latest R:BASE X Enterprise and I have an Enhanced DB grid based on a single table view. I have a column in the table/view that I want to set if the user changes anything in the row. There is an update button on the form that updates the data in an attached SQL table based on only the rows in the R:BASE table that have changed. I'm struggling with how to change the update flag column using the RBTI_DIRTY_FLAG. I'm looking for something like the "Where current cursor" option in Declare Cursor. Any suggestions would be greatly appreciated. Thanks, Paul Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Determining Current Row in Enhanced DB Grid
Karen, I guess I haven’t had enough coffee yet, you said “then just create a form variable to capture the PK of the row they're on”. That’s what I’m struggling with. The user can click any cell in the grid in a given row. What I’d like to do is set a variable to the primary key column for that row. If they change anything in the row the dirty flag is set and I can update my tables accordingly. Thanks in advance for any assistance, Paul Buckley From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: August 22, 2017 5:34 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Determining Current Row in Enhanced DB Grid Are they clicking into a particular row in the Grid to change? If so, then just create a form variable to capture the PK of the row they're on Karen -Original Message- From: Paul C. Buckley <p...@buckleyandassoc.com <mailto:p...@buckleyandassoc.com> > To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Tue, Aug 22, 2017 3:44 pm Subject: [RBASE-L] - Determining Current Row in Enhanced DB Grid Good afternoon, I'm probably making this much harder than it needs to be but I can't figure out what to do. I'm using the latest R:BASE X Enterprise and I have an Enhanced DB grid based on a single table view. I have a column in the table/view that I want to set if the user changes anything in the row. There is an update button on the form that updates the data in an attached SQL table based on only the rows in the R:BASE table that have changed. I'm struggling with how to change the update flag column using the RBTI_DIRTY_FLAG. I'm looking for something like the "Where current cursor" option in Declare Cursor. Any suggestions would be greatly appreciated. Thanks, Paul Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Determining Current Row in Enhanced DB Grid
Good afternoon, I'm probably making this much harder than it needs to be but I can't figure out what to do. I'm using the latest R:BASE X Enterprise and I have an Enhanced DB grid based on a single table view. I have a column in the table/view that I want to set if the user changes anything in the row. There is an update button on the form that updates the data in an attached SQL table based on only the rows in the R:BASE table that have changed. I'm struggling with how to change the update flag column using the RBTI_DIRTY_FLAG. I'm looking for something like the "Where current cursor" option in Declare Cursor. Any suggestions would be greatly appreciated. Thanks, Paul Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.