Author Topic: Pushing Address Chunk  (Read 872 times)

hudi

  • Member
  • *
  • Posts: 8
Pushing Address Chunk
« 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!

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Pushing Address Chunk
« Reply #1 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