|
Rank: Member
Joined: 3/6/2018 Posts: 28
|
Hi all,
I got examples of Update table set [x]=10,[y]=10 where :myAccParam = [AccNo]
But
Update table set x=10,y=10 where :myamountParam >100 and actType in ('a','b')
How can we achive this in mapforce.
Please help.
|
|
Rank: Newbie
Joined: 10/28/2002 Posts: 1,283 Location: AT
|
Hi,
you could do something like the attached mapping to achieve the desired results.
File Attachment(s): test.zip (22kb) downloaded 325 time(s).
island attached the following image(s):
|
|
Rank: Member
Joined: 3/6/2018 Posts: 28
|
Thank you island.
Update table set x=10,y=10 where :myamountParam >100 and actType in ('a','b')
In this query myamountParam value is coming from the file. and actType is in database table.
for myaccountParam , I can use solution suggested by you. But I want to update only those rows in db table which has got actType 'a' or 'b' .
Using database Table Actions in Mapforce, I can use ignore if.. . But it has only equal and equal(ign case).
in,like or greater than conditions are not there.
I am using parameterised SELECT_statement on the table now.
Just want to confirm if it can be achived by database Table Actions by ignoring rows in table with actType other than 'a' and 'b'
|
|
guest |