[Stackoverflow] [Progress OpenEdge ABL] OpenEdge ODBC UPDATE for multi-tenant database

  • Thread starter Thread starter Leluloota
  • Start date Start date
Status
Not open for further replies.
L

Leluloota

Guest
When using ODBC to OpenEdge multitenant database I can make query and get expected result. SELECT "LogiVal" FROM PUB."SysCtrl" AS mtc WHERE tenantName_tbl (mtc) = ('tenantID') AND "ParamId" = 'AccoGrpProd' This will return only one column / row as expected.

I can easily update this field to all tenants, but how to limit it to specific tenant?

I'm using DBeaver while testing query syntax and thought the syntax would be similar as in SELECT but no luck. This is what I tried. Let's say I like to set value to field "LogiVal" = "1".

UPDATE PUB."SysCtrl" AS mtc SET LogiVal = '1' WHERE tenantName_tbl (mtc) = ('tenantID') AND "ParamId" = 'AccoGrpProd'

Continue reading...
 
Status
Not open for further replies.
Back
Top