Field Length

The following program will give you all the defined formats in the
database.

for each _file:
display _file._file-name with frame one.
for each _field of _file:
display _field._field-name _field._format with frame one.
down with frame one.
end.
down 1 with frame one.
end.

Remember also that the defined format is a display mask. All fields may
be "over stuffed" with values that will not display using the mask. For
example, if a character field is defined as "x(30)" you can
programmatically assign any string up the max (about 32000 characters)
to the variable. How ever, if you display the field, you will only see
the first 30 characters.

HTH
judyh001 wrote:
>
> Somewhere, a long time ago, I saw a list of the field lengths Vantage
> allows...I can't find it anymore.
>
> This leads me to two questions...does anyone have the field length
> formats for Vantage 4.0 and can anyone tell me if they have increased
> the lengths in 5.1?
>
> Thanks in advance..
>
> Sincerely,
> Judy Havlik
> judy.havlik@...
> Phone: 847-827-6680
> Fax: 847-827-6733
>
>
> 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
Somewhere, a long time ago, I saw a list of the field lengths Vantage
allows...I can't find it anymore.

This leads me to two questions...does anyone have the field length
formats for Vantage 4.0 and can anyone tell me if they have increased
the lengths in 5.1?

Thanks in advance..

Sincerely,
Judy Havlik
judy.havlik@...
Phone: 847-827-6680
Fax: 847-827-6733
Hi Judy,

I've briefly looked into the Vantage 5.1 tables to but I couldn't find a defining table. However, I did find a "workaround" solution to determine string-lengths. To my knowledge this wil only probably only work with strings:

In crystal report, add the tables that contain fields you want to know the maximum length of.
Then in the visual linking expert you can right-click on the entries and Browse the Field. Strings will have a # of characters defined.

Maybe this'll help you a bit.
Regards,

Len Holtkamp
Project Manager
--------------------------------------------
Bumet BV
Buijsen Metaalindustrie, Heeze
www.Bumet.nl
Len.Holtkamp@...

> -----Oorspronkelijk bericht-----
> Van: judyh001 [SMTP:judy.havlik@...]
> Verzonden: donderdag 27 juni 2002 16:13
> Aan: vantage@yahoogroups.com
> Onderwerp: [Vantage] Field Length
>
> Somewhere, a long time ago, I saw a list of the field lengths Vantage
> allows...I can't find it anymore.
>
> This leads me to two questions...does anyone have the field length
> formats for Vantage 4.0 and can anyone tell me if they have increased
> the lengths in 5.1?
>
> Thanks in advance..
>
> Sincerely,
> Judy Havlik
> judy.havlik@...
> Phone: 847-827-6680
> Fax: 847-827-6733
>
>
> 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 <http://docs.yahoo.com/info/terms/>.
The Data Dictionary in Vantage will give you field lengths as well.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Len Holtkamp
To: vantage@yahoogroups.com
Sent: Thursday, June 27, 2002 12:09 PM
Subject: RE: [Vantage] Field Length


Hi Judy,

I've briefly looked into the Vantage 5.1 tables to but I couldn't find a defining table. However, I did find a "workaround" solution to determine string-lengths. To my knowledge this wil only probably only work with strings:

In crystal report, add the tables that contain fields you want to know the maximum length of.
Then in the visual linking expert you can right-click on the entries and Browse the Field. Strings will have a # of characters defined.

Maybe this'll help you a bit.
Regards,

Len Holtkamp
Project Manager
--------------------------------------------
Bumet BV
Buijsen Metaalindustrie, Heeze
www.Bumet.nl
Len.Holtkamp@...

> -----Oorspronkelijk bericht-----
> Van: judyh001 [SMTP:judy.havlik@...]
> Verzonden: donderdag 27 juni 2002 16:13
> Aan: vantage@yahoogroups.com
> Onderwerp: [Vantage] Field Length
>
> Somewhere, a long time ago, I saw a list of the field lengths Vantage
> allows...I can't find it anymore.
>
> This leads me to two questions...does anyone have the field length
> formats for Vantage 4.0 and can anyone tell me if they have increased
> the lengths in 5.1?
>
> Thanks in advance..
>
> Sincerely,
> Judy Havlik
> judy.havlik@...
> Phone: 847-827-6680
> Fax: 847-827-6733
>
>
> 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 <http://docs.yahoo.com/info/terms/>.

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]