Hi,
select Name from arschema where SchemaId = 382
Note that in overlaid forms, you have two records with different id for each
table. You might want to look at resolvedSchemaId and resolvedName instead.
There is also a form called "AR System Metadata: arschema" that you can use
with any client instead of direct SQL. It is just a view form based upon the
arschema table.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Have you tried T382 instead of 382?
>
>
> Sent from my BlackBerry® smartphone from !DEA
>
> -----Original Message-----
> From: Rick Phillips <[email protected]>
> Sender: "Action Request System discussion list(ARSList)"
> <[email protected]>
> Date: Fri, 9 Aug 2013 21:11:20
> To: <[email protected]>
> Reply-To: [email protected]
> Subject: determining schema name using driver.exe...
>
> Hi, everyone,
>
> I'm using the 8.1 driver.exe, and wondering if it's possible to
> determine a schemaname from a given schemaid.
>
> I've tried /select * from arschema where schemaid=382 /(and variations
> of the same), but no success. What does this statement look like in glsql?
>
> Thanks,
>
> Rick
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
