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: Updating tables using joins in Sales Logix OLEBD provider

Sushma
Posts: 1

Updating tables using joins in Sales Logix OLEBD provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Jan 08 1:53 AM

I have a problem where in SalesLogix OLEDB provider does not support few update queries which involve joins.
For eg:

update a
set a.col = 'value'
from table1 a
join table2 b
on a.id = b.id

Is there any other work around for making this SLX OLEDB compatible.

One more problem that am facing is we are using Scribe for importing data from legacy system into SLX. we are not able to run scripts with multiple update statements in the pre excute and post excute scripts.

Your help is well Appreciated.

[Reply][Quote]

Matt Dockins
Posts: 159

Re: Updating tables using joins in Sales Logix OLEBD provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Jan 08 1:02 PM

update a
set a.col = 'value'
from table1 a
join table2 b
on a.id = b.id

==

update a set a.col = (select b.col from b where b.id = a.id)

As far as the scribe question goes, I don't understand the question. What type of update statements, examples?

[Reply][Quote]

Stephen Redmond
Posts: 190

Re: Updating tables using joins in Sales Logix OLEBD provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Feb 08 2:09 AM

By default, Scribe does not support multiple-row update on and Update step. There is a checkbox in the last tab of the step configuration to allow this - but be careful! Are you absolutely sure that you want multiple row update?

[Reply][Quote]

Craig
Posts: 13

Re: Updating tables using joins in Sales Logix OLEBD provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Feb 08 7:09 AM

Concerning the update, I don't think the OLEDB provider supports table aliases.

Craig

[Reply][Quote]

Stephen Redmond
Posts: 190

Re: Updating tables using joins in Sales Logix OLEBD provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Feb 08 6:30 PM

Quote:

Originally posted by Craig

Concerning the update, I don't think the OLEDB provider supports table aliases.

The OLE DB provider absolutely supports table aliases - they are used in every single SLX Group (e.g. SELECT A1.CONTACTID, A1.LASTNAME FROM CONTACT A1)

It just doesn't support the construct above - the workaround using a sub-query is good though.

Stephen

[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/18/2025 5:12:33 PM