KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Using the OBJECT SET ENTERABLE command with dynamic SQL queries into a List Box
PRODUCT: 4D | VERSION: 12 | PLATFORM: Mac & Win
Published On: March 30, 2012

The OBJECT SET ENTERABLE command also works for List Boxes which can be very useful when performing a SELECT into list box via SQL:

BEGIN SQL
  SELECT * FROM Table_1 INTO :LB_QueryOutput;
END SQL
// set the list box display to not enterable
OBJECT SET ENTERABLE(*;"LB_QueryOutput";False)


If the OBJECT SET ENTERABLE command was not used in the example above, the person viewing the list box may believe they can make live changes to the data by manipulating the contents of the list box. Using the OBJECT SET ENTERABLE command helps set the state of the list box to prevent the user from thinking they can manipulate the live data.