Search options (Page 82 of 104)

Здравствуй
Я бы сделал это таким образом, но, возможно, есть лучшие способы
С Уважением,
Дерек.

Здравствуйте
Возможно, не совсем так, но вы можете скопировать существующие данные в новую запись, подобную этой.
Он не очень сложный, но он прост и работает!
Derek.

Hi Jean, Hi Mathias,
I didn't see your post so I'm not sure if you are still looking for ideas.
I too wrote a small music management app a while ago.  Its data structure is very simple -  a table for artists, a table for CDs, a table for tracks, with the obvious relationships between the 3.
Although the data structure is 'top to bottom' hierarchical (ie search from the artist down to CD down to track), I also wanted to be able to select by track and have it search back up the hierarchy - and also select by CD and have it search both up and down the hierarchy (I hope that makes sense!).
It also needed to display tracks alphabetically when searching by artist but sort by track number once a CD has been selected.
However, it doesn't try to calculate the duration of a CD (it wasn't a requirement) but I may 'steal' Mathias' script and update my program!
Anyway, I have attached it and maybe it will be of some help (the data was just for testing purposes - it's not my 'true' tastes in music - honest!!)
Regards,
Derek.

Hi Krugge,
Нет необходимости в другой таблице. В MVD вы используете рассчитанные поля.
Посмотрите пример и скриншот.
Derek.

Hi V_pozidis,
This is the way that I read and write .txt files into and out of MVDB but there may be other ways too.
In my example, I hard code the name and location of the .txt file but you could also prompt for name and location if that is what you need.
Hope this helps,
Derek.

Здравствуйте,
Может быть, так? (нажмите сочетание клавиш CTRL + tablegrid)
Дерек

Hi David,
I'm not sure from your post if you're using discrete search boxes for each field that you want to search on. 
If so, you might consider concatenating all (or a sub-set) of the searchable fields into one calculated field and just search on that instead (obviously, using '%s%' is fundamental to this). 
It's not just about reducing the number of search boxes to make it simpler, or the form neater - there are 'usability' reasons why you might choose to do it this way. 
Consider the question:  "did the user choose 'photography' from the 1st, 2nd or 3rd combobox, or type it into one of the 2 free-form fields?'  - that's 5 separate searches to find where 'photography' could have been entered.  This is reduced to 1 search using a concatenated search field - so happy users (well, at least for a few minutes!!).
Have a look at the attached - in this instance, I've combined 'name', 3 comboboxes containing 'main hobbies' and 2 free-form fields containing 'other hobbies' but obviously you can mix and match anything to suit your application.
Maybe this gives you some ideas.
Regards,
Derek.

Hi Adam,
I think I'd just leave the calculated fields as they are and do the formatting in the script - something like
tnxnumbercolumn(form1.tablegrid1.Columns[1]).formatmask := '#,###,##0.00'; 
Please see the attached.
Derek.

Здравствуйте,
попробуй это:
Form1.pagecontrol1.ActivePageIndex := 0;   
Derek.

Hi Adam,
There were a few things that I changed.
1.  you were using tgmainproducts instead of tgmainsuppliers to display products belonging to a selected supplier.
2.  you were holding qty, id_product and unitprice on your purchinv table which doesn't make sense to me - these are things that you'd store at the purchinvitem level;  if you have an invoice with 5 lines of different products, what does 'qty' mean, which of the 5 id_products are you going to hold etc etc?  Alternatively, if your application only allows for single line invoicing, then there is no point to having both a purchinv and a purchinvitem table.
3.  added calculated fields to hold net values (as they can all be derived from source data (qty and unit price)) rather than doing it by script.
I haven't changed it but I'd consider using some sort of relational lookup on the purchinvitem form otherwise you can easily be selecting products that haven't been set up for the supplier that you're invoicing - with all of the knock-on problems that will cause.
Derek

Hi Den,
Earlier, I was trying to run your project with a different version of MVD which was why I was getting an error message - all good now.
On Point 2, the easiest option might be to simply prevent the user from entering exam grades until the student record has been added;  it can get rather complicated otherwise. 
In my attachment, as an example I have set the pagecontrol to disabled in the object properties and only switch it to enabled once the student record has been created.  Additionally, there is a panel/message to explain to the user why they can't enter exam grades at that time.
But there are lots of other ways to to this and another method may be more suitable for your project / users.
Derek.

Hello Wen,
I tried to look at your Students project but had trouble getting past the 'login' screen (it returns an error in the script).
However, I put this to one side and looked at Question 3. in your message.
Place a label on top of each 'point.png' and set the label's 'transparent' object property to true.
Then calculate the number of students for each province in your script - I have added a few details so there is some data to look at.  This is on the frmmain_onshow event at the moment.
I hope this helps a bit.
Regards,
Derek.