Trying to edit result set with custom editing

Toad for SQL Server
1

Hi, I’m trying to edit the result set of this select:

select (select name from service where service_id = fk_service_id ), * from access where fk_user_id in( 89581,90476 )

I have made the following changes in Define custom editing:
Key columns: ACCESS_ID
Table name: ACCESS
Updateable columns: ACCOUNT, STATUS
Update command: UPDATE ACCESS SET ACCOUNT = @f1, STATUS = @f2 WHERE (ACCESS_ID = @f3 OR (@f4 = 1 AND ACCESS_ID IS NULL))

When I edit the ACCOUNT field in the result set, I get this error: “Incorrect syntax near the keyword ‘SET’.”

However, when I set only ONE field in the Updateable columns, editing works well:
Updateable columns: ACCOUNT
Update command: UPDATE ACCESS SET ACCOUNT = @f1 WHERE (ACCESS_ID = @f2 OR (@f3 = 1 AND ACCESS_ID IS NULL))

TIA
SanskritFritz

2

Hello,
thanks for the report. It is definetely an issue, I’ve created CR107216 to address this.
From what I see it works fine if you update both of columns at a time in first case :slight_smile:

3

Thanks for your answer. The workaround works, I can live with that actually :slight_smile: