Productive Computing, Inc. Support Forum

Plug-ins => FM Books Connector => Topic started by: hudi on January 25, 2015, 01:07:58 AM

Title: Pushing Address Chunk
Post by: hudi on January 25, 2015, 01:07:58 AM
Hi,

I'm trying to push the address which I have in FM as one text field as follows:

PCQB_RqAddFieldWithValue( "BillAddress::Addr1" ; PERSON::address_full )

Where the field address_full could look like
1234 Broadway
Suite 1203
New York, NY 10024

I did some testing and noticed that it only errors when I have a suite or apartment number inserted. If I just have the street address with nothing in between the street and city it works fine. I find that odd because I'm able to then type a suite number into QB after it's pushed.

Thanks!
Title: Re: Pushing Address Chunk
Post by: Geoffrey Gerhard on January 25, 2015, 10:25:06 AM
The error is likely the result of a character count in excess of 41.

You might have better luck passing each line independently. You might try...

PCQB_RqAddFieldWithValue( "BillAddress::Addr1" ; GetValue ( PERSON::address_full ; 1 ) ) &
PCQB_RqAddFieldWithValue( "BillAddress::Addr2" ; GetValue ( PERSON::address_full ; 2 ) ) &
etc.

...and see if that solves the problem. Note that if it's not included in address_full, the CustomerName will not be part of the BillAddress in QB.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852