Search options (Page 1 of 110)

Привет, Викус!
Если я правильно понял твой вопрос, то можно попробовать что-то вроде этого (с этим решением тебе не придётся «жёстко прописывать» категории, так что можно просто добавить новые, и счётчик автоматически начнёт отсчёт с 10 000 для каждой новой категории).
С уважением,
Derek.
.
If I understand your question correctly, you can try something like this (with this solution you don't have to "hardcode" the categories, so you can just add new ones and the counter will automatically start counting from 10,000 for each new category).

Hi Roberto, Konstantin,
Attached are a couple of suggestions that might help.
1.  Hide Columns Persistent.
With this option, the selection of hidden columns is persistent between sessions. 
Click on the 'Columns' button and then click on the columns in the 'pop-up' grid that you want to hide / unhide (highlighted with an 'x') and then click on the 'Columns' button again.
2.  Re-sort Columns Persistent.
With this option, the order of the columns in the tablegrid is persistent between sessions.
Click on the 'Columns' button and then 'drag and drop' the columns in the 'pop-up' grid in whatever order you want.  When they are in the order that you want, click on the 'Columns' button again to re-sort the tablegrid.
Maybe this can give you some ideas.
Regards,
Derek.

Hi FMR,
If you use 'Styles', then this is just a single line of code in the script to change the colour (thanks to Sparrow for this tip).  Have a look at the attachment.
But if you're not using 'Styles', I don't know of any way that this can be easily done (if at all).
Regards,
Derek.

Привет Sacha,
Я изменил код вашего вычисляемого поля, чтобы отображались правильные значения.
Однако это не главная проблема.
Связи между таблицей "culinary_product" и таблицами "stocks" и "product" не поддерживаются автоматически из-за того, как вы создали свое приложение.
Посмотрите на "screenshot" во вложении, который показывает, как хранятся ваши данные.
* Я вручную добавил связи для первых двух записей (чтобы "вычисляемое поле" отображалось правильно).
* Затем я добавил третью запись ("curry"), и это показывает, что связи "null".
Вам нужно исправить это, прежде чем вы сможете добиться какого-либо прогресса.
С уважением,
Derek.

Hi Adam, Salut Jean,
Ça va ? Il fait très chaud en France en ce moment, je pense! Reste cool! 
I'm guessing that you just want to use an icon as a toggle - simply click it to mark a node in the tree as requiring attention and then click the icon again when you're done with it.
I just used unicode symbols rather than true 'icons' as I always like to keep the scripts as short as possible.
Maybe try something like the attached (I've used 'color' to highlight nodes rather than 'bold' but the principle is the same).
Regards,
Derek.

Hi Adam,
How's it going?
Would it be enough just to change the treeview grid properties?
Specifically,
1.  remove the tick from Additional / AppearanceOptions / aoalphablendedselection
2.  add tick to Additional / AppearanceOptions / aoboldtextselection
3.  change Additional / HighlightedTextColor to (whatever you want)
4.  optionally, remove tick from Additional / Options / GoSelectFullRow (so only a single cell is highlighted rather than the full row).
Nice and simple, no script required.
Not sure why you'd want to have this on a button or a right-click rather than just clicking on the cell.  However, if you do need to do it that way, try adding this code (or something like)

procedure Form1_Button4_OnClick (Sender: TObject; var Cancel: boolean);
var  vi, vr: integer;
begin
  vr := form1.treeview1.SelectedRow;                          //** make a note of which row has been highlighted
  form1.treeview1.dbupdate;                                   //** re-set the tree (remove colour and bold attributes)
  for vi := 0 to form1.TreeView1.RowCount-1 do                //** cycle through the grid
    begin
      if form1.treeview1.SelectedRow = vr then                //** if row matches the highlighted row
        begin
          form1.TreeView1.cell[0,vr].textcolor := clred;      //** set colour
          form1.TreeView1.cell[0,vr].FontStyle := fsbold;     //** set bold
        end;
    end;
end;

See attached (one of your old projects).
Derek.

Hi FMR,
Not sure I understand what you mean by 'sqlite copy problem', but to prevent multiple users logging on, bascially you could try something like this (see attached).
Login details
admin / admin
FMR / fmr
Derek Larsen / derek
Regards,
Derek.

Hi Sparrow,
Thanks for the fix.
I knew about the issue with 'panels' (it's the same for 'group boxes' as well) but they are not used in my application (at the moment!).
Regards,
Derek.

Привет Vickus,
Несколько способов, которыми вы можете сделать это (см. 2 варианта в приложении).
С уважением,
Derek.

I would suggest adding an 'expiry date' to your services table and then add a small script to check if any new orders try to use a service that has expired.
This means that old orders that were raised before the service expiry date will still be accessible.
See attached for a basic idea.
Derek.

Hi,
Probably a couple of ways to fix your issue but I like to keep things simple (where possible).
See attached.
Derek.

Hi Sparrow,
You have excellent eye-sight to spot the ',' instead of '.'! 
Derek.