The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
External Integration
Posted: 10 Apr 08 12:15 PM
|
I have coded a script that inserts new accounts into SalesLogix from MAS 90. I am connecting through the SLX Data Provider. I'm inserting records into Account, Address, and AccountSummary. From an account lookup (e.g. Account QuickFind), the accounts do not show up in the lookup list. The accounts do actually exist and can be accessed in SLX via other methods, just not through the account lookups. Has anyone had this problem before? Thanks!!!
C. Burriss
HELP Solutions |
|
|
|
Re: External Integration
Posted: 10 Apr 08 2:59 PM
|
We figured this one out. Apparentely, if Account.Account_UC does not equal Ucase(Account.Account), the account will not show up in the lookup.
C. Burriss
HELP Solutions |
|
|
|
Re: External Integration
Posted: 11 Apr 08 5:18 AM
|
Yeap, you have to populate the ACCOUNT_UC field,
and if you insert accounts, make sure you populate the LASTNAME_UC field.
Had you ran an Integrity checker, the Mirror tests would've fix this issue.
|
|
|
|
Re: External Integration
Posted: 11 Apr 08 8:09 AM
|
That's good to know. Thank you very much.
Does anyone know why the _UC fields are of such importance? |
|
|
|
Re: External Integration
Posted: 11 Apr 08 8:41 AM
|
The ability of doing Case Insensitve querys from the Account and Contact Lookup on any platform.
So, even if you are running Oracle (or MS setup as Case Sensitive), if you do a quick search for "abc" it will include in the results "ABC", "abc", "AbC", "abC", etc...
|
|
|
| |
|