I also use the RUN SELECT from a table named InternalCode.
In addition to the command name and code columns, I track:
Last date modified: Ctrl-F2 duplicates a row; I append YYMMDD to the
current version and then update the other row.
Database in which it's used: some are db specific, some are generic used
in multiple dbs.
Brief description: Also a few words of update history.
All columns are updated manually.
And, yeah, some of the old rows could be deleted after the current code
has been successfully run "for a while".
Doug
On 2/18/2025 4:39 PM, 'Karen Tellef' via RBASE-L wrote:
Excellent point, Javier.
If it was me, I'd store the code in a table and call it from all
relevant forms rather than creating custom form actions. I always
have a table called CommonCode, with a text identifier column and a
Varchar column. That way it can be called:
RUN SELECT ccdata FROM commoncode WHERE ccname = 'action'
An advantage to this is that the code is immediately available in a
production environment. If you were to modify a custom form action,
all users would have to exit the form and come back in before getting
the new code (which would probably be necessary if the CFA is on a
"main menu" type of form)
Karen
On Tuesday, February 18, 2025 at 04:32:14 PM CST,
<[email protected]> wrote:
I have several forms that spawn MIDI forms, and I believe I do call
custom actions on the Main form from MIDI forms, but I would have to
verify it.
When I have utilities or code that would be called from multiple
forms, MIDI or not, I usually save the code as a stored procedure
which I can call from anywhere and I don’t have to duplicate the code;
also, when updating the code, you only have to do it in one place
rather than in each individual form. It all comes down to personal
preference.
Javier,
Javier Valencia, PE
14315 S Twilight Ln
Olathe, KS 66062
913-915-3137
*From:*'Karen Tellef' via RBASE-L <[email protected]>
*Sent:* Tuesday, February 18, 2025 8:50 AM
*To:* [email protected]
*Subject:* Re: [RBASE-L] - Custom form actions
Tom: I looked in my notes (I've never tried this) and I had this in there.
-- You can call a form's custom form action from another form if you
bring it up in MDI
PROPERTY 'MDI_TopFormName|RBASE_FORM_ACTION' cfaname ' '
I'm not sure if this is still the case -- whether the second form has
to be called up in MDI
Karen
On Monday, February 17, 2025 at 06:18:04 PM CST, Tom Hart
<[email protected]> wrote:
If I define a custom form action in an Extrenal Form will that carry
through to all forms related to that external form?
Tom Hart
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/CABX9BNdmEbSZ-W3sLY04zp321AKCS5VrhjdjG3jhE_3t2828Qw%40mail.gmail.com
<https://groups.google.com/d/msgid/rbase-l/CABX9BNdmEbSZ-W3sLY04zp321AKCS5VrhjdjG3jhE_3t2828Qw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1090776787.1276535.1739890195698%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/1090776787.1276535.1739890195698%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/01a601db8254%24f271ce50%24d7556af0%24%40vtgonline.com
<https://groups.google.com/d/msgid/rbase-l/01a601db8254%24f271ce50%24d7556af0%24%40vtgonline.com?utm_medium=email&utm_source=footer>.
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/2023109573.1477789.1739918341934%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/2023109573.1477789.1739918341934%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
This email has been checked for viruses by Avast antivirus software.
www.avast.com
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/91b73d5a-cd61-4f42-b135-5fc9f37e65f2%40wi.rr.com.
