Search options (Page 71 of 104)

Hi,
Is this the sort of thing that you're meaning (please see attached).
If I understand your question, all you need to do is specify the active/inactive combobox as the search criteria associated with the 'report' button.
No script is required for something like this.
Regards,
Derek.

Hi,
Yes, the instruction is in the script.
Remember that in MVD, the first column in the tablegrid starts at Column 0 and the first row in the tablegrid starts at Row 0 (this is what [0,0] in the line of script...... form1.tablegrid1.cells[0,0] refers to).  It is the co-ordinates of the cell value that we want to use.
So, in the script, the line 
if form1.tablegrid1.rowcount > 0 then form1.edit2.text := form1.tablegrid1.cells[0,0] else form1.edit2.Text:= ' ';
takes the contents of the cell in Column 0 and Row 0 in the tablegrid and copies the contents to form1.edit2.text.
Hope that's clear.
Derek.

This is how it could work if you do it with comboboxes - the association between keywords and categories is taken out of the script and can therefore be maintained by anyone.
This is okay if you need to analyse activity at both 'keyword' and 'category' levels, but if you just only to see activity at the 'category' level, I think I'd just use a single combobox, selecting values manually;  you can always make your combobox 'searchable' to speed things up, if that's your concern.
Derek.

Hi,
A couple of ways to do it.
1)  use 'sqlexecute' and select the value from the table;  as there can only ever be one row in your table, there is no need for a 'where' clause.
2)  copy the value from the tablegrid cell (as there is only one row and one column, you can hard-code the cell location ([0,0]).  Perhaps this is a slightly better option as it avoids making an extra call to the database.
Regards,
Derek.

Hi,
Place your label on a form and then create an 'on click' event (please see attached).
In the example, you click on the label and it takes you to a website.
You can do extra things to make it more user-friendly - in my example, I 'nudge' the label so it looks like it has been clicked, I change the cursor from an 'arrow' to a 'handpointer' when it hovers over the label and I add a text hint.
You can also do all of these things with images, icons etc.
Regards,
Derek.

Привет,
Посмотрите на прикрепленный пример и скриншот.
Вы можете разместить его в фиксированном месте или вы можете разместить его относительно других форм
(form2.top := form1.top + 50
form2.left := form1.left + 150) etc etc
С Уважением,
Derek

Hi,
Quite a few different ways to approach this, I imagine.
The easiest way of all would simply be to use a tablegrid and have filters on each of the days - click the appropriate filter for whatever day of the week and the rows in the tablegrid adjust accordingly.  And you shouldn't need to use a script with this approach.
But if you want to see a delivery schedule for discrete days in a separate tablegrid, then I think I'd try it this way (see attached);  I've tried to keep the script to a minimum.
As per your write-up, when you run the program, it defaults to the current day of the week and customers who have deliveries for that day.
But I imagine someone is always going to want to know about tomorrow etc etc (LOL!), so just enter a different day number (Monday = 1 - Sunday = 7) and you can see different schedules for different days.  And if you enter a space, it shows ALL schedules.  Deleting the number (or the space), clears the tablegrid.
Perhaps this gives you some ideas.
Derek.

Привет
Просто добавьте эту строку в конце процедуры для Button1

procedure Form1_Button1_OnClick (Sender: TObject; var Cancel: boolean);
begin
  x
  x
  x
  x
  form1.button2.click;
end;

Derek.

Привет Vit007,
Если я правильно понимаю ваш вопрос, вам не нужно использовать скрипт. Связывание таблиц является частью стандартной функциональности MVD (см. Прилагаемый пример).
С уважением
Derek.
(с гугл переводчиком)

Hello,
There are several ways of restricting access to specific users but yes, it is possible (and straightforward).
You could, for example, make your entire tablegrid non-editable for anyone and then restrict access to a maintenance form to 'admin'.  Or, if your tablegrid is editable, certain columns can be made view-only (or hidden completely) to 'basic' users.
Derek.

Hi,
As per your description of the requirement, I'd probably do it something like this (see attached).
The user doesn't have to do anything except enter readings (the program creates a new row automatically for the current date (if it doesn't already exist) and puts readings into the correct 'morning' or 'evening' field depending on the current time). 
For information, the last week's worth of readings are displayed and there is also an option to manually maintain dates/times/readings to correct for any errors or omissions (mistakes are bound to be made!).
Perhaps this approach gives you some ideas.
Derek.