Home » Developer & Programmer » Forms » check box (forms6i)
check box [message #514171] Sat, 02 July 2011 01:22 Go to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

Hi,

can i know how to display check box selected records in one column of form when push button is pressed.
Re: check box [message #514179 is a reply to message #514171] Sat, 02 July 2011 05:30 Go to previous message
Littlefoot
Messages: 21818
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.
Previous Topic: Capturing keyboard input data
Next Topic: problem to call web util form
Goto Forum:
  


Current Time: Mon Sep 16 21:18:23 CDT 2024