Search options (Page 3 of 101)

Without attaching your project to let people see exactly the problem, it's hard to suggest anything.
One immediate question (again, without having seen your project) is why you need to use a separate search form?
Derek.

Hi TCS,
It works for me as of 5 minutes ago (although I did have to click the 'extra' prompt ("if your download doesn't start automatically, click here).
Or there is also a link to 6.6.1 (Beta) that Konstantin (K245) has provided - https://drive.google.com/file/d/1Q7Rk73 … 3RFwm/view
Regards
Derek.

Hi,
If, as in your example, you only have two order statuses ('waiting' and 'ok'') then wouldn't it be easier to just add a boolean field to table 'aaaa' rather than use a related table 'xxxx'.  That said, in my opinion, there are issues for the end-user using boolean fields (centred around the 'allowgrayed' condition and the fact that the 'checkbox cannot be resized and so making it rather awkward in use.
Another approach would be to use a combobox instead of a check box (I was a bit puzzled that you already use a combobox on Form2 but then choose to use a checkbox on Form1). 
Personally, I find comboboxes a better option because
1.  more user friendly
2.  in the tablegrid, you can display the actual combobox value rather than 'yes' or 'no' (as is the case with booleans)
3.  if you need to add new options (not just 'waiting' and 'ok') then it can be done without any re-working of the program.
4.  if you use the multi-select option with the combobox, you have complete flexibility as to what combination of options you want to include / exclude when filtering.
Both the 'boolean' approach and the 'combobox' approach are in the attachment.
Of course, there are other possibilities as well but these would probably involve some script.
Hope this helps,
Derek.

Привет,
Посмотрите на скриншот во вложении и пример проекта.
Действительные пользователи и пароли
Admin/admin - неограниченно
Derek / Derek - неограниченно
Colin / Colin — имеет доступ только к отделу «Research».
Brian / Brian — имеет доступ только к отделу «Accounts» и Отдел «Sales».
С уважением,
Derek.

.
Have a look at the screenshot in the attachment and the sample project.
Valid users and passwords are
admin / admin - unrestricted
Derek / Derek - unrestricted
Colin / Colin - can only access 'Research' Department
Brian / Brian - can only access 'Accounts' Department and 'Sales' Department.

Hi Eyeman,
Hope you're keeping well.
Yes you could always limit the initial load to a set number of records with a filter than runs when you start your program.
However, from the screenshot, I see that you're only loading 2482 records (can't see that any filters have been applied);   if I remember rightly, that will be from the lead table 'opd_registration' which isn't really that many rows (notwithstanding your large number of tables and relationships).
So I'm wondering if there are other things that are making your program run slowly.
Maybe it would be better if you upload your project and people could have a look and see if there are other areas that could be looked at to improve performance (for example, the number of calculated fields or if you're looping through grids to apply column formatting etc etc).
If you have concerns about data privacy, you could always take a copy of your project and then anonymise the names before zipping and uploading.
By the way, love the 'LifeStatus' of 'Alive&Kicking'
Regards,
Derek.

Hi Manix,
Have a look at the attachment (specifically lines 60-80 in the script - it's Dmitry's code from an example he posted on the Forum some years ago that you should be able to find if you search for it)..
1.  double click on a date, enter some text and save - this will bold the date.
2.  double click on a date, delete the text and save - this will un-bold the date.
3.  enter any search criteria at the bottom of the calendar (or '?' to see everything).
It actually makes the date on the calendar bold rather than highlighting it but maybe this is sufficient for what you want.
Derek.

  sqlexecute('update example set exampledate = date(exampledate)');

removes the 00:00:000

Hi,
The short answer to your question is 'no, you don't need to store the date in a text field'.
SQLite doesn't have a 'type' for 'date/time' - in MVD, dates and times are actually already stored as text and are then converted by the in-built date / time functions of SQLite at run-time.
What you actually 'see' on screen and what is stored depends on how you have defined it in your data schema.
If you have chosen 'date' in your schema then when you save a record, the date component is stored and the time component defaults to 00:00:000.
If you have chosen 'time' in your schema then when you save a record, the time component is stored and the date component defaults to 1899-12-30 (which is SQLite's minimum date)
If you have chosen 'date/time' in your schema then when you save a record, both the date and the time components are saved.
Have a look at the attached example and the screen shot showing how the SQLite date/time field type is stored.
Derek.

Salut Jean,
With the program that I use to catalogue my CDs, I don't bother with CD cover images or to capture the lyrics (too much like hard work ).
But just out of interest, I made a version with CD covers and lyrics just to see how it could be done (I don't use 'treeview' very much and some of the differences between it and the usual tablegrid approach are quite interesting and I need the practice!).
I was trying to do everything without any buttons (a combination of interactive tablegrids, treeview and right-click actions but had to admit defeat with saving the images so there is still one button)!!
Anyway, I've attached it and maybe it helps.
Regards,
Derek.

Hi Jean,
The project I posted for user FrankLabre had a few bits taken out to simplify the script so he could see just the things that related to his questions.
If you're going to use it (or some amended version of it), here is the version with some of the functions added back in (colour coding / bold font of nodes and adding counts for the number of tracks on each CD).
Unfortunately, in the script I had to hard-code the checks for the 'parentid' (I should have reset the sequence number back to zero before I started but forgot - my bad!!  ).
Good Luck - 500 CDs is a lot!!
Derek.

Hi,
In one of the user guides, there are some references to 'treeview' but it's along the lines of 'this is what it is' rather than how to create a project using it..  I've always found it better to use this Forum's search function, look at the various posts and download projects that are of interest and use them as a guide (but I guess we all 'learn' differently).
Wit regard to using separate forms, 'standard' MVD takes the approach of one form to list the data (which can also be used for 'searches') and a second form for data maintenance.  However, it is possible to use the same form for both functions if you write a small script.
On a more general note, I should point out that MVD is no longer under active development and support for the software is solely via this Forum.  But if you submit detailed questions that are accompanied, if possible, by a project that illustrates the problem, you will almost always get a speedy response;  questions along the lines of the  "....I can't see my data.  What's wrong?' variety tend to, understandably, not get much of a response -
Regards,
Derek.