Omnis Studio v10.1 Basic Web Dev

Martin Obongita martin.obongita at
Thu Sep 17 02:54:31 EDT 2020

 Dear All,
I have a department sql table with columns “id” and“name”
In the “departments” table class I have a method to checkfor duplicate “name” column.

I therefore pass a parameter of the old name and the newname to check for an existing department name.

Begin statement

Sta:SELECTname FROM departments

Sta:WHERE name= @[pDepartmentName] AND name <> @[pDepartmentNameOld]

End statement

When I execute the method, the flag is set to kTrue andyet there is no matching record found.

I have run this statement in the sql query builder in thedatabase and no record is found.
Where am I missing something?
Best regards,Martin Obongita.


More information about the omnisdev-en mailing list