Field Names

Yahoo Archive
1
Right mouse lick on a gray (inactive) area of the form...


-----Original Message-----
From: Reilly, Rhonda [mailto:rreilly@...]
Sent: Thursday, April 15, 2004 5:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Field Names

Isn't there a way to get a list of all the table.field names on a form.
I may be dreaming but I thought I remember something like hitting F12 or
something...although hitting F12 gives me the program call and that is
not what I am looking for.

Rhonda Reilly
Information Resource Manager
American Aero / Titan
985.893.1818
985.893.1879 fax





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
Hello all,

I'd like to know how I could build a list of all the fields in a
given table.

For instance, I want to export the Part table, and I'd like to issue
an export statement at the begining of the output file in order to
get the field names into the .cvs file.

How would you people go about doing this ?

Thank you very much.


Luc Morin
Electrical Designer
Wulftec International
lucm@...
3
Which Version of Vantage?

Troy Funte
Liberty Electronics

----- Original Message -----
From: morin_luc
To: vantage@yahoogroups.com
Sent: Friday, March 08, 2002 4:21 PM
Subject: [Vantage] Field Names


Hello all,

I'd like to know how I could build a list of all the fields in a
given table.

For instance, I want to export the Part table, and I'd like to issue
an export statement at the begining of the output file in order to
get the field names into the .cvs file.

How would you people go about doing this ?

Thank you very much.


Luc Morin
Electrical Designer
Wulftec International
lucm@...



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
4
If you are using the "Export Utility" there is a Check Box on the first
window for exporting labels. The "Export Master File" custom program doesn't
have that feature.

Mike Tonoyan / All American Products Co.


----- Original Message -----
From: "morin_luc" <luc_mo@...>
To: <vantage@yahoogroups.com>
Sent: Friday, March 08, 2002 1:21 PM
Subject: [Vantage] Field Names


> Hello all,
>
> I'd like to know how I could build a list of all the fields in a
> given table.
>
> For instance, I want to export the Part table, and I'd like to issue
> an export statement at the begining of the output file in order to
> get the field names into the .cvs file.
>
> How would you people go about doing this ?
>
> Thank you very much.
>
>
> Luc Morin
> Electrical Designer
> Wulftec International
> lucm@...
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
5
Progress is written in Progress, so the following 4gl fragment would
produce a comma separated list of field names for a given table. It
assumes that an output destination has already been established.

find _file where _file._file-name EQ "part".
find first _field of _file no-lock.
put unformatted _field._field-name.
repeat:
find next _field of _file no-lock no-error.
if not available _field
then leave.
else put unformatted "," _field._field-name.
end.
put skip. /* to put an End-Of-Line sequence into the file. */


morin_luc wrote:
>
> Hello all,
>
> I'd like to know how I could build a list of all the fields in a
> given table.
>
> For instance, I want to export the Part table, and I'd like to issue
> an export statement at the begining of the output file in order to
> get the field names into the .cvs file.
>
> How would you people go about doing this ?
>
> Thank you very much.
>
> Luc Morin
> Electrical Designer
> Wulftec International
> lucm@...
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1
6
Isn't there a way to get a list of all the table.field names on a form.
I may be dreaming but I thought I remember something like hitting F12 or
something...although hitting F12 gives me the program call and that is
not what I am looking for.

Rhonda Reilly
Information Resource Manager
American Aero / Titan
985.893.1818
985.893.1879 fax