Yep, that worked, Misi, thanks.
Also, I tried a/r system metadata: arschema/ before I tried driver.exe,
but there was no way to execute the search...no search button.
rp
On 8/10/2013 12:51 AM, Misi Mladoniczky wrote:
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 <r...@netfirst.com>
Sender: "Action Request System discussion list(ARSList)"
<arslist@ARSLIST.ORG>
Date: Fri, 9 Aug 2013 21:11:20
To: <arslist@ARSLIST.ORG>
Reply-To: arslist@ARSLIST.ORG
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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"