slxdeveloper.com Community Forums

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!

Administration Forums - Mobile/PDA/Handhelds
Forum to discuss use of SalesLogix with mobile devices including SalesLogix mobile and other mobile solutions. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Mobile/PDA/Handhelds | New Thread

View: Search:

Author

Thread: Column Name Listed More Than Once on Insert

Martin Rudnick
Posts: 52

Column Name Listed More Than Once on Insert Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Apr 09 5:04 PM

I am receiving a synchronization error after adding a contact in SalesLogix Mobile. When the new contact is added to SLX Mobile and a synchronization to the SalesLogix database is run, an error pops in the sync logs stating that the
Column name 'ISPRIMARY' appears more than once in the result column list.
The contact is not added to the SLX database.

Looking at the insert SQL statement, the ISPRIMARY has the T/F value as calculated from the Client2ServerMap/SyncFunctions but the statement also contains isprimary as null which I assume is from the basecontact java class. Any help in determining why the field is being added to the sql insert statement twice? Thanks

Martin

[Reply][Quote]

Martin Rudnick
Posts: 52

Re: Column Name Listed More Than Once on Insert Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Apr 09 1:58 PM

Issue caused after adding the IsPrimary field to the mobile contact table from the SLX database. The syncfunctions contains script to handle the value if a new contact is added. By adding the field to the table, the Insert statement sent out to the SLX server contains the field as well as the value created in the syncfunction.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 10:38:33 AM