Search options (Page 1 of 101)

Hi,
It's a lot easier if you attach your project - then it's possible to be totally sure what your problem could be.
However, in the case of this error message, it almost certainly refers to the fact that you are referencing a column in a tablegrid that doesn't exist (remember that column and row counts start from 0 and not 1).
Some general points to also consider.
1.  every cell in a tablegrid is handled as 'text' (or 'string').  So if you want to display the contents of individual cells in a message box,  you can do this directly without needing to use a variable or worry about converting to a specified field type (see line 9 in the script).
2.  the contents of any cell can be copied and displayed in an 'edit field' because no conversion is needed (because all cells in a tablegrid are held as text, as explained above);  see line 7 in the script and try changing the column no' to something else and you can see that it still works.
3.  if you need to copy and display, for example, a date/time value from a tablegrid (text) in a 'datetimepicker field', you need to explicitly convert it (see line 8 in the script).  This is also true for other field types.
Hopefully that makes things a bit clearer.
Regards,
Derek.

Hi Sparrow, Konstantin,
Excellent - both solutions do exactly what I need.  Specifically:
1.  I hadn't really appreciated how using
'while vi <= form1.tablegrid1.rowcount -1'
behaves differently from
'for vi := 0 to form1.tablegrid1.rowcount -1'
2.  I also wouldn't have thought to use 'break' to interrupt the 'for vi: = 0 to form1.tablegrid1.rowcount -1' loop.
As always, everything becomes so clear and obvious once someone shows you how!  
Thanks to both of you for your help.
Regards,
Derek.

Hi,
The conventional way is to load all the data into a tablegrid and then loop through each row and perform whatever calculations / checks you need.
Have a look at the attachment which gets a 'discount rate' from a look-up table and calculates a 'sale price' for each item in the 'items' table.
You can then either 'clear' the 'sale price' or change the 'discount rates' and then recalculate the 'sale prices' etc etc.
Obviously there are other checks and controls you would want to put in place but this is just to show you the basics.
Derek.

Привет,
Сделать это можно двумя способами (см. строки 7-8 скрипта в прилагаемом примере).
Второй способ (строка 8), вероятно, немного более эффективен, поскольку позволяет избежать дополнительных обращений к базе данных.
С уважением
Derek.

Hi,
Yes, it is possible (sort of!) without any code.
Have a look at the attachment.
TO CREATE a record
1.  click on the 'create' button
2.  enter your details
3.  click 'copy/save' to save your new record
4.  close the form.
To EDIT a record
1.  double-click on the row in the tablegrid you want to edit
2.  make any changes and click 'copysave' to save your changes
3.  close the form
To COPY a record
1.  double-click on the row in the tablegrid you want to edit
2.  click 'copy/save' first (this prevents the selected row from being overwritten
3.  make any changes (if creating a copy BASED on the selected row) and / or just click 'copy/save' to create your new record.
It sounds a bit complicated but just try it out in the attachment and it should be straightforward.
Just be careful when doing this as it is very easy to create duplicate records unintentionally.
Regards,
Derek.

Извините, мне кажется, я неправильно понял ваш вопрос.
Мое понимание сейчас
1. Вы хотите сохранить идентификатор последней сохраненной записи (которая не обязательно является последней созданной записью).
2. При создании нового набора данных вы хотите загрузить соответствующие данные из последнего сохраненного набора данных, и это может быть либо
2a — последний набор данных, сохраненный в этом сеансе.
2b — это последняя сохраненная запись предыдущего сеанса (т.е. программа была закрыта, а затем перезапущена).
Если эти предположения верны, посмотрите приложение.
Derek.

Hi,
Have a look at the attached.  Hopefully it is closer to what you have described.
1.  Above the tablegrid is where you specify the range of dates that you want to generate.
2.  Below the tablegrid is where you specify 1) the range of dates you want to delete and / or 2) the 'day number' of the week that you want to delete (for example, to remove all dates that fall on a Sunday, enter 1 then click delete etc etc.
Hope this helps,
Derek.

1.  See attached.
2.  form1.menu := nil is one way to prevent the standard windows menu from appearing on the start form. 
Derek.

To add the 'day of the week' as text in FastReport directly, you could
1.  add a memo field and place it on the report layout  (see the screenshot in the attachment).
2.  create a 'before print' event for the Master Data band (see the screenshot in the attachment)
3.  insert the code that Sparrow gave you in a previous post or use the code already there (see attachment).
There may be other (better) ways to do this - I don't use FastReport very much so I'm probably not the best person to ask.
Derek.

Hi Samtom, Hi Sparrow,
Personally, I would probably use a calculated field as suggested by Sparrow.
However, if you are not yet familiar with how to create a calculated field, another option is to hold the days of the week in a look-up table (see attached).
You also need to be careful viewing and creating records on the same form (Form1);  it is very easy to inadvertently create duplicate records if you have not added a bit of 'script' to prevent this.
Derek.

Привет,
Попробуйте вот так

  form1.edprice.Text := form1.GridPartsUse.columns[3].footer.caption;

Derek.