Hello Derek. I do not know what your attached example does. Can you please gif some more info
27 2020-11-27 20:38:49
Re: Presenting user data (7 replies, posted in Script)
Hallo Jean, thanks for your reaction. Yes it is very simple. II just want present some of the information from the table “_user “ (part of user&rules). I tried the script entry: “form1.label1.caption := _user.role” to present the role on form1, but it did not work. Can you help me?
28 2020-11-27 10:17:37
Topic: Presenting user data (7 replies, posted in Script)
How can I present user data on a form like:
Username : admin
Userrole : admin
Last loging: 02-12-2020
etc.
Application.User.Username;
Application.User.Email;
Application.User.First_name;
Application.User.Last_name;
Application.User.Role;
Application.User.RoleId;
Application.User.is_admin;
Application.User.is_active;
Application.User.is_logged;
Application.User.Last_login;
Application.User.Date_joined;
29 2020-11-24 13:34:45
Re: File handling (4 replies, posted in General)
Hi George. Sometimes I feel the same. Your not alone.
30 2020-11-23 15:36:56
Re: Mysql connect by script (7 replies, posted in Script)
Hello Brian, thanks very much for your contribution. In my ignorance I just copied the "connection script" to the existing script. I also changed: Form1.TableGrid1.dbUpdate. Now I can also see all records. Thanks again.
Hopefully my question to MVD develeptors (e.g.Dmitry): "how can I translate menu "Change your own password" and translate the upcoming forms", will be answered
31 2020-11-23 13:39:10
Re: Mysql connect by script (7 replies, posted in Script)
Hallo Brian. I used thuis script. It dit not work. See my post.
32 2020-11-23 13:20:07
Topic: Mysql connect by script (7 replies, posted in Script)
See enclosed project (without .ddl and .exe) It works fine. I connect to mysql-server and next to MVd (admin/admin). Now I want to connect to mysql-server by script. I used the script as mentioned in "mysql.txt" but 1) I do not know if I am connected to the server and 2) the loginform to MVD (admin/admin) does not appear. What am I doing wrong? Can please someone help me to get it working?
To MVD develepors (Dmitry): how can I translate menu "Change your own password" and translate the upcoming form.
33 2020-11-16 06:49:51
Re: Connect to MySql (10 replies, posted in General)
Hallo Brian and Jean. Thans for your contributions, but it is a pitty that my questions stay unanswered. I asked Brian for explaination about external file, hadden label and form and more security and I do not know how to use the form of Jean.
34 2020-11-14 12:01:54
Re: Connect to MySql (10 replies, posted in General)
Hi Jean, For me the connectform is fine
35 2020-11-13 09:31:06
Re: Connect to MySql (10 replies, posted in General)
Hey Jean. Thanks for your contribution. In my opinion the login form for MySql is generated automaticly by MVD? How can I generate my own form to connect ot my server? Maybey it's a stupid question, but a small example would certainly help.
36 2020-11-13 08:12:47
Re: Connect to MySql (10 replies, posted in General)
Hello Brian. Thanks very much for your answer and I will try to login to my mysql-server by script. But I donot understand your following instructions/advice: "In that way you can use external file, a hidden label on a hidden form (which I'm using) to read the server details for additional security" Can you please make a short example of 1) external file", 2) hidden label on hidden form etc.
37 2020-11-11 10:49:45
Topic: Connect to MySql (10 replies, posted in General)
Good morning.
I finaly succeeded to connect to a MySql server and I also have made a simple database
- Is it possible to translate the captions (Server (host), Port, User ..) on the connection form? (see connect .jpg)
- Is it possible to use User/Role function when I use MySql ?
38 2020-09-01 18:54:17
Re: MVD (12 replies, posted in General)
Drivesoft only says they are working on new documentation, No word on a new version.
39 2020-06-16 18:39:41
Re: Translate form 'Change your password' (14 replies, posted in General)
Hi Jean, I already use it. Thans for your topic
40 2020-06-16 09:55:32
Re: Translate form 'Change your password' (14 replies, posted in General)
Hi Derek. I remembered the same question I asked when 6.3 arrived. Because I want A Dutch version of my programs I am always interested in translation possibillities.
41 2020-06-16 06:47:41
Re: Translate form 'Change your password' (14 replies, posted in General)
42 2020-03-27 10:57:24
Topic: User and roles change login form (3 replies, posted in General)
When I use “users and roles” a standard login form is presented. In a earlier stadium the question is asqued when we could change this form to our own wiches. Any idea?
43 2020-03-27 10:56:09
Re: Button -> Tabsheet (5 replies, posted in General)
As allways, thanks very much
44 2020-03-27 09:59:09
Topic: Button -> Tabsheet (5 replies, posted in General)
Good morning everybody. Is it possible that when i press a button: a specific tabsheet on a specific pagecontrol on a specific form will open?
45 2020-03-21 07:00:16
Re: Duplication of Entry (13 replies, posted in Database applications)
Hello Derek and Ehwagner.
Both thanks for your reaction. For Ehwagner the changed project is enclosed. Derek is will study your project.
46 2020-03-20 13:33:16
Re: Duplication of Entry (13 replies, posted in Database applications)
Dear Ehwagner. I used yor application, added the fields "Address" and "City". Deletedmyour records en add two new records. So far all is well, but changing an address is impossible, because the programm doesnot recognize that this is not adding a new record and displays the massagebox. Do you have a solution
47 2020-03-12 09:26:05
Re: Calculated field (2 replies, posted in General)
Derek, thanks again. It works perfectly
48 2020-03-10 13:28:58
Topic: Calculated field (2 replies, posted in General)
I use the following Calculated Field in the table "Deelnemer": ifnull(d_naam,'')||', '||ifnull(d_roepnaam,'')||' '||ifnull(d_tussenvoegsel,'')||' - '||ifnull(strftime('%d-%m-%Y', d_geboortedatum),''). So I can perform an incremental search on the 3 fields.
Now I want to know if it is possible to include one or more fields from a diifferent table in the Calculated Field.
49 2020-03-02 11:44:56
Re: Prining record (8 replies, posted in Reports)
Hello Derek. Thank you very much for your contribution. It was clarifying. But one question. In your fixed project I do not see the records of the "deelnemers" anymore in tablegrid2 or tablegrid3 when I select one "deelnemer" in tablegrid1
50 2020-02-28 15:06:15
Re: Prining record (8 replies, posted in Reports)
Hi Dmitry. Because I wanted to know more about reports I yesterday printed page 79 to 93 from your book and followed the first example. As you can see on page 81 under "1. Select the components ...etc" there is mentioned "Tablegrid1". So I followed this example. The MasterData band is not mentioned in the first example. In example two it is mentioned on page 89, figure 82..
Thank you for your advice.