RE: [sqr-users] Record field names

[Bob Stone <bstone@fastenal.com>]

I'm not sure what it is across different databases, but in oracle there's a
table called USER_TAB_COLUMNS that holds table_name and column_name -

begin-select 
column_name

  let $output = $output || $tab || &column_name
from USER_TAB_COLUMNS
where table_name = 'TABLE_XYZ'
end-select

That's how you'd do that in SQR.



-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of Anu
Bagde
Sent: Thursday, June 23, 2005 2:21 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Record field names



Hello Group,


I am looking for an utility, which will read the record name and list the 
record field names as output fiel in some way (space, comma or tab 
delimited). Is their some utility available that will do this?

Thanks for any answers you have for this.

Regards,
Anu

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users