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 - ADO General
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to ADO General | New Thread

View: Search:

Author

Thread: Update a table from another table

Francois
Posts: 3

Update a table from another table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Jul 09 3:32 AM

Hello!

I try to update a SLX table from another table (in the same database) using SLX OLE DB provider and a activex script.

One result: 'Failed to parse SQL' but my update query is correct and tested....

What's wrong? Thanks for your help.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Update a table from another table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Jul 09 11:59 AM

Please post your query.

Chances are that you are using constructs which are not implemented by the SLX OLEDB provider - eg UPDATE ... FROM.

[Reply][Quote]

Francois
Posts: 3

Re: Update a table from another table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Jul 09 1:48 AM

Quote:

Originally posted by Phil Parkin

Please post your query.

Chances are that you are using constructs which are not implemented by the SLX OLEDB provider - eg UPDATE ... FROM.

My query:

Update sysdba.T_PRODUCTPROGRAMENTETE
Set program = (Select programT From sysdba.T_PRODUCTPROGRAMENTETE_TEMP where T_PRODUCTPROGRAMENTETEID = T_PRODUCTPROGRAMENTETEIDT)
WHERE EXISTS (SELECT *
FROM sysdba.T_PRODUCTPROGRAMENTETE_TEMP
WHERE sysdba.T_PRODUCTPROGRAMENTETE.T_PRODUCTPROGRAMENTETEID = sysdba.T_PRODUCTPROGRAMENTETE_TEMP.T_PRODUCTPROGRAMENTETEIDT )

I read in another post that this query structure must work correctly for SLX 6.2 , but unfortunately it's wrong....

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Update a table from another table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Jul 09 1:58 AM

Remove the sysdba. prefix and try again - I still think it might fail, but we will be making progress.

[Reply][Quote]

Francois
Posts: 3

Re: Update a table from another table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Jul 09 2:24 AM

ahhh it was so simple...... it's work.

Many, many thanks!!

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Update a table from another table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Jul 09 2:29 AM

Excellent news, thanks for posting back.

Phil

[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:33:47 AM