You are not logged in. Please login or register.
My Visual Database → Posts by gonpublic2k
Hello All!
It's been a long time. Wondering if anyone has done or tried to write a small script or app to have the user enter their username ( or not - can be hard-coded that part ) and password , and launch the web browser to log in to gmail automatically from the desktop.
I hear your inputs ....
Hello All MVD,
Enough is enough, for real , anybody know what happened to Dmitry? Is MVD support gone forever?
Please someone who knows the whereabouts of him let us know. The community needs to know the
truth. We want answers.
Hello Drivesoft,
would it be possible for you to release a new MVD version (v6.51) purely as a bug fix release please? Can you confirm that Drivesoft has the capability to do this as it looks increasingly like the original Dmitry is no longer involved and the risk for us releasing applications to customers is significant given the number of unresolved bugs and no response to these.
Thanks and regards
Dimitry is no longer supporting MVD?? Is this true?
here is it
Beautiful! - great man! thanks!!!
Hello All -
MVD Community, I've a question hoping you can help me out. Is there a function or command in the delphi script that can
concatenate part of a value in a combobox to display on a textbox when you choose the item in the combobox?
Let me explain, consider the following code:
procedure Form1_ComboBox1_OnCloseUp (Sender: TObject);
begin
Form1.Edit1.Text := Form1.ComboBox1.Text;
end;The above works fine displaying the text from the combobox into the textbox but what I just want to show in the description only a part of the combobox value that was chosen?
For example, the combobox value chosen is something like:
2.3.3..2.01 Paper products and miscellaneous
I want to show the numeric code in the left in the combobox and the description ONLY in the textbox.
Can this be accomplished?
Thanks in advance!!!
gonpublic2k wrote:brian.zaballa wrote:I got on how the password is being hashed. I just don't know if it is proper to post I here.
I'll email it to you
Hi, could you e-mail me this please??
leggin2020@gmail.com
I'd appreciate it , thanks!!!
Sent.
Thank you bro!
asawyer13 wrote:Hopefully MVD Dev will read this and have a solution.
Even disabling the encryption would be better than not being able to use it.
Alan
I got on how the password is being hashed. I just don't know if it is proper to post I here.
Hi, could you e-mail me this please??
leggin2020@gmail.com
I'd appreciate it , thanks!!!
Hello,
I found here on the forum this script
procedure frmFornitore_dtData_OnChange (Sender: TObject);
begin
frmFornitore.dtScadenza.date := frmFornitore.dtData.date + 30;
end;I understand what it does, but my question is how can i change it to increment in years not in days? I know that i can do it by write 365 instead of 30, but what if i want a 10 years increment?
Thanks
Hello,
If I understand it correctly, by using the same logic you explained I'd asume that it would be 3650
procedure frmFornitore_dtData_OnChange (Sender: TObject);
begin
frmFornitore.dtScadenza.date := frmFornitore.dtData.date + 3650;
end;10 years * 365 days = 3,650 days
Hi,
I'm puzzled why you needed to create a new version of your application.
I'm presuming (since you mention adding a combobox), that you'd created a new table (e.g. 'departments') with a field (e.g. 'department') and made a relationship between 'dailytasks' and 'department', none of which should have caused any problem even if your project already had data in it.
If you attach the old version of your project, I'm sure someone could take a look; I think this would be a simpler 'fix' rather than trying to import data to a new version.
Derek.
You're absolutely right Derek sorry about that, I figured it out after I thought about it a bit more deeper. It's all solved now. What happened in the beginning I was trying not to mess up the original project and started with a fresh new sqlite.db but when I tried importing the old data, ran into the problem described above. Then I learned that I could simply add this new feature without any hassle. Thanks as always!
Hi all MVD,
I have crreated an app, then put some data into it already. After a suggestion was made to add a combobox to permit the user select a department to add to their entry for a form, this introduced some problems so I created another version of the app with the same tables plus this new added feature of the combobox. What I tried to do, was to copy over the database that's already populated with data over to the new App. Basically I was using Browse SQLite to copy tables over the new database, the problem is, when I got to the part of a table that includes daily tasks and other things, gave me an error saying it couldn't complete the import because the table's columns don't match ( This because of the new combobox that adds the 'Department' part in the grid for the form. Is there a way to overcome this problem? Thanks for your help.
Hi,
I've added the status as a filter.
However, I've done this as a combobox and not as a separate button for each status because:
1. It would take up a lot more room so would need a redesign of the form.
2. It's probably better that your application has a consistency of filter type - I don't think it helps users to have a mix of filter types (sometimes a button, sometimes a combobox etc) if it can possibly be avoided.
Derek.
Thank youuuu!!!!!!!!!!!!!!
Hi,
Try it like this (see attached).
Regards,
Derek.
Very nice Derek, only one thing - what if I wanted to show by using a button for each state I guess, all completed, in progress and waiting?
just like the example you gave above that showed all items out of stock, low stock etc..
I just don't know how to get it done with the combobox part. Thanks!!!
Hi Popcornelnicusor, CDB. Salut Jean,
Hope you're all keeping well.
Another option (no script needed) is to use a calculated field to hold a 'stock status' flag (please see attachment 'conditional grid 1') which also gives the ability to sort and filter by 'stock status' which might be of use.
Or you could combine it with Jean and CDB's suggestions and colour the 'stock status' flag (please see attachment 'conditional grid 2').
Regards,
Derek.
Hello Derek, quick question about this - can this be adopted to the table grid on the report project you helped me out with the other day? Have the different states to show a color on the grid, example : green for COMPLETED, yellow for IN PROGRESS and red for WAITING?
Let me know how this can be implemented, please!!!
Hi,
I'm not using 6.5 so can't help with your first question.
With regard to the second question, have a look at the attachment (specificallly lines 105-120 in the script. You simply
1. write your own procedure to call your own 'about form'
2. call this procedure when form1.mniabout is clicked.
3. (optionally) rename the 'about' caption to something like 'About Me'
Set any menu option that you don't want to see to be visible := false (form1.mnioptions.visible := false etc etc)
Derek.
Wow! well Derek, you fixed both issues with that script! Styles applied and I can still see the menu, now with the options suppresed
as expected. Good job buddy! Always on point!
Much appreciated!
Hello all MVD -
I've noticed two things so far, don't know if it's a bug or just by design but if you apply a style to a role-based user database, you lose the menu in the main window. No matter if you logo as Admin, you can't see the menu to change password or administer other things. If you go back to the 'default' window then the menu reappears. That's one thing.
The other thing, is there a way to supress certain options in the menu for the role-based user schema? Let me explain, if I only wanted to show the option to change password and the option to close, how can I do this, is it scripted or how do I "shut off" these extra options that the user doesn't need. Also, is there a way to change the "About" option to a customized one.
Thanks!!
Hi Again,
Perhaps try doing it like in the attachment.
I've set up a couple of roles (more to future proof any thing you might want to do) but what drives 'who sees what' is whether the logged-in user is an administrator or not.
If the user is not an administrator, they can only see their own entries and they do not have access to any look-up tables or user maintenance.
If the user is an administrator, they can see all entries or filter entries by a specific user; they can also add their own entries, if relevant, and change entries made by others, if required. Only administrators will see the option to maintain look-up tables and maintain users.
The passwords (all in lower case) are the same as the user IDs
Hope this points you in the right direction.
Derek.
Wow! - Derek you're the best! - as always , much appreciated. Yes, this is something I can definetely work with, make a few adjustments and tweaks and I think it'll be superb for the project. I'm posting back the full-fleged application when it's done to help others out. Again, thanks Derek!
Hi,
Not sure if the attached is of any use.
It's an old application that I've just modified slightly with the sort of information you might need to hold.
You need to move the mouse to the bottom of the form to make the bounce-bar visible.
Feel free to hack it around and I hope it might give you some ideas.
Derek.
Hello All, Derek - one quick question about the profiles ... how could I make it so that each technician only sees their own notes? Having it sort of roles so that each technician can add their own notes but not see the others, this way ony one person (supervisor, manager etc.. ) will be the only one with access to see all notes from everyone and be able to print the report. I know it might involve modifying your script to add the role profiles and allowing or restricting views depending on the user, something in that direction, sort of. Not sure if I'm clear. Hope you can provide me with some guidance.
Thanks again!
Hi,
Not sure if the attached is of any use.
It's an old application that I've just modified slightly with the sort of information you might need to hold.
You need to move the mouse to the bottom of the form to make the bounce-bar visible.
Feel free to hack it around and I hope it might give you some ideas.
Derek.
Wow! Nice to see you as always Derek. Thanks for the response, this application of yours seems to be promising, I'll tweak it around a bit and
play with the controls and stuff to see if I can adapt it to what I need. Definetely points me in the right path. Again, thanks a lot for your support,
always willing to help out. Appreciate it. I'll post back with the progress to help others out tha might need something similar.
Glad to be back here!!
Cheers
Hello MVD community!
It's been a while since I've coded and now I have a project I need your help with
----------------------------------------------------------------------------------------------------------
I need a way to create a reporting tool, sort of a journal of daily tasks that each
technician needs to complete on a daily basis. At the end of the week , the
project manager can print out a report of the accumulated tasks for the whole
week, either individually ( by technician) or as a whole, giving him an overview
of what was done that week. This tool, needs to have the ability to be able to
allow copy and paste from Word or Excel documents, since most of the technicians
fill out their reports on either one of those formats.
I'm not sure how to begin, need help and suggestions. If there is something similar,
please point me in the right diection so I can reuse some of the code and adapt to
what I'm trying to create here.
All your help is greatly appreciated - Thanis!!
** UPDATE **
Hi all,
Well, after doing a little bit of research on the forum , I found this thread where the first part of the MySQL backup is
done. Good job @prahousefamily !!
http://myvisualdatabase.com/forum/viewt … 261#p21261
Now I just need to use the backup.bat archive that's created save and compress the MySQL database and mail it to specific e-mail addresses in MVD via a script. I need to be able to create an automated e-mailer that con grab the archive (##name##year-month-day.sql) and deliver it
to the addresses specified in the program. I need help with that part.
Thanks!
Hi, gonpublic2k
I started with writing dump.bat
rem date DDMMYY
set name1=%DATE:~0,2%%DATE:~3,2%%DATE:~8,2%rem time ( 10:00 and after)
IF "%time:~0,1%" LSS "1" (
set name2="0"%TIME:~1,1%%TIME:~3,2%
) ELSE (
set name2=%TIME:~0,2%%TIME:~3,2%
)mysqldump.exe --host=192.*.*.* --port=3306 -uUSER -pPASSWORD plan >d:\MySql_Plan\Arc\plan%name1%_%name2%.sql
"c:\Program Files\Total Commander\Plugins\arc\Rar.exe" m -ep d:\MySql_Plan\Arc\plan%name1%_%name2%.zip d:\MySql_Plan\Arc\plan%name1%_%name2%.sql
Try it
Hi, thanks for sharing. I'm not sure if it's something with the long name path that you shortened with the " ~ " character but this does not
work. I'm trying to see if I can write a batch that will do the dump for now and use that within MVD to call it as an external program.
Hello All MVD community,
I need your help with a script to backup a SQL database and compress it into a RAR or ZIP format to be send out
by e-mail. The process should take a SQL database saved from MySQL Manager and compress it to be sent out
to specific e-mail addresses. Don't know where to start 
Thanks in advance!
DriveSoft wrote:May be you should use Installer for that, where you can tune privilege, example
http://myvisualdatabase.com/forum/viewtopic.php?id=3174Thank you very much. I will give it a try.
I was equally reading through some articles online and it made suggestions to the use of .manifest and .rc files that will help run the application as administrator. This was done using Delphi but I'm wondering if this could be implemented in MvD?
https://stackoverflow.com/questions/309 … pplication
Thank you once again Dmitry.
Hi Humbielion,
Adding to what you said here's another resource that can help you with this task:
"Compatibility" tab > "Run this program as an administrator"
Thanks for the correction Dmitry, that's what I was trying to communicate.
My Visual Database → Posts by gonpublic2k
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi
