Omnis Studio v10.1 Basic Web Dev

Phil (OmnisList) phil at
Thu Sep 17 05:20:21 EDT 2020

Hi Martin,

Was it a typo in the email, or is there no space between select and 
name, I think that won't help.

and as Rocco said, you only need the name='xx' in the where clause.

Phil Potter
Based in Chester in the UK.

On 17/09/2020 07:54, Martin Obongita via omnisdev-en wrote:
>   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