UPDATE...FROM syntax

More
9 years 10 months ago #4511 by sray
UPDATE...FROM syntax was created by sray
Is it possible to do the following type of query with PGNP?
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
9 years 10 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.051 seconds
Powered by Kunena Forum