Omnis Studio v10.1 Basic Web Dev

[Phil (OmnisList)]

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.

regards
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.
>