Use Vista UAC Maker to make your exe run as administrator before using inno to make the installer
1 2021-01-09 09:37:59
Re: I used inno setup to create a install file MVDB program but get error (3 replies, posted in General)
2 2021-01-09 09:28:36
Re: LinkedFile of DBImage with MySQL (6 replies, posted in General)
Hello family,
Please, is there any workaround for the problem below?DBImage with Type LinkedFile and Copyto functions when MVD uses SQLite but when the same project is converted to use MySQL Database, the following stops working;
CopyTo do not copy the file to the specified diretory
the photo_filename saved in the database is original link to the file but not the CopyTo Directory link
Thank you.
Any update on this topic?
3 2020-09-08 17:24:56
Re: LinkedFile of DBImage with MySQL (6 replies, posted in General)
Thank you Brian, but that is the whole idea. I want only the server machine to access such images so I would prefer saving them into a folder on the server machine.
4 2020-09-07 19:46:30
Re: LinkedFile of DBImage with MySQL (6 replies, posted in General)
Hello family, any help on this topic?
Thanks
5 2020-08-14 13:20:46
Re: SQL query working outside but no in MVD (10 replies, posted in SQL queries)
Using the below query I am trying to populate the data in dropdown which list the list of tables in sqllite db.
SELECT ROW_NUMBER() OVER (ORDER BY name) as id, name FROM sqlite_master WHERE type="table"
But this is working if run i sqlite manager. But in MVD its show as syntax error.
How to get this query running in MVD ?
Just update the default sqlite3.dll that came with MVD to the current version and it will work. I tried to attach the current sqlite3.dll but upload was refused.
The version that came with MVD do not support functions like ROW_NUMBER(), RANK() etc.
https://www.sqlite.org/download.html
Download the 32 bit version for windows
6 2020-08-12 12:02:01
Topic: LinkedFile of DBImage with MySQL (6 replies, posted in General)
Hello family,
Please, is there any workaround for the problem below?
DBImage with Type LinkedFile and Copyto functions when MVD uses SQLite but when the same project is converted to use MySQL Database, the following stops working;
CopyTo do not copy the file to the specified diretory
the photo_filename saved in the database is original link to the file but not the CopyTo Directory link
Thank you.
8 2020-08-09 20:54:25
Topic: MySQL Transaction (2 replies, posted in General)
Hello Derek, family,
Please, how do I use transaction in MVD using MySQL database. Thank you.
9 2020-08-07 15:45:01
Re: [SOLVED] Multi relationship field (2 replies, posted in General)
Thank you Derek
It solved it
10 2020-08-07 11:47:15
Topic: [SOLVED] Multi relationship field (2 replies, posted in General)
Hello guys,
How do I work around this
I have a database with two tables
Users and duty
The user table has columns:
Full name
id_duty1
id_duty2
id_duty1 and id_duty2 are relationships from table duty
How do I produce data in the tableGrid shown in the attached picture
Thanks
12 2020-08-06 18:00:50
Topic: How to reduce bsCommandLink font size (0 replies, posted in General)
Hello family,
Is there a way to reduce a button font size of a button with bsCommandLink style?
Thanks
13 2020-08-06 11:05:14
Re: [SOLVED] TableGrid Events not working (17 replies, posted in General)
procedure frmRegister_tGrid_OnAfterEdit(Sender: TObject; ACol, ARow: Integer; Value: String);
begin
ShowMessage('Its working');
end;
The above onAfterEdit event is not triggering on a tableGrid.
Thank you
14 2020-08-04 08:57:27
Re: MySql Online Error Msg (3 replies, posted in General)
There is nothing wrong in the table name being appended to the database name
Check whether the table schedule exists or attached your project.
15 2020-08-02 21:36:15
Re: What to implement first? (187 replies, posted in General)
Hi family, Dmitry,
Please, is there any chance that MVD will support the following soon?
1. Creating views in MVD.
2. Options buttons
3. Run time privileges editor for users with multiple privileges
Thank you
16 2020-03-31 06:47:49
Re: User and roles change login form (3 replies, posted in General)
Hello Dmtry, Derek and MVD lovers,
How do I show the login form again to implement a logout when using the inbuilt login form.
Example
_user.show
Thank you
17 2020-03-22 18:19:48
Topic: Possible Bug (2 replies, posted in General)
Hello Dmtry,
Please check this for me
1. Why does the form shown with action: "Show Form" not loose data on form close?
2. The sqlValue of an Edit comes within quotes when the form is shown with action : "Show Record"
Thank you.
18 2020-03-10 04:51:49
Re: TextHint not showing on New Record (4 replies, posted in General)
Thank you
It working now
19 2020-03-07 11:06:44
Re: Login:Wrong username/password (7 replies, posted in General)
Follow this steps
1. Login with
Username:admin
Password:admin
2. Goto "Options" in the menu and click on "Users"
3. Double click the user(eg. an) you are not able to login with to edit
4. Click on change password
5. Provide the password you want to use
6. Close the application and login with the user
It worked for me
I think forgot the password you created for the accounts
20 2020-03-06 21:59:29
Re: TextHint not showing on New Record (4 replies, posted in General)
Please see attached.
I tested it with version 6.3beta
Thank you.
21 2020-03-06 16:23:47
Topic: TextHint not showing on New Record (4 replies, posted in General)
Hello Dmitry,
Please, can you take a look at the action (New Record)?
It prevent the TextHint of controls not to show.
Thank you
22 2020-03-04 06:12:36
Re: Time format Issue (4 replies, posted in General)
Can you attach your project?
23 2020-03-04 06:09:05
Re: error text (8 replies, posted in General)
In the search button, you were referring to id_vender and id_department. These are just foreign keys and are integers. The main data is in the department and vender table so you need to reference them instead.
24 2020-03-04 06:06:07
Re: error text (8 replies, posted in General)
Hi Team
the table grid error text. pls see picture in rar file.
See attached
25 2020-03-04 05:37:58
Re: RANK (1 replies, posted in General)
Hello MVD
Please help how to get RANK. I need a sample please!
Thanks a lot!
Manixs
http://myvisualdatabase.com/forum/viewtopic.php?id=4512
Follow this post