compare field of table with field in view

guido · Post by **guido** » Fri Nov 29, 2019 3:53 am

Current situation: Table Formed and view vwvgtoza. Now I would like to compare field CLUB of this view with field PLT of table Formwed.
$ this-> CLUB -> ???
ViewValue ??
$ vwvgtoza-> ??
table Formwed $ this-> PLT-> CurrentValue
I very appreciate your help

arbei · Post by **arbei** » Fri Nov 29, 2019 10:54 am

It depends on where you want to compare them. You may always use ExecuteScalar("SELECT .. FROM ... WHERE ...") to get the value from the table/view to compare with the current value.