51 Reply by asawyer13

(7 replies, posted in General)

This problem is preventing my friend from purchasing MVD as he has quite a few existing tables in the database that he would want to add to his mvd project.

Hopefully there is a way to resolve this.

Thanks in advance.

Alan

Go to forum: General

52 Topic by asawyer13

(5 replies, posted in General)

I understand that as of now, the login form can't be changed if I am using Roles.

Is it possible to use Roles, but create my own login form???

Somehow the app would have to open my login form, rather than the default. Is this possible?

I don't know what my login form would have to do to still allow the use of Roles..

Is there a better way?

Thanks
Alan

PS. The reason I want to create a custom login is that I want to add a forgot password and possibly a registration option to the login screen.

Go to forum: General

53 Topic by asawyer13

(1 replies, posted in General)

Is it possible if I have a text box that the user enters information into, I want the user to be able to include wildcards. like % for multiple characters and _ for a single character.

So if the user enters %apple% in the description field, once he searches he would see data where the description field contained the string apple anywhere in the description.

Of if they enter A_3% and did a search it would get descriptions that start with A then some character then a 3 and then any number of characters.

I am just not adept at MVD yet to know how to do this, but I'm working on all the things I need my app to be able to do, so that I will actually know how to do things.

Thanks
Alan

Go to forum: General

54 Topic by asawyer13

(1 replies, posted in General)

I will apologize now as I could have sworn I saw code to do this somewhere in the forum but I can't find it now.

I want the user to enter data in a text box, and have some sort of autosuggest or autocomplete occur so has the user types, the list of possibilities gets smaller. I see I can do it against a tablegrid, but I don't want to use a tablegrid for this.

As I said, I could have sworn I saw some code before, but I can not find it.

Thanks in advance for any help.

Alan

Go to forum: General

55 Reply by asawyer13

(3 replies, posted in General)

DriveSoft wrote:

It's planned.


Dmitry,
I am wanting to create some form of Registration page.

I then want to send the user an email with a activation code in it.

I would like to add this activation code as a field on the login screen for the first time to make sure it's the right user.

Is there a reasonable way to do this?? If not, I am using Roles, is there a reasonable way to create my own login screen??

Sorry for all the questions, but I'm starting to get deeper and deeper into MVD and I have things to do.. lol

Alan

Go to forum: General

56 Reply by asawyer13

(7 replies, posted in General)

As soon as I connect to the mariaDB database and before I do anything on a new project the tables.ini file is empty.
There is no dbschema.ini file at all.

As soon as I click on the dbschema button, it creates an empty dbschema.ini file. The tables.ini file is still empty.

Now I will add a new table inside MVD.

I added a table called Apple..

The tables.ini file now contains
[apple]
isdictionary=0
-Name=TEXT


and the dbschema.ini is still empty.

When I click on the dbschema button, it adds to the empty dbschema.ini file so it now says

[main]
xdbdiagram_apple=30
ydbdiagram_apple=10
wdbdiagram_apple=110
hdbdiagram_apple=130


Hopefully that helps?

Go to forum: General

57 Topic by asawyer13

(7 replies, posted in General)

I am using MariaDB V10.2.14

I can connect to it in MVD just fine. I can add a new table thru MVD and it shows in the application when I view the Database Schema it only shows me that one table that I added. All the existing tables that are in the database aren't showing.

I am using MVD 6.4

Am I doing something wrong, or is there a way to load all the tables into the "Show the database schema"

Thanks
Alan

Go to forum: General

58 Reply by asawyer13

(3 replies, posted in General)

Would that affect all forms, etc in the application?

Thanks

Go to forum: General

59 Topic by asawyer13

(0 replies, posted in General)

Can I get the command line info when my app is run?

For example
Myprgram.exe /file=xyz.txt

Or some similar syntax

Thanks
Alan

Go to forum: General

60 Topic by asawyer13

(3 replies, posted in General)

I want to create a SAAS like app. I want the user to login and then depending on a value in their user record, I want to close and open a different database with that users info in it.

Can this be done?

Alan

Go to forum: General

61 Reply by asawyer13

(8 replies, posted in General)

Anybody checked out https://www.createinstall.com/?

The free version claims it does autoupdating.

I have not used it, but might try.

Go to forum: General

62 Reply by asawyer13

(8 replies, posted in General)

Does inno setup have a way to automatically update the mvd exe when a new version of the software is uploaded to my server?

I am trying to determine what the best installer/updater to use to distribute and update my app would be.

Thanks
Alan

Go to forum: General

63 Reply by asawyer13

(6 replies, posted in General)

What database are you using?

Go to forum: General

64 Reply by asawyer13

(6 replies, posted in General)

You could probably create a database trigger to copy the data.

Go to forum: General

65 Reply by asawyer13

(4 replies, posted in General)

Also you can look at TSPlus. It allows desktop apps to be run from the web.
It works well for what I'm needing at this point.

Go to forum: General

66 Reply by asawyer13

(2 replies, posted in General)

Thanks, I can make that work

Go to forum: General

67 Topic by asawyer13

(0 replies, posted in SQL queries)

Is it possible to execute a MySQL and get values back?

I'm new to MVD and trying to think of all the things that I need to be able to do to properly create the apps that I'm wanting to create.

Thanks in adavance

Alan

Go to forum: SQL queries

68 Topic by asawyer13

(1 replies, posted in General)

Can a button be added to a tablegrid cell to do something special when clicked on?

I would be interested in changing the color of the button based on other data in that row also if possible.

Thanks

Go to forum: General

69 Topic by asawyer13

(2 replies, posted in General)

Is there a way to highlight required fields that are empty on a form? Something like a red border?

Go to forum: General

70 Topic by asawyer13

(1 replies, posted in General)

I am wondering what people are using to Auto Update an MVD app that you're distributed in the world but need to update with a new version.

I know there are a fair amount of options, but curious if people are actually using Astrum, Advanced Installer, wyBuild, etc.

It would be nice to have one product that will do the install and update if possible so I don't have to build anything special.

Thanks in advance,
Alan

Go to forum: General

71 Reply by asawyer13

(5 replies, posted in SQL queries)

I will probably be using Sqlite for some projects. I'm used to MySQL which has stored procedures and I want to use them extensively I think.

Is there a reasonable way to put SQL scripts and logic in either the database or something where I can sort of create a set of stored procedures and run them in MVD upon record update, or insert, or for validation.

Brand to to MVD so hopefully this is not a dumb question.

Go to forum: SQL queries