FW: DBF Memo Fields

system · September 26, 2001, 11:45am

Troy,

It is editable 4gl code. I've posted a Recieved Items Not Yet Invoiced
report that uses a DBF export in the files section.

I do compile it to .r code sometimes before sticking it on the meny because
it will run slighly faster.

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, September 26, 2001 10:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FW: DBF Memo Fields

Thad,
When you run that 4GL export code, are you running a .w program? Is it
compiled or can you see the code and edit it?

Troy

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Wednesday, September 26, 2001 11:28 AM
Subject: RE: [Vantage] FW: DBF Memo Fields

Troy,

Thanks for Prayin!! Peter Van Dam, one of the gurus on the Progress
E-Mail
group, and the only one who has posted 4GL dbf export code for free on the
web, is helping me through this one. He wrote all the dbf export code
that
I've been using.

And, yes standing at a mere 6'1", this one's definitely over my head.

God Bless,

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 25, 2001 9:17 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FW: DBF Memo Fields

I'll have to stick to praying for you on this one. You in WAY over my
head
- hopefully you're taller than 6' 4''.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 7:30 PM
Subject: RE: [Vantage] FW: DBF Memo Fields

Basically, I'm creating a custom Work Order report that
uses a dbf to export fields into three seperate dbf files.

The first dbf contains a various user fields from the jobhead and
OrderHead
tables, which are linked through the JobProd table. Also included is
the
customer name for the sales order. This dbf contains one record, and is
derived from the a user prompted job number.

The second dbf contains all the job operations where jobnum = [the job
number in the first dbf ]and assemblyseq = 0.

The third dbf contains the Sales order line part number for each
OrderDtl
where ordernum = [the order number in the second dbf on for the ,
quantity,
and the jobhead.CommentText for the first JobHead that is linked to that
sales order line.

The second and third dbfs are viewed as subreports within a report
containing the first dbf.

Everything works fine until I export a jobhead.CommentText field into
the
3rd dbf that contains multiple lines, because the dbf file format
doesn't
support fields with carriage returns.

When Vantage exports the job comments field, it does so via the
JobHead.fpt
memo field.

When you export the JobHead.CommentText using the export utility, it
truncates the field at the end of the first line.

We need multi-line jobhead.CommentText fields on this report, and the
only
solution I know of is to create a memo field containing the commenttext
field using 4GL, or export that commenttext field via some sort of
delimited
file so I can stick the CommentText field in a dbt file that is linked
to
the third dbf file.

What I'm asking is if anyone has any source code in 4GL that would
assist
me
in this endeavor, or if there is another approach that I could use
WITHOUT
USING ODBC.

IF that makes any sense THEN
please respond with any suggestions you may have
ELSE
please pray for me
END IF.

Thanks in advance!!

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 25, 2001 6:00 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FW: DBF Memo Fields

What exactly do you need to end up with, Thad (what tables/fields)?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 6:30 PM
Subject: [Vantage] FW: DBF Memo Fields

Vantage 3 / 8.3a Procedure editor (no PROVISION), query only licence,
NT
Server, 98/NT/2k clients

1) Does anyone have 4GL code to export memo fields to a dBase memo
file
(dbt)?

I am trying to export records in the database for use in Crystal
Reports.
Because of security and reliability issues, management has forbidden
ODBC.

I have tried without success to export a multi-line comments field to
a
dbf
file, format "x(255)"

Alternative to this is to export the fields a delimited file, and
convert
the resulting file to DBF/DBT format.

2) Does anyone have Visual Basic code for that?

3)Is the TAB character allowed in a progress database field? If so,
what
would be a better delimiter to use in an application such as this?

Thanks in advance,

Thaddeus Jacobs

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]

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/

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]

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/

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]

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/

system · September 25, 2001, 6:36pm

Vantage 3 / 8.3a Procedure editor (no PROVISION), query only licence, NT
Server, 98/NT/2k clients

1) Does anyone have 4GL code to export memo fields to a dBase memo file
(dbt)?

I am trying to export records in the database for use in Crystal Reports.
Because of security and reliability issues, management has forbidden ODBC.

I have tried without success to export a multi-line comments field to a dbf
file, format "x(255)"

Alternative to this is to export the fields a delimited file, and convert
the resulting file to DBF/DBT format.

2) Does anyone have Visual Basic code for that?

3)Is the TAB character allowed in a progress database field? If so, what
would be a better delimiter to use in an application such as this?

