Les:
I used to work in a shop where we built a custom form that would list the available schemas, the schemaid. This was done through an SQL Menu. Clicking on one of the available schemas gave you the current value of the nextid. This was for testing so we could step backwards and forwards through a to see another field on a different form.
James McKenzie
L-3 GSI
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [EMAIL PROTECTED]
Sent: Monday, October 23, 2006 12:10 PM
To: [email protected]
Subject: Re: Enhancement: Schema ID on AR Admin tool...
ARUtilities lists all the schema IDs with the schema names. When doing a "View By" the schema IDs are included.
Hope this helps.
Les
> Troubleshooting one of my customers application for performance, so
> since SQL logs show T<schemaId> on SQL logs, I have to query the
> arschema table all the time before opening the form in question in the
> Admin tool.. which is where I found that if the admin tool listed the
> schemaId's with their corresponding schema Id's, it would have been
> easier for me to identify the form by the ID instead of its name..
> also it would have been nice to have the View by feature modified to show a form or a list of forms by schema ID's..
>
> Personally I do not think it will be too hard to modify the Admin tool
> code to display the schemaid along with the schema name..
>
> Rgds
>
> Joe D'Souza
> Remedy Developer / Consultant,
> Shyle Networks,
> New Jersey.
>
>
>
> ----- Original Message ----
> From: Axton <[EMAIL PROTECTED]>
> To: [email protected]
> Sent: Sunday, October 22, 2006 11:53:21 AM
> Subject: Re: Enhancement: Schema ID on AR Admin tool...
>
>
> It would be nice, would also be nice to see a list of forms/fields a
> menu is attached to.
>
> Joe, what are you doing where the schemaid would be useful? In my
> direct sql workflow, I set an integer field to the schemaid and use
> that as a variable in the direct sql action. I do this because the
> schemaid can vary from server to server. I refrain from using the
> views for several reasons (the naming has changed in the past;
> permissions get dropped from views on each form change; etc.).
>
> Axton Grams
>
> On 10/22/06, Jarl Grøneng <[EMAIL PROTECTED]> wrote:
> > I dont see the problem. Active links can be a part of unlimited
> > number of
> forms.
> >
> > This is an enhancment I would like to se. I had to create a sql-stmt
> > to list which active links and filters that are not part of a guide
> >
> > --
> > Jarl
> >
> >
> > On 10/22/06, Joe D'Souza <[EMAIL PROTECTED]> wrote:
> > > That might be nice but you got to remember that an AL or a filter
> > > could
> be a
> > > part of more than one guide... and I do not think there is a limit
> > > to the number of guides you can tie a AL or Filter to...
> > >
> > > Joe
> > >
> > > -----Original Message-----
> > > From: Action Request System discussion list(ARSList)
> > > [mailto:[email protected]]On Behalf Of Jay Rohrer
> > > Sent: Saturday, October 21, 2006 8:07 PM
> > > To: [email protected]
> > > Subject: Re: Enhancement: Schema ID on AR Admin tool...
> > >
> > >
> > > I would not find that nearly as useful as having a tab on ALs and
> > > FILs
> that
> > > tell me which Guides they are a part of.
> > >
> > > Jay Rohrer
>
>
>
>
_______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
