How To Enable Column in FreeForm Query

S

skunal

Member
I want to Enable a column for Updating in freeFormQuery browser(OPENEDGE 10.1c) I tried Using Handles and all by specifying the attribute READ-ONLY but its giving the error that column should be enabled in Define Browse stmt for attribute Read-ONLy.Can anyone know how to make it work,
 
Skunal, are you using the AppBuilder? If so, try selecting the browse and in the "Display Trigger" - Section Editor Window - after the displayed fields add something similar to this:

Code: 
ENABLE
   jhtickets.batch
   jhtickets.ticket
   jhtickets.tktDate

Does this work?
 
THIS works BUT i have popmenu in the Browse when i click on Update (From popup Menu ) then only it Should Enable . If i write the code of Enable in Display Trigger it will always be Enabled which is not what i want. I want to write the code in the Popup Menu Trigger .
 
Does first setting either BROWSE brws1:READ-ONLY = FALSE or jhtickets.batch:COLUMN-READ-ONLY IN BROWSE brws1 = TRUE then changing when selecting from the pop-up menu help?
 
I tried it but it says READ-ONLY attribute cannot be set . And i cant write it in display Trigger also as it gives error. In which block of code shall i write Read-ONly = falsu
 
Only put the ENABLE statement in the Display trigger.

Providing the browse has no focus, the ASSIGN brws1:READ-ONLY = TRUE (or FALSE when updating) should be okay in most code triggers/blocks. If this is a problem and instead of assigning the column as read only does just assigning the field as read only - jhtickets.batch:READ-ONLY IN BROWSE brws1 = TRUE (or FALSE when updating) - work instead?
 
for Read-Only = false or True if i write in any Trigger(I wrote in Row-Display Trigger) it doesnt give Compile Time Error but it gives me Run time error that Read-Only attribute cannot be set in Row-display trigger. Read-only cannot be set for this fill-in .
 
If i write Read-Only = false or true in any Trigger( I wrote in Row-Display Trigger) it dosent give me complie time error but generates the run time error as Read-only cannot be set in Row-display trigger and Row-display cannot be set for this fill-in the ERROR Numbers are 4477 and 3131.
 
Putting in the ROW-DISPLAY trigger will give these errors.

Before you enable the browse for the very first time try setting the browse READ-ONLY to TRUE - this could be done in the MAIN-BLOCK and before you run enable_UI.

When you want to enter data something on these lines should work:

Code: 
ON CHOOSE OF m_update DO:
   DISABLE brws1 WITH FRAME f1.
   ASSIGN brws1:READ-ONLY = FALSE.
   ENABLE brws1 WITH FRAME f1.
   APPLY "ENTRY" TO jhtickets.ticket IN BROWSE brws1.
END.

When finished updating something like this is required:

Code: 
APPLY "ENTRY" TO Btn_View. /* Removes focus from the browse */
ASSIGN brws1:READ-ONLY = TRUE.

If still problems, post a snippet of the code.
 
Hey Thanx a Lot It Worked...............................but still i think Openedge should have made it simpler to use the browser because we are enabling and disabling the browser just to make this work .This feature of update should be made more developer friendly to use it.
 
You must log in or register to reply here.
Back
Top