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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Need Help Converting SQL Update Statement To Work in SLX 7.5

Bailey1
Posts: 57

Need Help Converting SQL Update Statement To Work in SLX 7.5 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jan 09 1:30 PM

I have the following SQL Update statement that works in SLX 6.1 but not in 7.5. I know it needs to be rewritten to conform to SQL 92 standards but I still can't get it to work. Any help would be appreciated!

UPDATE ADDRESS
SET UF_ACCOUNTMANAGERID = PC.ACCOUNTMANAGERID, UF_SECCODEID = PC.OWNERID
FROM UF_POSTALCODE PC, ADDRESS A, ACCOUNT AC, USERINFO UI
WHERE A.POSTALCODE = PC.POSTALCODE
AND AC.ACCOUNTID = A.ENTITYID
AND AC.ACCOUNTMANAGERID = UI.USERID
AND LEFT(A.ENTITYID,1) = 'A'
AND (A.ISPRIMARY = 'T' OR A.ISPRIMARY IS NULL)
AND PC.POSTALCODE IS NOT NULL
AND (PC.ROUTING IS NULL OR PC.ROUTING = '')
AND UI.DEPARTMENT = 'SALES'
AND (UF_ACCOUNTMANAGERID<>PC.ACCOUNTMANAGERID OR UF_ACCOUNTMANAGERID IS NULL OR UF_SECCODEID <> PC.OWNERID OR UF_SECCODEID IS NULL)

Thanks,
Barb

[Reply][Quote]

Chris Grant
Posts: 10

Re: Need Help Converting SQL Update Statement To Work in SLX 7.5 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Feb 09 4:42 AM

Not tested by try something like this

UPDATE ADDRESS
SET
UF_ACCOUNTMANAGERID = (Select ACCOUNTMANAGERID From UF_POSTALCODE PC Where PC.PostalCode = Address.PostalCode)
UF_SECCODEID = (Select OWNERID From UF_POSTALCODE PC Where PC.PostalCode = Address.PostalCode)
Where
Exists (Select
1
FROM
Address AD
Inner Join UF_POSTALCODE PC On PC.PostalCode = A.PostalCode
Inner Join ACCOUNT AC On AC.AccountID = A.EntityID
Inner Join USERINFO UI On UI.UserID = AC.AccountManagerID
WHERE
AD.AddressID = Address.AddressID
AND LEFT(A.ENTITYID,1) = 'A'
AND (A.ISPRIMARY = 'T' OR A.ISPRIMARY IS NULL)
AND PC.POSTALCODE IS NOT NULL
AND (PC.ROUTING IS NULL OR PC.ROUTING = '')
AND UI.DEPARTMENT = 'SALES'
AND (UF_ACCOUNTMANAGERID<>PC.ACCOUNTMANAGERID OR UF_ACCOUNTMANAGERID IS NULL OR UF_SECCODEID <> PC.OWNERID OR UF_SECCODEID IS NULL)
)

Hope it Helps
Chris

[Reply][Quote]

Bailey1
Posts: 57

Re: Need Help Converting SQL Update Statement To Work in SLX 7.5 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Feb 09 9:12 AM

Thanks for your help - I got it to work!

[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/27/2025 10:22:56 PM