Omnis Studio v10.1 Basic Web Dev

[Martin Obongita]

 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.

Regards,Martin.






    On Thursday, September 17, 2020, 12:20:36 PM GMT+3, Phil (OmnisList) via omnisdev-en <omnisdev-en at lists.omnis-dev.com> 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.

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.
>
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com