UPDATE...FROM syntax

  • sray
  • Topic Author
  • Visitor
  • Visitor
12 years 1 day ago #4511 by sray
UPDATE...FROM syntax was created by sray
Is it possible to do the following type of query with PGNP?
Code:
UPDATE [SERVER].[DB].[SCHEMA].[TABLE] SET field1 = 'Some Value', field2 = 'Another Value', field3 = source.value FROM [SQL SERVER TABLE] AS source WHERE key_field = source.key_field

In testing it works as long as [SQL SERVER TABLE] only contains 1 row. Any more rows and I get the following error:

Cannot get the data of the row from the OLE DB provider "PGNP" for linked server "bbi".


I would use an UPDATE OPENQUERY however I need to set values based on a local SQL Server table. I would rather not have to create a temporary destination table, insert the rows there and then do an update query via OPENQUERY or EXEC if possible.

Thanks for any input,

Seoras.

Please Log in or Create an account to join the conversation.

More
11 years 11 months ago #4512 by Moderator
Replied by Moderator on topic Re: UPDATE...FROM syntax
This is a defect. We are working on a fix, and will let you know when fix is ready.

Please Log in or Create an account to join the conversation.

Time to create page: 0.123 seconds
Powered by Kunena Forum