Search options (Page 83 of 104)

Morning Wen, EHW,
EHW - I've never looked at any of the charting options before so you saved me having to scratch my head over this one - very nice!
Wen - one thing you might consider is automatically updating the pie-chart rather than doing it on the button (see attached).  But it's just a cosmetic thing, the real work has already been done by EHW and yourself.
Derek.

Hi,
If I understand your question correctly, a single relationship between two tables will automatically retrieve any relevant text.  Subsequent relationships between the same two tables will only retrieve the record id and not the relevant text.  To retrieve the relevant text for these, the easiest solution is to use calculated fields.
If you can attach your project, someone will be able to show you how to do it or take a look at the attachment (specifically, the 2 calculated fields that are used to retrieve the text from the related table).
Derek.

Привет Макс, Дмитрий,
Возможно, это еще одно решение??
Derek

Привет Netros,
попробуйте это с вашей версией
Regards,
Derek.

Привет Netros,
Помогает ли это?

procedure Form1_OnShow (Sender: string; Action: string);
begin
  form1.combobox1.dbSQLExecute('select distinct FIELDNAME from TABLENAME');
end;

Кроме того, вот пример

Regards,
Derek.

Hi David,
It's not really a question of 'date' OR 'text'.  'Date' is just a data type, not a storage class (valid storage classes are 'text', 'real', 'integer', 'blob' and 'null'). 
So before your 'date' data type is saved, it first needs to be converted into one of these storage classes - in this case, to 'text', which is why Mathias has to do the conversion.  And the same holds for the 'time' data type.
I hope this helps to clarify it a bit.
Derek.

Здравствуйте Raspr,
If I understand you correctly, use calculated fields for id_user1, id_user2......
Please see attachment,
Derek.

Hi Adam,
Glad it helped.
I frequently use tablegrid filters with multiple grids (provided I have space on the form, I prefer them to pagecontrols and sheets)  to show different 'views' of the data.  And when you combine them with options such as grid colouring, default field values etc, it can be quite effective - all without any script.  Or a few lines of script gives you cell highlighting too.
It's not a cheat's sheet but see the attached (basic view and then 3-4 different options for presenting the data) for the sort of thing I'm meaning
Regards,
Derek.

Hello Popcorninicusor, Jean,
I had an old example that was pretty close so I've modified it and attached it - maybe this will help.
This doesn't do 'flashing' cell colours (not entirely sure how you would actually code for that) but, in my experience, it tends to be quite annoying after the first couple of minutes anyway!
Dont worry about being a novice - we've all been there - LOL!
Regards,
Derek.

Hello Hadjieff,
You could use a calculated field for this (see attachment and screen shot (calculated field.jpg)).
Derek.

Hello Ljhurtado,
Add this line between the final 'begin' and 'end' of your script as follows:

  Form1.TableGrid1.dbPopupMenu.Items[0].Enabled := False;

Please see attached for an example and i hope this helps,
Regards,
Derek

Hi Lectrond,
Thanks for the attachement.
Was the 'machine parts' table previously named 'service_records'? 
Simply renaming a table or field in MVD doesn't normally cause this type of problem so I'm wondering if the database was moved or copied from another location with a schema that was out of sync with the current MVD table definitions.
Anyway, in this instance, all you need to do is to delete sqlite.db and then run your project again;  sqlite.db will recreate itself and start to use the updated schema.
Hope this moves you forward,
Derek.