Rank: Member
Joined: 10/28/2009
Posts: 20
Location: Italy
|
Hi,
i have a little problem: i'm using the function Insert SQL-WHERE condition for reading to an already existing table (dbo.tabProvincies), checking if there are a province object that has the field CodeIso equals to the input, like the image below.
Instead of return the entire Province Object, i want only the value of his field idProvince. I'm not able to extract this field directly using SQL-WHERE condition, it's my fault or what? What else can i use for a task like this?
Thanks in advance you for the help.
|
Rank: Advanced Member
Joined: 12/13/2005
Posts: 2,856
Location: Mauritius
|
Simply connect idProvince to the "table" input of SQL-WHERE: in this case the result is the field and not the table.
|
Rank: Member
Joined: 10/28/2009
Posts: 20
Location: Italy
|
Thank you!
|