Thanks in advance,

Thaddeus Jacobs

system · September 25, 2001, 6:57pm

What exactly do you need to end up with, Thad (what tables/fields)?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 6:30 PM
Subject: [Vantage] FW: DBF Memo Fields

Vantage 3 / 8.3a Procedure editor (no PROVISION), query only licence, NT
Server, 98/NT/2k clients

1) Does anyone have 4GL code to export memo fields to a dBase memo file
(dbt)?

I am trying to export records in the database for use in Crystal Reports.
Because of security and reliability issues, management has forbidden ODBC.

I have tried without success to export a multi-line comments field to a dbf
file, format "x(255)"

Alternative to this is to export the fields a delimited file, and convert
the resulting file to DBF/DBT format.

2) Does anyone have Visual Basic code for that?

3)Is the TAB character allowed in a progress database field? If so, what
would be a better delimiter to use in an application such as this?

Thanks in advance,

Thaddeus Jacobs

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]

system · September 25, 2001, 7:29pm

Basically, I'm creating a custom Work Order report that
uses a dbf to export fields into three seperate dbf files.

The first dbf contains a various user fields from the jobhead and OrderHead
tables, which are linked through the JobProd table. Also included is the
customer name for the sales order. This dbf contains one record, and is
derived from the a user prompted job number.

The second dbf contains all the job operations where jobnum = [the job
number in the first dbf ]and assemblyseq = 0.

The third dbf contains the Sales order line part number for each OrderDtl
where ordernum = [the order number in the second dbf on for the , quantity,
and the jobhead.CommentText for the first JobHead that is linked to that
sales order line.

The second and third dbfs are viewed as subreports within a report
containing the first dbf.

Everything works fine until I export a jobhead.CommentText field into the
3rd dbf that contains multiple lines, because the dbf file format doesn't
support fields with carriage returns.

When Vantage exports the job comments field, it does so via the JobHead.fpt
memo field.

When you export the JobHead.CommentText using the export utility, it
truncates the field at the end of the first line.

We need multi-line jobhead.CommentText fields on this report, and the only
solution I know of is to create a memo field containing the commenttext
field using 4GL, or export that commenttext field via some sort of delimited
file so I can stick the CommentText field in a dbt file that is linked to
the third dbf file.

What I'm asking is if anyone has any source code in 4GL that would assist me
in this endeavor, or if there is another approach that I could use WITHOUT
USING ODBC.

IF that makes any sense THEN
please respond with any suggestions you may have
ELSE
please pray for me
END IF.

Thanks in advance!!

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 25, 2001 6:00 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FW: DBF Memo Fields

What exactly do you need to end up with, Thad (what tables/fields)?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 6:30 PM
Subject: [Vantage] FW: DBF Memo Fields

Vantage 3 / 8.3a Procedure editor (no PROVISION), query only licence, NT
Server, 98/NT/2k clients

1) Does anyone have 4GL code to export memo fields to a dBase memo file
(dbt)?

I am trying to export records in the database for use in Crystal Reports.
Because of security and reliability issues, management has forbidden ODBC.

I have tried without success to export a multi-line comments field to a
dbf
file, format "x(255)"

Alternative to this is to export the fields a delimited file, and convert
the resulting file to DBF/DBT format.

2) Does anyone have Visual Basic code for that?

3)Is the TAB character allowed in a progress database field? If so, what
would be a better delimiter to use in an application such as this?

Thanks in advance,

Thaddeus Jacobs

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]

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/

system · September 25, 2001, 10:17pm

I'll have to stick to praying for you on this one. You in WAY over my head - hopefully you're taller than 6' 4''.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 7:30 PM
Subject: RE: [Vantage] FW: DBF Memo Fields

Basically, I'm creating a custom Work Order report that
uses a dbf to export fields into three seperate dbf files.

The first dbf contains a various user fields from the jobhead and OrderHead
tables, which are linked through the JobProd table. Also included is the
customer name for the sales order. This dbf contains one record, and is
derived from the a user prompted job number.

The second dbf contains all the job operations where jobnum = [the job
number in the first dbf ]and assemblyseq = 0.

The third dbf contains the Sales order line part number for each OrderDtl
where ordernum = [the order number in the second dbf on for the , quantity,
and the jobhead.CommentText for the first JobHead that is linked to that
sales order line.

The second and third dbfs are viewed as subreports within a report
containing the first dbf.

Everything works fine until I export a jobhead.CommentText field into the
3rd dbf that contains multiple lines, because the dbf file format doesn't
support fields with carriage returns.

When Vantage exports the job comments field, it does so via the JobHead.fpt
memo field.

When you export the JobHead.CommentText using the export utility, it
truncates the field at the end of the first line.

We need multi-line jobhead.CommentText fields on this report, and the only
solution I know of is to create a memo field containing the commenttext
field using 4GL, or export that commenttext field via some sort of delimited
file so I can stick the CommentText field in a dbt file that is linked to
the third dbf file.

What I'm asking is if anyone has any source code in 4GL that would assist me
in this endeavor, or if there is another approach that I could use WITHOUT
USING ODBC.

IF that makes any sense THEN
please respond with any suggestions you may have
ELSE
please pray for me
END IF.

Thanks in advance!!

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 25, 2001 6:00 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FW: DBF Memo Fields

What exactly do you need to end up with, Thad (what tables/fields)?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 6:30 PM
Subject: [Vantage] FW: DBF Memo Fields

Vantage 3 / 8.3a Procedure editor (no PROVISION), query only licence, NT
Server, 98/NT/2k clients

1) Does anyone have 4GL code to export memo fields to a dBase memo file
(dbt)?

I am trying to export records in the database for use in Crystal Reports.
Because of security and reliability issues, management has forbidden ODBC.

I have tried without success to export a multi-line comments field to a
dbf
file, format "x(255)"

Alternative to this is to export the fields a delimited file, and convert
the resulting file to DBF/DBT format.

2) Does anyone have Visual Basic code for that?

3)Is the TAB character allowed in a progress database field? If so, what
would be a better delimiter to use in an application such as this?

Thanks in advance,

Thaddeus Jacobs

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]

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/

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]

system · September 26, 2001, 11:27am

Troy,

Thanks for Prayin!! Peter Van Dam, one of the gurus on the Progress E-Mail
group, and the only one who has posted 4GL dbf export code for free on the
web, is helping me through this one. He wrote all the dbf export code that
I've been using.

And, yes standing at a mere 6'1", this one's definitely over my head.

God Bless,

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 25, 2001 9:17 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FW: DBF Memo Fields

I'll have to stick to praying for you on this one. You in WAY over my head
- hopefully you're taller than 6' 4''.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 7:30 PM
Subject: RE: [Vantage] FW: DBF Memo Fields

Basically, I'm creating a custom Work Order report that
uses a dbf to export fields into three seperate dbf files.

The first dbf contains a various user fields from the jobhead and
OrderHead
tables, which are linked through the JobProd table. Also included is the
customer name for the sales order. This dbf contains one record, and is
derived from the a user prompted job number.

The second dbf contains all the job operations where jobnum = [the job
number in the first dbf ]and assemblyseq = 0.

The third dbf contains the Sales order line part number for each OrderDtl
where ordernum = [the order number in the second dbf on for the ,
quantity,
and the jobhead.CommentText for the first JobHead that is linked to that
sales order line.

The second and third dbfs are viewed as subreports within a report
containing the first dbf.

Everything works fine until I export a jobhead.CommentText field into the
3rd dbf that contains multiple lines, because the dbf file format doesn't
support fields with carriage returns.

When Vantage exports the job comments field, it does so via the
JobHead.fpt
memo field.

When you export the JobHead.CommentText using the export utility, it
truncates the field at the end of the first line.

We need multi-line jobhead.CommentText fields on this report, and the only
solution I know of is to create a memo field containing the commenttext
field using 4GL, or export that commenttext field via some sort of
delimited
file so I can stick the CommentText field in a dbt file that is linked to
the third dbf file.

What I'm asking is if anyone has any source code in 4GL that would assist
me
in this endeavor, or if there is another approach that I could use WITHOUT
USING ODBC.

IF that makes any sense THEN
please respond with any suggestions you may have
ELSE
please pray for me
END IF.

Thanks in advance!!

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 25, 2001 6:00 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FW: DBF Memo Fields

What exactly do you need to end up with, Thad (what tables/fields)?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 6:30 PM
Subject: [Vantage] FW: DBF Memo Fields

Vantage 3 / 8.3a Procedure editor (no PROVISION), query only licence, NT
Server, 98/NT/2k clients

1) Does anyone have 4GL code to export memo fields to a dBase memo file
(dbt)?

