[progress Communities] [progress Openedge Abl] Forum Post: How To Filter Data In Binding Source

  • Thread starter Thread starter Kai Siegele
  • Start date Start date
Status
Not open for further replies.
K

Kai Siegele

Guest
Hallo, I want to show only the rows of table specifed by conditon in an abl-form in a data grid view. For that purpose I have created a new ABL form-class I have added a data grid view to the form. I have added a (Progress.Data.)BindingSource to the form. Using the ProBindingSource-Designer I have added the table to the binding source. I have specified this binding source as datasource for the data grid view. After learning that the filter-attribute has no function i have followed the suggestion of http://knowledgebase.progress.com/articles/Article/P134212?popup=true and wrote the following method. METHOD PRIVATE VOID FilterRows(input cFilterString as character): DEFINE VARIABLE hQuery AS HANDLE NO-UNDO. CREATE QUERY hQuery. hQuery = THIS-OBJECT:bindingsource2:HANDLE. IF (VALID-HANDLE(hQuery)) THEN DO: hQuery:QUERY-PREPARE(cFilterString). hQuery:QUERY-OPEN(). END. ELSE MESSAGE "Query not found" VIEW-AS ALERT-BOX. return. END METHOD. Unfortunatey I get always the message Query not found. Has anyone an idea why? Kind regards Kai Siegele

Continue reading...
 
Status
Not open for further replies.
Back
Top