What context would you say this in? I don't really say 'But in vain?' in English.
I tried to convince her to come home, but in vain.
"wapi" also carries the meaning of "for what purpose".
The literal translation would be "but where?", right?
Yes, depending on the context.