|
Re: check box [message #514179 is a reply to message #514171] |
Sat, 02 July 2011 05:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
"Checkbox" is a form item type. It doesn't exist in a database. However, it is easy to implement its functionality using the "Yes / No" or "0 / 1" or ... column (whether using a character or a numeric column data type).
Now, what do you call a "check box selected record"? I suppose it is one of these "Yes / No" variations. If that's so, the simplest way is to create a data block and use Forms' built-in querying functionalities (i.e. no "push button" at all): enter query mode, enter value into the checkbox item ("check it") and execute query.
If you insist on a push button, use SET_BLOCK_PROPERTY and set ONETIME_WHERE clause before executing a query (EXECUTE_QUERY) in the push button.
|
|
|