Omnis Studio v10.1 Basic Web Dev

Martin Obongita martin.obongita at
Thu Sep 17 06:14:16 EDT 2020

 Dear Rocco,
I have amended the code thus:

Begin statement

Sta:SELECT description FROM departments

Sta:WHERE description = @[pDepartmentDescription]

End statement

If kTrue

OK message 'Duplicate department'

Quit method kFalse
End If
When I execute this method, the flag is set to kTrue and yet there is no matching record. The same script in sql query browser returns zero records.


    On Thursday, September 17, 2020, 12:20:36 PM GMT+3, Phil (OmnisList) via omnisdev-en <omnisdev-en at> wrote:  
 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.
Manage your list subscriptions at
Start a new message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list