• Registered: 2014-08-02
  • Posts: 907

Topic: SQL and CheckBox

Hello Dmitry

Let's say we have an application managing video films on DVD.

Some of those DVD are too damaged and must be changed.

The damaged DVD are indicated by a checkBox (checked = DVD to change)

What will be the good SQL syntax to show those damaged DVD in a grid ?

I've try something  with SQLExecute mais it doesn't work fine.

Thanks for your lights

JB

  • Registered: 2014-02-14
  • Posts: 10,294

Re: SQL and CheckBox

Hello,


I think you can do it without using the SQL query.
In the settings of TableGrid, you should use option "3. Filter"
where you can write the condition, example: isDamageField=1



Also you can send me your project to support@drive-software.com

Dmitry.
  • Registered: 2014-08-02
  • Posts: 907

Re: SQL and CheckBox

Hello Dmitry

You're right.
A simple SEARCH action is enough.

I looked for a problem which did not exist

Thanks

JB