Search options (Page 56 of 101)

Здравствуйте Konstruktor,
В вашей программе base.id_passenger имеет значение null (см. Screenshot.jpg во вложении).
Я изменил ваш сценарий так, чтобы этот base.id_passenger теперь содержал passenger.id.
Кроме того, menu.editcounter1 не был включен в список полей для сохранения.
Derek.
.
In your program, base.id_passenger is null (see the screenshot.jpg in the attachment).
I have changed your script so that that base.id_passenger now holds the passenger.id.
Also, menu.editcounter1 was not included in the list of fields to be saved.

Здравствуйте Agatlogic, Dmitry, CDB,
Возможно, вы можете просто дважды щелкнуть ячейку в столбце «Женат *», которую хотите изменить (см. Пример), и вообще не использовать флажок.
С Уважением,
Derek
.
Maybe you could just doubleclick on the cell in the column 'Married*' that you want to change (please see the example) and not use a checkbox at all.

Hello Senioke,
Is it just details of the user, date of change, time of change and type of change (add, update, delete) that is made?
Or do you also need to know the specific fields that have been changed and, if so, do you then need to know the 'old' and 'new' values of those fields?
Derek.

Привет Sacha,
Сценарий сложен, когда вы пытаетесь применить все проверки, которые вы должны иметь. Я постараюсь взглянуть, но я сейчас очень занят.
Но вы можете многого добиться, просто используя базовую функциональность MVD и создавая свои формы так, чтобы они выглядели как одна форма с всплывающим окном.
Пожалуйста, посмотрите на приложение с несколькими предложениями о том, как вы можете сделать это с помощью небольшого простого скрипта.
В зависимости от разрешения экрана вам может потребоваться настроить координаты формы 3, указанные в сценарии (см. Прилагаемый снимок экрана).
Может быть, это даст вам некоторые идеи.
С уважением,
Derek.
.
The script is complex when you try to apply all the checks that you must have. I'll try to take a look, but I'm very busy right now.
But you can achieve a lot by simply using the basic functionality of MVD and creating your forms so that it looks like one form with a pop-up window.
Please look at the application with a few suggestions on how you can do this with a small simple script.
Depending on the screen resolution, you may need to adjust the coordinates of form 3 specified in the script (see the enclosed screenshot).
Maybe this will give you some ideas.

Hi Everyone,
You can also just manually type in ANY tablename (in the 'foreign key' property) and ANY fieldname (in the 'fieldname' property) - please see the attached screen shot.
It's quick and easy but obviously it doesn't give you the option to have just distinct records (as Jean's code does) nor does it know anything about the record's "id" (as EHW rightly points out).
Derek.

Здравствуй Agatlogic,
Создайте переменную с типом «tdatetime» (см. Пример).
Derek

Привет Agatlogic,  (Salut Jean, tu va bien?),
Я думаю, что мы все рассчитываем даты по-разному.
Я всегда стараюсь избегать использования скрипта (не очень часто!), Поэтому вместо этого я использую вычисляемое поле.
С Уважением,
Derek.

Hi,
I don't have an example with users and roles but the syntax should be the same.
Please have a look at the attached which allows for the username to be either entered in an edit field or selected from a combobox (comment out whichever option you don't use in the script). 
Then the value entered in the sign-on screen carries forward to a new form and pre-fills the combobox with the logged in user.
Derek.

Hi EHW,
I think your interpretation is much closer to the requirement than mine (I'd assumed every day would be a new 'task list').
But it makes more sense now I've looked at your attachment - in effect, it's a single row table that updates each of the tasks with 'today' when any of the tasks is clicked and then colour-codes them depending on how many days ago that specific task was last ticked.
By the way, really like your
    ShowRecord(Form1, 'Mytasks', 1); 
Never seen it done like that before - I've always used a hidden tablegrid and hidden 'show record' button but it always struck me as being rather crude.
Regards,
Derek.

Hello Leprince2007,
In order to achieve what you want, you need to change your table structure.  You currently use checkboxes to show if a task has been completed or not but nowhere do you save the date of completion.  If you don't hold this, then how do you know what date to put into your labels? (you can't derive it from a checkbox because it only holds a value of 0 or 1).  You would need to add a date field for every checkbox that you have (eg excavators checkbox, excavators date etc etc).
Personally, rather than use checkboxes AND dates, I would just use dates for each of your tasks because it tells you all you need to know (if the date has not been checked, the task has not been completed and if it has been checked, you know that it's been both completed AND the date on which it was completed).  Then you just change the label associated with the date fields to show whether the task was completed on time or not.  It's just my opinion but it seems much more straightforward.
Please see the attached suggestion which is a scaled down alternative to your project to see how the label colour coding works in conjunction with the date fields for each task (no colour = on time, green = 1 day late, red = 2 or more day late, yellow = not completed).
Also, your project didn't have any way of retrieving saved records (no tablegrid or combobox to selected a record from and no show record button) so I've added these.
I hope this gives you some ideas to move forward,
Derek.

Здравствуй ABC52,
попробуй вот так
substr(Db,1,5)||' - '||substr(De,1,5)   
Derek.

Hi,
I've added request date and rec_date (both parsed) to the sqlquery button and it seems to be working okay.
Have a look at the attached.
Derek.