Omnis Studio v10.1 Basic Web Dev

[Rocco [KUNVI]]

Actually you don’t need to add the

AND name<>...

comparison in the WHERE section...

Bye

Rocco

Il giorno gio 17 set 2020 alle 08:54 Martin Obongita via omnisdev-en <
omnisdev-en at lists.omnis-dev.com> ha scritto:

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

_________________________________

Distinti saluti. Best regards.



*Rocco Dr. Ventura*

WMS Analist and Software Developer



*KUNVI srl - **Experiences Holding *(G)* - www.kunvi.it
<http://www.kunvi.it>*

Email: r.ventura at kunvi.it - Mobile: +39 348 5186051