Author Topic: Pushing Address Chunk  (Read 868 times)


  • Member
  • *
  • Posts: 8
Pushing Address Chunk
« on: January 25, 2015, 01:07:58 AM »

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.


Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
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 ) ) &

...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.


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