You are not logged in. Please login or register.
My Visual Database → General → 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.
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.
display_items.PNG 9.79 kb, 269 downloads since 2020-09-21
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. 
Many thanks CDB, sorry for the late reply.
John
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
form_wizard.png 186.67 kb, 228 downloads since 2021-08-15
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.
SQL_query_wizard.png 99.39 kb, 241 downloads since 2021-08-15
Could MVD has the magical undo function in the menu or taskbar button? 
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).
undo.png 3.5 kb, 220 downloads since 2021-08-16
I like how often updates are released, especially version 7.5 and 8
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?
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/
i have make a database and a add form, so the instruction was given at myvisualdatabase.com. now, i start with add after i push the green triangle for activate the database. now when ik push the button add happend olmost nothing. my add form is activate but stay on the background and come not in the front, what do i wrong. can somebody help me
Hi,
Can you attach your project (delete the .exe file and then zip the rest of the application folder).
You can also post messages in your own language - most of us use Google Translate so it's not a problem.
Derek.
Было бы классно внедрить яндекс карты. С возможностью добавление меток. Google карты сейчас не работают в проекте. Очень жаль. Но спасибо за те функции которые уже внедрены.
My Visual Database → General → What to implement first?
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi