Assemblies

[SBTBILL]

Would like some imput on this.

Created an assembly viewer, that shows assemblies, their cost, components, etc.

Now that I have this done, I'm thinking it should be marketable. However, have found that the biggest problem is that Peachtree doesn't like double quotes. I have a way to get around that but that causes a problem with commas. Just wondering how many people use double quotes for inches and the like?

Bill Couture

[Dive-rsq]

Our company uses double quotes in the short and long discriptions fields. We manufacture tubing and almost all of our discriptions have them.

[SBTBILL]

Suspect a lot of places use them. They probably only become an issue when data is exported.

There is a warning about this on page 525 of the version 9 manuel but you'd probably have to be experienced with comma delimited files to understand it.

"Peachtree is exported in a comma-delimited format (...). In other words, the fields for each record are written in one line, with commas between them. If commas exist within the field, then the entire field is enclosed in quotation marks; commas within quotation marks don't count as field separators."

When a double quote gets used it confuses the import routine in VFP. Not sure if it also does it in VB/ACCESS. Maybe Bob will look in and tell us.

Bill Couture

[Barry Szakolcza]

We are a balloon decor company and use double quotes for many of our jobs.

[dringstrom]

Originally posted by SBTBILL
When a double quote gets used it confuses the import routine in VFP. Not sure if it also does it in VB/ACCESS.

Double quotes wreak havoc in Excel and Access. The only good way around it that I've seen is to use DDE to extract the data one field at a time, which gives you more control.