 | GoldBox Import -> Expecting Character Error |  |
 Posted: Tue Feb 01, 2011 12:25 pm |
Points: 0  |
|
| davidshq |
| GoldMine Journeyman |
|
 |
| Joined: 15 Jun 2010 |
| Posts: 38 |
|
|
|
|
|
|
 |
|
I have a DBF file that has info. I need to update on my GM database. I've created an IMPORT/UPDATE job to do this - but when I run it it is returning an error saying it is expecting a character but received something else. I think the problematic filter expression might be:
IIF(Tx->Disp="Do Not Call".OR.Tx->Disp="Fax/Modem".OR.Tx->DISP="Wrong Number".OR.Tx->DISP="Automated Refusal", GXI->Phone1="", IIF(Empty(Tx->Phone_numb), GXI->Phone1, Tx->Phone_numb))
Which when I click "Result" returns a boolean (true/false) rather than what I'd expect - e.g. passing back an empty value for GXI->Phone1 or returning the value of Tx->Phone_number if it isn't empty. Any ideas why it is returning boolean values?
Dave. |
|
|
|
|
| | |
| Posted: Tue Feb 01, 2011 1:32 pm |
Points: 0 |
|
| davidshq |
| GoldMine Journeyman |
|
|
| Joined: 15 Jun 2010 |
| Posts: 38 |
|
|
|
|
|
|
|
|
| Okay, the issue was in statements like GXI->Phone1="", it should just be "", it is already putting it into GXI->Phone1. |
|
|
|
|
ContactReview Forum Index » GoldBox
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin
|
