select in a tableframe

[christoffel]

Hello,
What is the easiest way to select a few records in a tableframe in a form with the same value in one field. This field is not an indexed field.
Thanks.

I find it not easy to use SetChange and switchIndex.

Also i have problems when the field is an indexed field.

 

[TonyMcGuire]

var
ui uiobject
dy dynarray[] anytype ; string
endvar
dy["FieldName"]=valuetolimitview
ui.attach(tableframename)
ui.setGenFilter(dy)

Let us know if this works.

To go back to ALL records, use
ui.dropgenfilter()


Tony McGuire

http://www.thedbaddons.com

http://www.thedbcommunity.com

 

[christoffel]

It doesnot work.

method open(var eventInfo Event)
var
ui uiobject
dy dynarray[] anytype ; string
endvar

dy["Opdrachtgever"]=hbedrijfnaam ; opdrachtgever is field in tableframe, hbedrijfnaam is field in form
ui.attach(zoekdeb)
ui.setGenFilter(dy)
endMethod

 

[TonyMcGuire]

If it didn't work, then something else is going on.

Can you move the code to a pushbutton rather than open(), and see if that works?

Tony McGuire

http://www.thedbaddons.com

http://www.thedbcommunity.com

 

[christoffel]

YEs it works in a button and i know why. The field i use in the form that i opened with "wait" must first open the form and the tableframe. After that it can use the value of the field i filled in the other form.
thanks