Search options (Page 2 of 101)

Hi Lara.0080,
As always, attaching your project helps enormously in trying to debug any problems.
You have not specified what event you have attached your code to but I suspect that you are using 'OnMouseDown';  try attaching the code to 'OnMouseUp' instead.
Derek.

Привет Serenada, Konstantin, Sparrow,
Возможно, вы также можете добиться этого, используя стандартную функцию поиска вместе с вычисляемыми полями.
Во вложении, как и в других «фильтрах поиска», вы можете ввести минимальные необходимые размеры (неважно, вводите ли вы сначала высоту или ширину).
Возможно, это даст вам больше идей.
С уважением,
Derek.

There are a number of ways to achieve this.
One of the simplest is to display in your message the contents of a column that you specify in your script depending on the row you have clicked on (see the script in the attachment).  In this example, clicking on a row show the 'city' field.
Also you can be totally flexible and show the contents of any cell (any column, any row);  see the commented out code in the script.
Maybe this helps.
Derek.

Hi,
From your post, I assume that you are not currently using standard MVD functionality to display tablegrid footer values.
In that case, have a look at the attached example and simply replace 'fkcount' with 'fksum' in the script and adjust the column number to be the column that contains 'hoursmissed'.
However, if you are already using standard MVD functionality to display tablegrid footer values, you do not need lines 3-4 in the script.
Derek.

Привет Новичок,
Взгляните на BRD1 во вложении, который, я думаю, делает все, о чем вы просили.
Я не был уверен, почему вам нужно использовать отдельные формы (Form3 и Form4) для ведения учета и поиска дней рождения по месяцам.
Возможно, вы могли бы упростить это и просто сделать все на Форме 1 (см. BRD2 во вложении).
Кроме того, мне понравился ваш код для определения дней рождения на сегодня и завтра.
С уважением,
Derek.

Hi,
You can use 'sql query' but for something straightforward like filtering by month / year, it is much easier to use the 'search' option.
Have a look at the attachment to see how you could do it.
Please be aware that MVD is no longer being developed;  however, the software is fully functional and help is available through this Forum.
Regards,
Derek.

Hi MS2014, Salut Jean, Привет Konstantin,
What sort of changes have you made?
1.  added new fields?
2.  changed existing fields (changed field names, field definitions)?
3.  deleted existing fields?
4.  added new tables (what relationships with existing tables)?
5.  changed existing relationships?
6.  deleted existing tables?
The type of changes has a big impact on the size of task and the approach that you take.
Also, how many data rows do you have in tables that you've changed.
Depending on the answers to the above points, you may be able to simply copy and paste your data using something like SQLiteStudio
Just make sure you back up your database first!
Derek
.

COUNT(id)    what this do ???
<> 0) then Cancel := True;  --   this to check that date picker not empty , right  ???

and how to save from DateTimePicker1 to table direct as date , do you have idea ???

1.  COUNT(id) FROM tempx WHERE Date='+ Form1.DateTimePicker1.sqlDateTime) <> 0)
This checks to see if the date you are entering already exists (<> 0) as you don't want to allow duplicates.  You could write count(id) or count(*) or use any mandatory field - it's just to use something that will always be present in the record.
2.  <> 0) then Cancel := True;
This cancels the 'save' action if a duplicate date exists (ie <> 0) - if it is 0 then the record is saved.  If you want to prevent an empty date from being saved, then specify it as mandatory in your data schema.
3.  SQLite does not have a native 'date' format - dates are stored as strings and converted by the program into any date format that you specify at run time.
Derek.

Hi Lara0080, Vladimir,
What exactly are you trying to do by copying dates from 'tempx' to another table? 
It always concerns me when I read something like this because it often indicates that the data schema is not optimised or correctly designed which can cause problems as you develop your application.
Also, try to avoid using field names such as 'date' (use 'mydate' or 'tempdate' for example);  the word 'date' might be used in a script to perform some operation and therefore clash (apart from being a bit confusing).
Derek.

Salut Jean,
Yes, I think that should work.
But a couple of things to be careful about.
1.  using your example, you would need to make sure that there were no transactions dated prior to 01/01/2023 (but it's a simple test to check for this).
2.  when you create a line with a new starting balance, you might also need to bring forward the balances of 'depenses' and 'recettes' (otherwise doesn't this make your tablegrid.footer calculation of 'Solde' incorrect?).
I was also wondering whether holding 'tpaidin' and 'tpaidout' as absolute values in two discrete fields rather than simply using a single field (tvalue) and signing it positive or negative doesn't start to make things more complicated than it needs to be (and yes, I appreciate the irony of suggesting this as it was me who used absolute values in the first place )!!  I must have thought it was a good idea at the time but I can't remember why!
Can I ask why you want to delete transactions in the first place rather than use something like a filter?
Derek.

Hi Sparrow,
Everything's working well now.
Thanks for your help.
Derek.