I am trying to export records in the database for use in Crystal
Reports.
Because of security and reliability issues, management has forbidden
ODBC.

I have tried without success to export a multi-line comments field to a
dbf
file, format "x(255)"

Alternative to this is to export the fields a delimited file, and
convert
the resulting file to DBF/DBT format.

2) Does anyone have Visual Basic code for that?

3)Is the TAB character allowed in a progress database field? If so,
what
would be a better delimiter to use in an application such as this?

Thanks in advance,

Thaddeus Jacobs

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]

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/

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]

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/

system · September 26, 2001, 11:32am

Thad,
When you run that 4GL export code, are you running a .w program? Is it compiled or can you see the code and edit it?

Troy

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Wednesday, September 26, 2001 11:28 AM
Subject: RE: [Vantage] FW: DBF Memo Fields

Troy,

Thanks for Prayin!! Peter Van Dam, one of the gurus on the Progress E-Mail
group, and the only one who has posted 4GL dbf export code for free on the
web, is helping me through this one. He wrote all the dbf export code that
I've been using.

And, yes standing at a mere 6'1", this one's definitely over my head.

God Bless,

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 25, 2001 9:17 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FW: DBF Memo Fields

I'll have to stick to praying for you on this one. You in WAY over my head
- hopefully you're taller than 6' 4''.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 7:30 PM
Subject: RE: [Vantage] FW: DBF Memo Fields

Basically, I'm creating a custom Work Order report that
uses a dbf to export fields into three seperate dbf files.

The first dbf contains a various user fields from the jobhead and
OrderHead
tables, which are linked through the JobProd table. Also included is the
customer name for the sales order. This dbf contains one record, and is
derived from the a user prompted job number.

The second dbf contains all the job operations where jobnum = [the job
number in the first dbf ]and assemblyseq = 0.

The third dbf contains the Sales order line part number for each OrderDtl
where ordernum = [the order number in the second dbf on for the ,
quantity,
and the jobhead.CommentText for the first JobHead that is linked to that
sales order line.

The second and third dbfs are viewed as subreports within a report
containing the first dbf.

Everything works fine until I export a jobhead.CommentText field into the
3rd dbf that contains multiple lines, because the dbf file format doesn't
support fields with carriage returns.

When Vantage exports the job comments field, it does so via the
JobHead.fpt
memo field.

When you export the JobHead.CommentText using the export utility, it
truncates the field at the end of the first line.

We need multi-line jobhead.CommentText fields on this report, and the only
solution I know of is to create a memo field containing the commenttext
field using 4GL, or export that commenttext field via some sort of
delimited
file so I can stick the CommentText field in a dbt file that is linked to
the third dbf file.

What I'm asking is if anyone has any source code in 4GL that would assist
me
in this endeavor, or if there is another approach that I could use WITHOUT
USING ODBC.

IF that makes any sense THEN
please respond with any suggestions you may have
ELSE
please pray for me
END IF.

Thanks in advance!!

Thaddeus

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 25, 2001 6:00 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FW: DBF Memo Fields

What exactly do you need to end up with, Thad (what tables/fields)?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 25, 2001 6:30 PM
Subject: [Vantage] FW: DBF Memo Fields

Vantage 3 / 8.3a Procedure editor (no PROVISION), query only licence, NT
Server, 98/NT/2k clients

1) Does anyone have 4GL code to export memo fields to a dBase memo file
(dbt)?

I am trying to export records in the database for use in Crystal
Reports.
Because of security and reliability issues, management has forbidden
ODBC.

I have tried without success to export a multi-line comments field to a
dbf
file, format "x(255)"

Alternative to this is to export the fields a delimited file, and
convert
the resulting file to DBF/DBT format.

2) Does anyone have Visual Basic code for that?

3)Is the TAB character allowed in a progress database field? If so,
what
would be a better delimiter to use in an application such as this?

Thanks in advance,

Thaddeus Jacobs

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]

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/

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]

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/

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]

Topic		Replies	Views
Certs (was: Progress/dbf) Yahoo Archive	22	716	January 17, 2002
Progress Exports (was Sales and Commission Splitting) Yahoo Archive	4	438	November 26, 2001
4gl Yahoo Archive	24	1226	December 9, 2002
4gl :-p Yahoo Archive	2	415	July 13, 2001
DBF Code Posted Yahoo Archive	0	293	September 27, 2001

FW: DBF Memo Fields

Related Topics