176 Reply by john

  • john
  • Member
  • Offline
  • Registered: 2020-07-30
  • Posts: 38

Re: What to implement first?

Hi All,

Anyone on here know how to execute an external program, for example a database full of pdf and tiff files names and drive location, On click load pdf viewer and display the filename stored in the database.

Thanks in advance.

177 Reply by CDB (edited by CDB 2020-09-21 18:57:00)

  • CDB
  • Member
  • Offline
  • Registered: 2019-12-16
  • Posts: 356

Re: What to implement first?

Here is the code I use.  Windows will automatically open the registered application according to file type. Amend to your own circumstances.


To open a file displayed in a tablegrid by double clicking  on a row.

procedure frmMain_tgDatasheets_OnCellDoubleClick (Sender: TObject; ACol, ARow: Integer);
var
  fName :string;
begin
  fName := SQLExecute('SELECT DISTINCT datasheetFile_Filename FROM Datasheets WHERE id = '+frmMain.tgDatasheets.SQLValue);
  OpenFile(fName); 
end;

If you are using a tablegrid to display the database entries, then just set that up using the standard tablegrid wizard in VDB.


I've attached an image of my program displaying two rows of information. Clicking on either of them will open a different document. One is a PDF and the other is a text item.

Post's attachments

Attachment icon display_items.PNG 9.79 kb, 152 downloads since 2020-09-21 

On a clear disk you can seek forever
  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 363

Re: What to implement first?

Good Day MVD Devs.

I got an idea on the password being implemented in User-Role feature. I successfully determined the hash being used in it and will help me in my future development when I have to reset user's password, have an auto-generated password etc. But for the other developer who doesn't know how that password is being hashed/encrypt will bump to a dead-end. I think it is much better to encrypt the password using the EcryptRC5 Function and let the Key disclosed/editable to the developer or make it as a property or a setting something like that. In that way, it is more secure for the password and less hassle for the developer.

Thank you and looking forward for the next update. Please do notice us. smile

brian

179 Reply by john

  • john
  • Member
  • Offline
  • Registered: 2020-07-30
  • Posts: 38

Re: What to implement first?

Many thanks CDB, sorry for the late reply.

John

180 Reply by haciamirumbo (edited by haciamirumbo 2021-08-16 01:21:25)

  • From: Tampa FL
  • Registered: 2021-07-13
  • Posts: 22

Re: What to implement first?

I think version 7 could include two form wizards. The first one is from a single table and the second one from one to many tables. Similar to the form wizard that is included in MS Access and Libre Office.

Form duplication or make a copy. Let's say we have several tables and forms that are almost the same. For example, teachers, students, doctors, nurses, helpers, volunteers, and all of them have lists view forms and data input forms. It would be great if once we created one form we could make copies changing the form name, then we just have to change the fields and labels.

If possible, fully integration or deployment to the MS surface tablets

Post's attachments

Attachment icon form_wizard.png 186.67 kb, 97 downloads since 2021-08-15 

haciamirumbo's Website

  • From: Tampa FL
  • Registered: 2021-07-13
  • Posts: 22

Re: What to implement first?

Version 7.5 or 8. SQL query wizard or query builder similar or better to FlySpeed SQL. I am learning SQL and I think this could help a lot. I have read a lot of questions and corrections from the forum moderator that basically are SQL mistakes. MVD has an expression editor similar to the picture attached but you have to know SQL.

Post's attachments

Attachment icon SQL_query_wizard.png 99.39 kb, 124 downloads since 2021-08-15 

haciamirumbo's Website

182 Reply by haciamirumbo (edited by haciamirumbo 2021-08-16 01:07:24)

  • From: Tampa FL
  • Registered: 2021-07-13
  • Posts: 22

Re: What to implement first?

Could MVD has the magical undo function in the menu or taskbar button? wink

Today I deleted from a form by accident 10 labels, with text boxes, grid, and buttons and when I realized that I was deleting from the wrong form it was too late, I have to redo the form again which was not a big deal but I would have a big smile if MVD had an undo function. ( It is not MVD's fault for human mistakes).

Post's attachments

Attachment icon undo.png 3.5 kb, 97 downloads since 2021-08-16 

haciamirumbo's Website

  • Registered: 2021-10-19
  • Posts: 1

Re: What to implement first?

I like how often updates are released, especially version 7.5 and 8

  • Registered: 2014-06-25
  • Posts: 684

Re: What to implement first?

AD1408 wrote:

Desprately looking for.......


App. custom exe icon applied via form1 properties
////////////////////////

Do you think this could happen one day? Using a custom .ico file via a property for the forms?

185 Reply by k245 (edited by k245 2022-08-02 06:01:01)

  • k245
  • k245
  • Member
  • Offline
  • From: Deep
  • Registered: 2017-10-12
  • Posts: 1,117

Re: What to implement first?

tcoton wrote:
AD1408 wrote:

Desprately looking for.......


App. custom exe icon applied via form1 properties
////////////////////////

Do you think this could happen one day? Using a custom .ico file via a property for the forms?

I don't think it will ever happen. Icons in an application are a built-in resource that gets inside when the executable is compiled. There is no compilation of the executable file in MVDB, it is renamed from DLL to EXE.


Use this tool for change icon after first run an application, when executable file is appear:

http://www.angusj.com/resourcehacker/

Визуальное программирование: блог и библиотека.

k245's Website