Topic: Tablegrid - no auto-execution
Hi,
I am new to MVD and just trying it out but i am really impressed so far. I have 3 questions and apologies if they've been answered elsewhere (i have gone through the forum topics and couldn't find anything similar).
1. I have a tablegrid (set to 'no auto execution of the query' so that it initially displays zero rows), a search criteria and a search button. However, the user can simply press the search button without entering any search criteria to retrieve all the data table rows which is not what i want. I am trying to force the user to enter something in the search criteria, retrieve only the relevant sub-set of data rows and then when the selection criteria are cleared, the tablegrid should again display zero rows.
I have tried using 'incremental search' which works for the first time but when the search criteria is cleared, the tablegrid again shows all rows. I have also tried using a filter on the field i am searching on and a filter in the tablegrid but neither works. Is there something i am not doing correctly?
2. I have an area of one screen where i have written some brief Help notes for the user. However, i have only been able to achieve this by using multiple text labels! Although it looks ok, it is difficult to maintain. Is there a better way to achieve this?
3. Is it possible to align numeric fields to the right in a tablegrid?
I have attached project details in case this makes it easier to understand what i'm trying to achieve.
Sorry for writing in english but i only know a few words of russian! Thanks in anticipation and congratulations on a great piece of software.
Derek.