Use Vista UAC Maker to make your exe run as administrator before using inno to make the installer

2

(6 replies, posted in General)

thezimguy wrote:

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

(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

(6 replies, posted in General)

Hello family, any help on this topic?
Thanks

5

(10 replies, posted in SQL queries)

rbknathan wrote:

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

(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.

7

(2 replies, posted in General)

Thank you

8

(2 replies, posted in General)

Hello Derek, family,
Please, how do I use transaction in MVD using MySQL database. Thank you.

9

(2 replies, posted in General)

Thank you Derek
It solved it

10

(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

11

(4 replies, posted in SQL queries)

See attached

12

(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

(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

(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

(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

(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

(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

(4 replies, posted in General)

Thank you
It working now

19

(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

(4 replies, posted in General)

Please see attached.
I tested it with version 6.3beta
Thank you.

21

(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

(4 replies, posted in General)

Can you attach your project?

23

(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

(8 replies, posted in General)

chanthait wrote:

Hi Team

the table grid error text. pls see picture in rar file.

See attached

25

(1 replies, posted in General)

manixs2013 wrote:

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