Home
|
Forums
|
Contact
|
Search
|
Syndication
[login]
[create account]
Friday, April 19, 2024
slxdeveloper.com
Home
Search
Contact us
About slxdeveloper
Syndication
Community
Forums
(NEW!)
Newsletter Archive
Members
Your Profile
Submit Article
General
Administration
(6)
OLE DB Provider
Miscellaneous
(2)
Architect
VBScript
(9)
ActiveX Controls
(6)
How To's
(14)
.NET Extensions
(3)
External
OLE DB Provider
(12)
SLAPI (SlgxApi.dll)
SalesLogix COM
(1)
Web
ASP/ASP.NET
(2)
Web Services
Web Client
Downloads
Samples
(17)
Documentation
(7)
Utilities
(18)
Resources
SalesLogix
(3)
Programming
(1)
4/19/2024 11:30:20 AM
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:
Dynamic
Flat
Tree
Search:
Author
Thread: Update a table from another table
Francois
Posts: 3
Update a table from another table
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
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
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
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
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
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): 4/19/2024 11:30:20 AM