Hi Tom!! Took me a while to adopt this method, but now I incorporate it
in all my apps. Especially now that I embed the code within the form itself,
I found that there were a bunch of places where I needed to call the same
block of code (like searching for a customer).
I have a table called CommonCode.
Table: CommonCode No Lock(s)
No. Column Name Attributes
--- ------------------
------------------------------------------------------
1 CCID Type : INTEGER AUTONUMBER
Index : SINGLE-COLUMN
2 CCName Type : TEXT 15
3 CCData Type : LONG VARCHAR
My CCName column has a description, like "GetAcct" or "GetItem". The
CCData is where I type in the command file. I usually create a temporary
command
file first to debug it, then copy and paste it into the table.
You call it by RUN SELECT ccdata FROM commoncode WHERE ccname = 'GetAcct'
Karen
> Is there a way to store RMD files within a database and retrieve them for
> use? Our audit system uses EEPs that all share an identical blocks of
> commands that (once the light bulb went on in my head) can be done through an
> RMD. Looking in the SAT examples shows many RMDs in a file format. That
> seems to allow something to get ‘lost’ or ‘changed’, but storage within the
> database makes portability much easier. I recall reading about this but
> cannot find it help files or stored emails. Any suggestions?
>
>
>
>
>
